Data Sorting in worksheet

D

daniel

Hello, I have a workbook with three worksheets in it. When I use the Data -
Sort command from the menu on the first worksheet I always have to specify
that I have a header row. In the 2nd and 3rd worksheets it is there by
default. I have tried to change this and set it to have a header row and it
keeps changing back to "No header row". How can I make this change? Any help
would be greatly appreciated. Thank you in advance.
 
F

Frank Kabel

Hi
Excel 'guesses' if you have a heading row. It helps if the format of
this header is different. e.g. try to bold the header. Also make sure
that all columns contain a header information.
 
Top