Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort defaults | Excel Discussion (Misc queries) | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
How do you change sort defaults for combined text number & hyphen. | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |