Can't sort a sheet with merged cells.

[pilotgal8]

I have a fairly simple sheet that I'm trying to sort (and have in the past) using Data/Sort on 3 columns.

I do not know what a 'merged' cell is, so have no knowlingly formatted a cell as 'merged'. I have populated some cells with information copied from other applications, so they may be 'merged'.

When I try to sort I get the message: - this operation requires the merged cells to be identically sized. to avoid this behavior, unmerge all the merged cella in the range or....

How the heck do I even find the merged cells that are causing the problem?

Thanks for any assistance.

 

[Andrew Poulsom]

Welecome to mrexcel.

Select all the cells, right click, choose Format Cells and on the Alignment tab make sure that Merge cells is unchecked (it should be in a semi-checked state).

 

[VoG]

Hi. Try this http://www.mrexcel.com/forum/showthread.php?t=335123

 

[pilotgal8]

Isn't there a way to use the Excel functions to do this. The post you referenced was not a solution for the orignal poster.

 

[Andrew Poulsom]

Did you try what I suggested?

 

[1cyril1]

See this also: http://www.mrexcel.com/forum/showthread.php?t=74144

To find a merged cell in Excel 2003.

1. Open a Find and Replace Menu.
2. Next to the Find What Field is a Format Box, Click it.
3. This opens the Find Format Menu screen which looks very similar to the Cell Format Tabs and screens
4. On the Alignment Tab, remove any ticks in the Wrap Text or Shrink to Fit boxes.
5. Leave a tick in the Merge Cells Box and click the OK Button to return to the Find and Replace screen.
6. Now click the Find All Button and ALL merged cells are shown in the lower window and are selectable to jump to their location.