Thread: Header rows
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kellia Kellia is offline
external usenet poster
 
Posts: 6
Default 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