View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
 
Posts: 506
Default 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?