Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

Sorting Question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
trvlnmny - 17 Oct 2007 04:22 GMT
I have a worksheet that has 2 Header rows. The second row is blank to
give the sheet a cosmetic look. The first data row is row 3. When I
select the sheet and do a sort the second header row gets sorted as
the last row so that the first data row is now row 2.
Is there a way to specify that the worksheet has 2 Header rows?
Thanks for all your help.
Earl Kiosterud - 17 Oct 2007 04:38 GMT
trvlnmny,

No.  You'll need to select the range manually, then use Data - Sort.  Don't include either
header row in your selection, and tell it you don't have a header row.  You'll have to
select your sort key columns by column letters, not by field name in the header.
Alternatively, you can include your second header row in the selection, and declare you do
have a header row.  Then you can select sort key columns via the contents of that row, if
it's helpful.

Or, you could put a zero in the key fields of the second header (or all of them), and format
them for the same text color as the background to make them invisible.  That way, that row
should always be sorted to the top of the list.
Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

   Note: Top-posting has been the norm here.
   Some folks prefer bottom-posting.
   But if you bottom-post to a reply that's
   already top-posted, the thread gets messy.
   When in Rome...
-----------------------------------------------------------------------

>I have a worksheet that has 2 Header rows. The second row is blank to
> give the sheet a cosmetic look. The first data row is row 3. When I
> select the sheet and do a sort the second header row gets sorted as
> the last row so that the first data row is now row 2.
> Is there a way to specify that the worksheet has 2 Header rows?
> Thanks for all your help.
trvlnmny - 17 Oct 2007 04:59 GMT
Earl,
Thanks for the help. That is awkward but it works.

> trvlnmny,
>
[quoted text clipped - 27 lines]
>
> - Show quoted text -
Pete_UK - 17 Oct 2007 09:39 GMT
Another way which maintains the appearance of your sheet is to have
just one header row, but to double the height of this row and to
change the alignment of the headers to the top of the cell (Format |
Cells | Alignment tab, then Vertical Alignment). Now when you want to
sort you can highlight all the data including header row and specify
that you have a header row in the dialogue box.

Hope this helps.

Pete

> Earl,
> Thanks for the help. That is awkward but it works.
[quoted text clipped - 35 lines]
>
> - Show quoted text -
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.