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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s