I leave a space between my headers and my column data because it’s easier for me to read that way. When I then try to grab a selection of data to sort and press a sort ascending/descending button, it refuses the sort the top row of data in the selection because it thinks it’s a header.
I know I can go into data->sort and uncheck “range contains column labels” but it’s very frustrating to have to do that every time when I want to be able to quickly sort data periodically as I add it. Is there any way to permanently tell Calc to stop trying to figure out where my column headers are and just sort precisely the selection I choose?