SORT Header Row(s)

[Guest]

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]

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.