getting msg: cannot sort merged cells not same size

G

Guest

Hi. someone sent me what looks like a run of the mill excel file . When I
try to sort it I get a message saying the "operation requires merged cells to
be identically sized". All the cells look the same size to me and as far as I
know no merging was done to create the file.... I am attempting to contact
the creator of the file but so far no luck. any ideas? Thank you.
 
G

Guest

press Ctrl-A to select the entire sheet, then Format>Cells>Alignment and make
sure the Merge Cells option is unchecked.
 

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

Top