Sort defaults

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

Guest

When working with Excel 2002, we have set the columns up with headers. After
adding another entry into the spreadsheet, we do a column sort to alphabetize
the column.
We have 5 spreadsheets in the workbook. Three of these, we can sort without
sorting the header. The other 2, it sorts the header.
When going through Data-Sort..., we can choose Header Row on each of the
spreadsheets. The two we have problems with, it defaults to No Header Row.
How can I make it default to Header Row?
It would save me much time to just use the icpn on the toolbar.
Thanks,
John
 

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 defaults 1
Sorting day names chronologically 5
parent/child relationship between rows? 3
Data Sort header row 1
Automatic Sorting? 6
Excel sort dialog box: Display of column header instead of columnname 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel should remember sort criteria 2

Back
Top