Nikki,

Insert a new row above the one row of headers that you want to use, then
select one cell in the table of data, do the Data / Sort, etc. and then when
you're done, simply delete the new row.

HTH,
Bernie
MS Excel MVP


"nikki dawn" wrote in message
...
Hi,

I have several reports that export into .xls spreadsheeets from SAP. They
always export with multiple header lines which makes it hard to sort
because
doing 'DataSortw/ Header' only keeps the top line as header. I need to
keep
them all for my boss.

I have been doing them manually but the 2 new ones he gave me this morning
contain 37,000 rows each.

Is there a way to sort all and have the first 6 rows be an exception?

Any help is appreciated.

Thanks,

Nikki