freezing columns labels while sorting columns

S

Stan

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

Ms-Exl-Learner

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top