PC Review


Reply
Thread Tools Rate Thread

SORT Header Row(s)

 
 
=?Utf-8?B?S2FyZW4=?=
Guest
Posts: n/a
 
      4th Jan 2006
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      4th Jan 2006
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Header Problem (page header & report header) Eva Microsoft Access 2 23rd Oct 2009 03:46 PM
Cannot remove Column Header "Sort by: header status" NickW Microsoft Outlook Discussion 5 18th Dec 2008 04:05 AM
Pin header to Paralled, pin header to serial and pin header to USBadaptor questions Boo DIY PC 1 22nd Apr 2008 04:55 PM
Sort - Header:=xlGuess vs Header:=xlNo mwc0914 Microsoft Excel Programming 1 4th Oct 2005 05:21 PM
Re: Sort forgets last sort and forgets I have header rows Dave Peterson Microsoft Excel Misc 4 19th Jun 2004 12:09 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:42 PM.