freezing columns labels while sorting columns

  • Thread starter Thread starter Stan
  • Start date Start date
S

Stan

... I need to sort names in columns, but while doing that my columns labels
are also being sorted. How to avoid that?
 
Excel 2003
In Sort Dialogue Box you can see an option button "Header Row" under "My
Data Range As" click it.

Excel 2007
In Sort Dialogue Box you can see a check box "My data has headers" in the
Right corner near to Close Button in the Sort Dialogue box.

Remember to Click Yes, if this post helps!
 
Back
Top