Sorting merged cells of differant sizes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have at least 4 columbs and an varable amount of rows to deal with.

Trying to sort my data by first columb only I get error message of:
requires the merged cells to be identically sized.

I then formatedd all rows heights to 14 and columd widths to 9.
Received same error message. Any insight please?
 
You need to get rid of those merged cells. They cause nothing but grief,
and the same effect can usually be had by using Format / Cells / Alignment
tab / Horizontal / centre across selection.
 
This means that some of the cells in the Range are Merged and some of them
aren't. For instance:
A1:B1 has been merged
A2:B2 has not
If you try to Sort these columns, you will never get it to work unless ALL
of the cells are merged in the same way as A1:B1 (A2:B2;A3:B3;etc.).

Not that this will help you now, but, if you plan to Sort, you should never
Merge. In fact, you're probably better off never Merging at all.
Consider exploring Format | Cells | Alignment | Horizontal Alignment |
Center Across Selection as an alternative.

tj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to sort excel data. won't allow. merged cells sizing.?? 2
sorting problems - error message: identically sized merged cells. 2
Merging Cells and Sorting 1
Sorting Rows 2
Can't copy & paste - "merged cells must be identically sized" 2
Merged Cell Sorting 1
sorting two columns of merged cells 1
Problems sorting spreadsheet - Please Help 6

Back
Top