Finding/Detecting merged cells in excel

Find merged cells

Sometimes worksheets have merged cells that you don’t know about. This can get frustrating because Excel can’t sort data in a column that has merged cells. But you can find all the merged cells in your worksheet with the Find command, and then unmerge those cells.

  1. Click Home > Find & Select > Find.
  2. Click Options>Format.

Find dialog box

  1. On the Alignment tab, under Text control, check the Merge cells box, and then click OK.

Check the Merge box

  1. Do one of the following:
  2. Click Find Next to find the next merged cell.
  3. Click Find All to see a list of all merged cells in your worksheet.

Find all merged cells

When you click an item in the list, Excel selects the merged cell in your worksheet.

Advertisements

Exporting Remote Oracle Database when host and port address are provided

To export a remote oracle DB we can use an alias from tnsnames.ora, or provide a connection string in a similar format :

exp user/password@host:port/service_name

Note that this requires the service name of the database, which might not be the same as the SID. We can get the services by running lsnrctl services on the remote server or by querying the v$parameter view , or by asking the DBA for the remote server.

The connection options are the same as for any other tool, so if we can connect to the remote database using SQL*Plus then we can use the same connect string for exp.

If you’re using @database to connect to a local instance then that is probably already defined in your tnsnames.ora, and you could add entries for the remote database there too.

Also, if you’re not still on an old version (pre-10g), you should use datapump (expdp) rather than the old exp tool.

The ThemeShaper WordPress Theme Tutorial: 2nd Edition

ThemeShaper

Preface

Many of you have written or commented to tell us how much you liked Ian Stewart’s original tutorial, “How To Create a WordPress Theme: The Ultimate WordPress Theme Tutorial”. You’ll be happy to learn that that we’ve created a second edition of the tutorial! Just like last time, you can expect one new lesson each day. What’s changed in the second edition? Keep reading to find out!

What’s new in the Second Edition:

  • Updated code samples that draw from the Underscores (_s) starter theme.February 2012 marked the release of the Underscores (_s) starter theme, and since then, it has gathered plenty of momentum. The code samples and file structure for the theme we’re going to create in this tutorial will draw from _s as a source of modern code that reflects current best practices.
  • New Lessons.Developing Your Theme Sense is worth reading if you’re…

View original post 729 more words

Create a free website or blog at WordPress.com.

Up ↑