Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select the entire range to sort.
format|Cells|alignment tab Is that checkbox for merge empty? If no, then you have some merged cells in that range. jpas1954 wrote: I'm trying to sort a column (and adjacent columns) and keep getting this error. I'm not clear on what it's trying to say or how to resolve it. I don't have any merged cells: This operation requires the merged cells to be identically sized. This error only appears if you attempted to sort a range of previously merged cells, but not all cells in the sort range were merged or are not of the same size. To avoid this behavior, unmerge all the merged cells in the range, or merge all the cells in the range to be the same as the largest merged cell grouping. -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to sort on data field | Excel Discussion (Misc queries) | |||
how to sort anything that looks like a number as a number | Excel Discussion (Misc queries) | |||
How can I sort multiple times | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) |