Data Sorting in worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting non-linked cells in a linked worksheet 1
Sorting in multiple worksheets 1
Top row of excel stays even in sorting 1
auto sort macro 1
Sorting a Selection 2
Is not sorting 4
Lookup multiple values 4
writing a sort macro 2

Back
Top