freezing columns labels while sorting columns
 

... I need to sort names in columns, but while doing that my columns labels
are also being sorted. How to avoid that?

freezing columns labels while sorting columns
 

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!

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


"Stan" wrote:

.. I need to sort names in columns, but while doing that my columns labels
are also being sorted. How to avoid that?