Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header rows
Is it possible to have the first 2 rows as "header rows" when sorting columns
in alphabetical order, meaning that the first two rows remain at the top, whilst the rest of the rows get sorted? Thanks JD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header rows
The only ways I am aware of are either:
1. Merge rows 1 and 2. 2. highlight from Row 2 to bottom of the list, then do your sort. Should force Row 2 as your header. 3. If you just want to make the information to wrap, use wrap text or Alt+Enter to make a second row in the same cell. "JRD" wrote: Is it possible to have the first 2 rows as "header rows" when sorting columns in alphabetical order, meaning that the first two rows remain at the top, whilst the rest of the rows get sorted? Thanks JD |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header rows
Yes. Select the range of rows & columns you want sorting, then sort.
-- David Biddulph "JRD" wrote in message ... Is it possible to have the first 2 rows as "header rows" when sorting columns in alphabetical order, meaning that the first two rows remain at the top, whilst the rest of the rows get sorted? Thanks JD |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header rows
JRD
Check this out- so you know how you can select the entire worksheet with the upper left hand corner "grey" cell? Then when you want to sort, open the sort box and it gives you the option of selecting "Header Row" from the area "My Data Range Has...". If you double click on Header Row, it will choose header row, unselect the first row then it will automatically close that box. Then you can reopen sort, choose header row then it will unselect the 2nd row. I just stumbled accross this- hope it helps. -Kellia "JRD" wrote: Is it possible to have the first 2 rows as "header rows" when sorting columns in alphabetical order, meaning that the first two rows remain at the top, whilst the rest of the rows get sorted? Thanks JD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Header rows | Excel Discussion (Misc queries) | |||
Header Rows | New Users to Excel | |||
Header Rows | Setting up and Configuration of Excel | |||
How i can set two different rows as header and footer | Excel Worksheet Functions | |||
Repeat Rows Across not in Header | Excel Discussion (Misc queries) |