The bold font was already done and it still sorted. Confusing issue.

Best Regards,
EMoorhead
http://www.estandardtime.com

--
Estandardtime Realty


"Debra Dalgleish" wrote:

If you format the heading row differently than the rest of the table,
e.g. Bold font, it should automatically be detected. Then it will remain
at the top after the sort.

Or, choose DataSort, and specify that a header row is included.

Eleanor M wrote:
Thanks it was the header of the columns wadn't included. BTW how do you sort
without rearranging the header in the sort? It gets sorted with all the data
and that confuses the pivot table refresh.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html