Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My worksheet column headers are in 2 rows. Short of combining those 2 rows of
header text into 1 row, is there a way designate that there are 2 header rows when sorting using the sort function, below? DATE | SORT | "My data range has header row" TIA, ~Karen |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
No.
Maybe you can just ignore the top header row and include just the bottom header and choose "my range has headers"... Or maybe you could just ignore both headers and not choose that option. ps. I'd create a single header row. You can use alt-enter to force a new line in the cell. Karen wrote: My worksheet column headers are in 2 rows. Short of combining those 2 rows of header text into 1 row, is there a way designate that there are 2 header rows when sorting using the sort function, below? DATE | SORT | "My data range has header row" TIA, ~Karen -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need help righting script to sort rows alphabetically then seperate them to line up | Excel Worksheet Functions | |||
sort columns within a merged cell header | Excel Discussion (Misc queries) | |||
How do I sort rows with hyperlinks? | Excel Discussion (Misc queries) | |||
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. | New Users to Excel | |||
Header included in sort | Excel Worksheet Functions |