| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Freezing columns | Excel Discussion (Misc queries) | |||
| Freezing 2 columns at once | Excel Discussion (Misc queries) | |||
| freezing multiple columns | New Users to Excel | |||
| Freezing rows and columns | Excel Worksheet Functions | |||
| Freezing rows & columns | Excel Worksheet Functions | |||
Hybrid Mode
