Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sort contacts in Excel?
How can I sort contacts in Excel? They will not sort because they say I have
to "unmerge the cells" or "all cells are not the same size". It used to work fine. Thank you....scott |
#2
|
|||
|
|||
....go ahead and unmerge. Select all the columns where the data is, right
click, go to the alignment tab, uncheck the merge box. "Scott" wrote: How can I sort contacts in Excel? They will not sort because they say I have to "unmerge the cells" or "all cells are not the same size". It used to work fine. Thank you....scott |
#3
|
|||
|
|||
You'll need to unmerge the merged cells before you can sort. I'm guessing
you copied something into the worksheet that merged the cells. Look at some of the last entries to see if you can find them and unmerge them. "Scott" wrote: How can I sort contacts in Excel? They will not sort because they say I have to "unmerge the cells" or "all cells are not the same size". It used to work fine. Thank you....scott |
#4
|
|||
|
|||
Thank you very much JR. This worked perfectly. Scott.....
"JR" wrote: ...go ahead and unmerge. Select all the columns where the data is, right click, go to the alignment tab, uncheck the merge box. "Scott" wrote: How can I sort contacts in Excel? They will not sort because they say I have to "unmerge the cells" or "all cells are not the same size". It used to work fine. Thank you....scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
how do I reset the default sort order in excel xp back to blanks . | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |