Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
To help Excel distinguish between headers and data you should format
the headers in a different way, eg bold, or colour, and that way Excel will recognise the headers when you want to sort. Hope this helps. Pete On Aug 1, 7:50 pm, RichRite wrote: When I try to sort in an excel spreadsheet, the sort takes me to the first line of data instead of the header. It almost seems to think that the first line of data is the header. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
Mail merge with header/field info in 3rd row | Excel Discussion (Misc queries) | |||
Sort info | Excel Worksheet Functions | |||
sort, 2 row header | Excel Worksheet Functions | |||
how can I sort with header not on row 1 | Excel Discussion (Misc queries) |