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.

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.

Excel tries to recognize headers, but if it doesn't, just tell it you have one.
In the Sort dialogue box, there is a button for 'My list has Header row'. Click
it.

--
Regards,
Fred


"RichRite" wrote in message
...
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.

Hi,

It is recommended that the First row of any range is a header. It need not
be bold or colored.

Even if you just select a cell in the first row , during Sort, the whole
range of cells would be selected based on the Sorting condition.

Do the following:

1. Click on the first cell of the range.
2. On the Data menu, click Sort.
3. In the Sort by list click Ascending or Desending.
4. In the My data range has, click Header Row.
5. Click OK. This return to the Worksheet and the data is sorted in
Ascending or desending based on your selection Critirea.

Challa Prabhu

"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.

You might be brave enough to allow Excel to guess the extent of the range
that you wish it to sort. I (and others) would recommend that the user
should select the range for himself.
--
David Biddulph

"challa prabhu" wrote in message
...
Hi,

It is recommended that the First row of any range is a header. It need not
be bold or colored.

Even if you just select a cell in the first row , during Sort, the whole
range of cells would be selected based on the Sorting condition.

Do the following:

1. Click on the first cell of the range.
2. On the Data menu, click Sort.
3. In the Sort by list click Ascending or Desending.
4. In the My data range has, click Header Row.
5. Click OK. This return to the Worksheet and the data is sorted in
Ascending or desending based on your selection Critirea.

Challa Prabhu

"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.