Data sorting with headers
I have some old spreadsheets with headers that work quite well. When I hit the sort command the sorting query comes up already showing the headers in the specific order I usually sort in. The table stays put on whatever line I am on and all is well. In my newer spreadsheets, I click on the sort command for the first time, it shows the default (with the column letters instead), asking if I have headers, I answer yes, the table goes all the way to line 1. My tables are sometimes 2400 lines long so this can be a royal pain. What did I do in my earlier spreadsheets that I am not doing now? Some sort of option button? Now matter how many times i save the spread sheets, the sort command does not save with it other than showing the column letters of the typical headers I sort by ..
thanks in advance ..
|