Sorting merged cellsHow do I sort merged cells not identically siz

G

Guest

When attempting to sort spreadsheet, I receive the following error.
(This operation requires the merged cells to be identically sized) How
do get past this error?
 
P

Paul Corrado

Easiest way is to un-merge the cells. Using that feature causes a number of
issues like this and I always recommend an alternate solution.

If you were only using this to center some text over a few columns you can
do that by selecting

Format/Cell/Alignment and choose Center Across Selection
 

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

Locate merged cells to sort on 3 columns 2
Excel Sorting 2
How to sort merged cells 3
Sorting problem- This operation requires... 2
Keeping Rows Together 1
Sorting Range that Contains Merged Cells 1
sorting problems - error message: identically sized merged cells. 2
trying to sort excel data. won't allow. merged cells sizing.?? 2

Top