Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In Excel 2002 you could press the sort button and the data would be sorted
and the header would be excluded. Now using excel2003 I can't do it this way because excel is not recognizing the header, Is this a setting I can change, if so, how can I change this. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sometimes if you format the header row differently (bold/larger font), then
excel will be able to guess if you have headers. Personally, I think it's a bad idea to let excel guess at the headers or the range to be sorted--I don't trust it! marquize wrote: In Excel 2002 you could press the sort button and the data would be sorted and the header would be excluded. Now using excel2003 I can't do it this way because excel is not recognizing the header, Is this a setting I can change, if so, how can I change this. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Header Rows and Sort Issue | Excel Discussion (Misc queries) | |||
How can I sort multiple times | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. | New Users to Excel | |||
sort option is greyed out in excel | Excel Worksheet Functions |