View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default sort doesn't grab header info

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.