Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Sort error

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sort on data field [email protected] Excel Discussion (Misc queries) 0 August 30th 06 10:08 AM
how to sort anything that looks like a number as a number cyndiwise notsowise Excel Discussion (Misc queries) 4 August 29th 06 08:19 PM
How can I sort multiple times Sorting data Excel Worksheet Functions 2 February 9th 06 05:22 PM
sorting more than 3 keys Brooke Excel Discussion (Misc queries) 3 June 18th 05 04:52 AM
Error trapped only while stepping through the code - Not triggered when run Jeff Excel Discussion (Misc queries) 7 March 7th 05 06:29 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"