Excel

G

Guest

Trying to sort Columns A-G: First, Last, Address 1, Address 2, City, State,
ZIP. When I click on Data, Sort, and choose ZIP I get the message: "This
operation requires merged cells to be identicall sized." I DON'T have any
merged cells. How do I "get around" this error message and sort my data?
 
N

Nick Hodge

I bet you do somewhere..awful things

Highlight all cells by clicking the intersection square between the row and
column headers and then select Format>Cells...>Alignment tab. You will
likely see a green square in Merged cells checkbox, not a tick. Click this
twice should un-check it and all should be well

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
 

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

Operation requires the merged cells to be identically sized 2
excel sorting error 1
VBA set thick borders around non empty cells in range 0
trying to sort excel data. won't allow. merged cells sizing.?? 2
Locate merged cells to sort on 3 columns 2
Sorting Range that Contains Merged Cells 1
Excel Sorting 2
Error in Excel Sort 1

Top