View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Error rsp about merged cells being sized ?

CTRL + a(twice in 2003) to select all cells.

FormatCellsAlignment. Uncheck the "merge cells" option.

I would do this on a copy of the sheet. Don't know what your data will look
like once the cells are "unmerged".


Gord Dibben MS Excel MVP


On Mon, 5 Mar 2007 20:34:25 -0500, "Bubey" wrote:

I downloaded my cell phone bill in Excel so I
could sort as I
wanted. When I tried to do a Data/Sort/Col A, I
got the
following info/error from my Excel assistance.

"The operation requires the merged cells to be
identically sized"

What should I be doing to unlock the cells so they
can be
sorted?

Thanks !