Sorting merged cells
 

I am working on a databse another person created. When I go to sort it
keeps telling me all merged cells must be the same size, how do I fix
this so that I can sort my data?

Sorting merged cells
 

Get rid of those merged cells???????

wrote:

I am working on a databse another person created. When I go to sort it
keeps telling me all merged cells must be the same size, how do I fix
this so that I can sort my data?

--

Dave Peterson

Sorting merged cells
 

Rebecca
Merged cells suck. They cause all kinds of problems, and about 95% of
the the time what whoever merged them wanted to accomplish could have
been accomplished by centering a simple text cell across a couple
columns. There is a really good chance you can simply get rid of
merged cells without losing anything. If you can't, you have a
problem.
Good luck.
Ken



wrote:
I am working on a databse another person created. When I go to sort it
keeps telling me all merged cells must be the same size, how do I fix
this so that I can sort my data?

Sorting merged cells
 

Unmerge the cells:
Highlight all cells by clicking the blank box at the intersection of the
column and row markers (The places labled 1,2,3 A,B,C etc along the sides).
Hit CTRL+1 and go to the alignment tab. Uncheck 'merge cells'.

The cells should now be unmerged, but this may have left blank spaces (no
data was deleted, these cells were 'hidden' by the merge and could not have
contained anything). Delete those blank spaces, taking care to not delete a
cell and shift the data without shifting the corresponding data in the same
way.

Your sort should now work properly.

" wrote:

I am working on a databse another person created. When I go to sort it
keeps telling me all merged cells must be the same size, how do I fix
this so that I can sort my data?