Data sorting with headers

[saxydj]

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 ..

[Pecoflyer]

Hi
perhaps some hidden rows or freeze panes?

[saxydj]

No ... doesn't explain why the sort saves in my old spreadsheets with the column headers already displayed ....

[gebobs]

Have you tried using the Home:Format as Table function? This should effectively lock you headers in place. If not, remove any shading or border formats in the table prior to doing this as it will do this automatically.

[Pecoflyer]

Any merged cells?