Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Sorting merged cells of differant sizes
I have at least 4 columbs and an varable amount of rows to deal with.
Trying to sort my data by first columb only I get error message of: requires the merged cells to be identically sized. I then formatedd all rows heights to 14 and columd widths to 9. Received same error message. Any insight please? |
#2
|
|||
|
|||
You need to get rid of those merged cells. They cause nothing but grief,
and the same effect can usually be had by using Format / Cells / Alignment tab / Horizontal / centre across selection. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Peter Jefferson" <Peter wrote in message ... I have at least 4 columbs and an varable amount of rows to deal with. Trying to sort my data by first columb only I get error message of: requires the merged cells to be identically sized. I then formatedd all rows heights to 14 and columd widths to 9. Received same error message. Any insight please? |
#3
|
|||
|
|||
This means that some of the cells in the Range are Merged and some of them
aren't. For instance: A1:B1 has been merged A2:B2 has not If you try to Sort these columns, you will never get it to work unless ALL of the cells are merged in the same way as A1:B1 (A2:B2;A3:B3;etc.). Not that this will help you now, but, if you plan to Sort, you should never Merge. In fact, you're probably better off never Merging at all. Consider exploring Format | Cells | Alignment | Horizontal Alignment | Center Across Selection as an alternative. tj "Peter Jefferson" wrote: I have at least 4 columbs and an varable amount of rows to deal with. Trying to sort my data by first columb only I get error message of: requires the merged cells to be identically sized. I then formatedd all rows heights to 14 and columd widths to 9. Received same error message. Any insight please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Sorting referenced cells | New Users to Excel | |||
Auto fit merged cells | Excel Discussion (Misc queries) | |||
Sorting Merged Sum Fields | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |