Sorting Question

  • Thread starter Thread starter trvlnmny
  • Start date Start date
T

trvlnmny

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,

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.
--
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...
 
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
 
Back
Top