We will be migrating from Ask to Discourse on the first week of August, read the details here

# sort excluding multiple label rows [closed]

I want to sort a sheet by date in one of the columns. I know that there is a setting to exclude the first row which contains labels. However, since the sheet has many rows, I have inserted a row of the same labels as the first row at various intervals so that when I scroll down, I will still be able to see the labels for each column. The problem is that the presence of several label rows at a number of places interferes with the sort process since the several label rows (apart from the first row) are included in the sort. Is there a way to define a sort which would exclude any entries in the column which are text labels and not dates? I want the sort to take place without moving any of the various label rows which I have created.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-12-02 01:14:11.975493

Sort by » oldest newest most voted

Suggestion--Rather than duplicating your label rows, use the View|Freeze Cells option to freeze your top row of labels. You can scroll thru your data without losing your labels. You can then sort as you wish after removing your duplicate label rows.

more

( 2020-07-10 16:36:51 +0200 )edit

If only to see the labels, in my case, I would choose the answer of @nomen.

But strictly answering your question, one workaround is to add a column with numbers from the labels row down. Then delete the Date label in the following labels. So, you can sort by Date column (and labels will go below all data), then restore to previows order sorting by the number column.

If the need is to print the label row as the first row in each page, you can choose menu Format - Print Ranges - Edit…, and in Rows to Repeat input the row number (usually \$1). Can see more Help on Edit Print Ranges.

( 2020-07-10 18:08:07 +0200 )edit

nomen's answer worked for me. It did exactly what I wanted to very simply and I don't have to keep adding label lines as I add entries. Many thanks for the input guys.

( 2020-07-17 19:57:00 +0200 )edit

@old perv, Don't forget to check the mark () to the left of the answer to show that your question was solved.

( 2020-07-19 18:54:17 +0200 )edit