| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort when I have multiple header rows (not included in sor.
I have a spreadsheet with three rows of "header" information (Section title,
Column title, Column total). How do I sort (A to Z) without including the top 3 rows in the sort? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sort when I have multiple header rows (not included in sor.
Select your range to sort first--don't include the headers.
Then use Data|sort and specify that the selection doesn't include headers. K_Millan wrote: I have a spreadsheet with three rows of "header" information (Section title, Column title, Column total). How do I sort (A to Z) without including the top 3 rows in the sort? Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are Hidden Rows/ Columns Included in a Sort? | Excel Discussion (Misc queries) | |||
| Header Rows and Sort Issue | Excel Discussion (Misc queries) | |||
| How do I make the sort default to 'No header rows' | Excel Discussion (Misc queries) | |||
| Sort with multiple header rows | Excel Discussion (Misc queries) | |||
| Header included in sort | Excel Worksheet Functions | |||
Linear Mode
