W willyd Apr 19, 2010 #1 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.
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 Apr 19, 2010 #2 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.
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.
