Excel

S

SoozDooz

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

Merging from an Excel file with graphics 1
How to use matching values in two worksheets to return another value 5
Mailing address block: sorting 1 row to columns 1
Grouping Names in Mail Merge 0
Operation requires the merged cells to be identically sized 2
Excel does not accept text format! 0
Problems created by Recent updates to Outlook 365 0
excel sorting error 1

Top