Top row of excel stays even in sorting

  • Thread starter Thread starter willyd
  • Start date Start date
W

willyd

I need a header in the top row of my excel worksheet so that even when I sort
the data the top row remains the same.
 
2003:-
Data>>Sort>>My Data Range As>> Check the “Header Row†Option Button.

2007:-
Press Alt+D+S the Sort Dialog Box will appear Press Alt+H which will select
the “My Data has headers†check box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting issue with frozen panes 11
Header rows 2
How to fix the top-most 4 rows when scrolling? 1
Sort Not Including Top Row 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
How can I keep more than one row from sorting 3
How to sort when I have multiple header rows (not included in sor. 1
sorting columns sorts header values too 6

Back
Top