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

Try formatting your header row differently--maybe bold/italics/underline???

Give excel some kind of info that there is a header row.

JohnM wrote:

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

--

Dave Peterson