Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter and sorting
I am trying to perform a ascending sort and keep getting an error ... this
operation requires the merged cells to be identically sized. I have a table 3 top rows are the header with various merged cells, then I have a variable number of data rows (no merged cells), and finally there are several footer row with various merged cells. I am needing to sort the data rows, how can I do this? QB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter and sorting
If you carefully select the data rows range between your upper and lower
merged cells you can sort that range. Best to try to do without merged cells which cause these problems in the first place. Gord Dibben MS Excel MVP On Wed, 25 Nov 2009 07:03:02 -0800, QB wrote: I am trying to perform a ascending sort and keep getting an error ... this operation requires the merged cells to be identically sized. I have a table 3 top rows are the header with various merged cells, then I have a variable number of data rows (no merged cells), and finally there are several footer row with various merged cells. I am needing to sort the data rows, how can I do this? QB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Report Filter Sorting | Excel Discussion (Misc queries) | |||
Using Grouping and Sorting and Auto Filter | Excel Discussion (Misc queries) | |||
Sorting in a Spreadsheet with Filter | Excel Worksheet Functions | |||
Excel 2007 Pivot table's Report filter fields value sorting | New Users to Excel | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |