This is a possible repeat/re-creation of #94668 which was closed as "worksforme."
tl;dr: allow me to set Data > Sort, Options: "Range contains column labels" globally instead of per session/per file. I always want it to default as checked.
I'm on 184.108.40.206 and for years have always had to go into the Options tab to select "Range contains column labels" whenever I sort. I can't recall the last (or any?) time I *didn't* want this.
Could this be made a globally persistent options so that users who [almost] always work with data containing a header row don't have to do this one additional step (or more accurately, forget, sort, wonder where their header is, ctrl+z, sort, this time click options and check box, apply)?
Related to #131155, which wants to move the option from Options to in the main sort pane... This would save a click, but I'd just prefer to toggle this globally like e.g. auto-fill/auto-correct options.
This happens when using Ctrl+A to select *all* before the Sort. Don't.
Wow, of all the possible "solutions." Thanks for the post as well. I vaguely recall having a partial sort occur at one point and using ctrl+a forever more to compensate.
Crazy that I have been doing this for *years* without knowing it affects the sort settings, but also incredible to have such an easy "fix." Many thanks.