ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sort by zip code (https://www.excelbanter.com/excel-discussion-misc-queries/224630-sort-zip-code.html)

Daniel

sort by zip code
 
I have my high school classlist on an excel speadsheet..in alphabetical
order..with address and zip codes included. I want to sort the classlist by
zip code,but when I
try to sort I get a "this operation requires the cells to be identically
sized" I'm sorry,
but what does this mean and how can I sort by zip code?
--
dew

Alan

sort by zip code
 
You usually get that when there a merged cells in the list.
Regards,
Alan.
"daniel" wrote in message
...
I have my high school classlist on an excel speadsheet..in alphabetical
order..with address and zip codes included. I want to sort the classlist
by
zip code,but when I
try to sort I get a "this operation requires the cells to be identically
sized" I'm sorry,
but what does this mean and how can I sort by zip code?
--
dew



Gord Dibben

sort by zip code
 
You have some merged cells in there somewhere.

Unmerge them and the message will go away.


Gord Dibben MS Excel MVP

On Tue, 17 Mar 2009 12:52:05 -0700, daniel
wrote:

I have my high school classlist on an excel speadsheet..in alphabetical
order..with address and zip codes included. I want to sort the classlist by
zip code,but when I
try to sort I get a "this operation requires the cells to be identically
sized" I'm sorry,
but what does this mean and how can I sort by zip code?




All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com