Top row of excel stays even in sorting

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.
 
M

Ms-Exl-Learner

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

Top