Prev: sorting grouped cells
Next: Using spreadsheet to fill in forms
From: Lori on 16 Mar 2010 13:58
I did not create the worksheet, but need to sort the data. Get a message
saying " This operation requires the merged cells to be identically sized"
An excell newby, and help doesn't help. Help??
From: Gord Dibben on 16 Mar 2010 14:29
Get rid of the merged cells which cause no end of problems.......one of
which you just encountered.

2003...........Format>Cells>Alignment>Uncheck "merge cells"

2007...........Home>Format>Format cells>Alignment.

Or Home>Alignment section>Open Merge dropdown and "Unmerge cells"


Gord Dibben MS Excel MVP

On Tue, 16 Mar 2010 10:58:01 -0700, Lori <Lori(a)discussions.microsoft.com>
wrote:

>I did not create the worksheet, but need to sort the data. Get a message
>saying " This operation requires the merged cells to be identically sized"
>An excell newby, and help doesn't help. Help??

From: Gary Brown on 16 Mar 2010 14:35
Your headings probably have merged cells.
You can either...
- take the merge off the cells (FORMAT > CELLS > ALIGNMENT > click off the
'Merge Cells' checkbox)
or
- do your sort without the headings rows (DATA > SORT > click on 'No Header
Row').
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Lori" wrote:

> I did not create the worksheet, but need to sort the data. Get a message
> saying " This operation requires the merged cells to be identically sized"
> An excell newby, and help doesn't help. Help??
 | 
Pages: 1
Prev: sorting grouped cells
Next: Using spreadsheet to fill in forms