Merged Cells

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I have a worksheet that someone else set up but doesn't
work here anymore.
I keep getting an error message saying that there are
merged cells and I can't sort or do anything like that.
I can't find any merged cells but I am sure there must be
some.
Is there any way to find them or get rid of the problem in
another way?
Any help would be appreciated!!

Amy
 
Amy

one way is to select all the cells on the sheet (click on the grey square at
the top of the row numbers and to the left of the column headings). Then
select Format | Cells... | Alignment Tab and then clear the Merge Cells
option (it will be half grey as some cells will be merged, others won't).

Take care though because this could screw up the presentation of the data.

Regards

Trevor
 
Assuming you have no other merged cells you want to keep
merged, just click on the box in the top left corner of
your sheet to select the whole sheet. Right click there,
format cells. On the Alignment tab you will see a semi-
greyed out "Merge cells". Click on it until it is
unchecked (probably twice) and then hit ok.

Drabbacs
 
Start by using a copy of the original. Select the entire
data table your dealing with for sort purposes or if
they're using a named range use that. Once selected choose
Format->Cells->Alignment Tab-> Uncheck the "Merge cells"

Now attempt your sort. Please don't use the original file
because there may be some unexpected results. Better safe
than sorry.

Excel Support Technician
www.canhelpyou.com
 
Back
Top