Top row of excel stays even in sorting
 

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.

Top row of excel stays even in sorting
 

2003:-
DataSortMy 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.

--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"willyd" wrote:

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.