Ask Your Question

sort excluding multiple label rows [closed]

asked 2020-07-10 15:26:59 +0100

old perv gravatar image

updated 2020-12-02 01:14:03 +0100

Alex Kemp gravatar image

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 flag offensive 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

1 Answer

Sort by » oldest newest most voted

answered 2020-07-10 16:26:04 +0100

nomen gravatar image

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.

edit flag offensive delete link more


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.

LeroyG gravatar imageLeroyG ( 2020-07-10 18:08:07 +0100 )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.

old perv gravatar imageold perv ( 2020-07-17 19:57:00 +0100 )edit

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

LeroyG gravatar imageLeroyG ( 2020-07-19 18:54:17 +0100 )edit

Question Tools

1 follower


Asked: 2020-07-10 15:26:59 +0100

Seen: 137 times

Last updated: Jul 10 '20