Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by how many addresses per zip code | Excel Discussion (Misc queries) | |||
sort by code | Excel Discussion (Misc queries) | |||
Sort Macro: Help with code. | Excel Discussion (Misc queries) | |||
macro code to sort a range | Excel Discussion (Misc queries) | |||
Zip code sort is an Excel problem even when using the special cat. | Excel Discussion (Misc queries) |