S Stan Dec 3, 2009 #1 ... I need to sort names in columns, but while doing that my columns labels are also being sorted. How to avoid that?
... 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 Dec 3, 2009 #2 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!
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!