Sort defaults
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 |
I've just replied to this in microsoft.public.excel
-- Ian -- "JohnM" wrote in message ... 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 |
All times are GMT +1. The time now is 07:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com