#1   Report Post  
Posted to microsoft.public.excel.misc
Karen
 
Posts: n/a
Default SORT Header Row(s)

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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default SORT Header Row(s)

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
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
need help righting script to sort rows alphabetically then seperate them to line up [email protected] Excel Worksheet Functions 0 November 15th 05 02:23 AM
sort columns within a merged cell header Diana Excel Discussion (Misc queries) 1 August 4th 05 11:03 PM
How do I sort rows with hyperlinks? SKTAZZ Excel Discussion (Misc queries) 1 March 16th 05 06:00 PM
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. bro. Billy New Users to Excel 4 December 11th 04 01:01 AM
Header included in sort Headersortproblem Excel Worksheet Functions 1 November 24th 04 05:48 PM


All times are GMT +1. The time now is 02:54 PM.

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

About Us

"It's about Microsoft Excel"