Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Spreadsheet Selection - Recurring Sort
I use a particular spreadsheet everyday, and sort the data in three columns
of the worksheet many times (there is also other data that I do not sort). I don't have a header row. Until recently, the spreadsheet seemed to know how I wanted to sort, and the 'sort by' box always appeared with the sort by defaulting to my previous criteria, seemingly remembering how I had sorted it last time. Recently something has happened, and every time I go to sort, first the dialogue box comes up showing a header row, and when I change it to show no header row, EACH time it defaults to "sort by column A", even though I always sort this worksheet by columns B, C, and D. So now I have extra steps to direct the sheet to sort by B-C-D everytime I want to sort. Is there a setting somewhere, or was I just lucky before? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I sort a selection of cells into random order? | Excel Discussion (Misc queries) | |||
sorting data and expanding the selection | Excel Discussion (Misc queries) | |||
why does sorting large columns create errors in top selection? | Excel Worksheet Functions | |||
Macro - Data Sort -Variable Selection | Excel Discussion (Misc queries) | |||
Sort Macro: Utilizing ComboBox Selection for Key1 through 3 Ranges | Excel Discussion (Misc queries) |