Ask Your Question

How to sort but keep the top 3 rows from being sorted [closed]

asked 2017-09-22 03:18:02 +0100

spider gravatar image

My top 3 rows contain row 1-The file name saying how the file was sorted, row 2- the column labels and row 3- the date the file was updated. The remainder of the rows contain the data. I can sort all the data and have checked 'range contains column labels' under 'sort-options' and it will not sort the row 1- which is fine but I want it to not sort rows 2 and 3 but cannot figure out if that can be done and if it can how. All help would be appreciated.

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-10-16 01:05:56.860268


Have you tried not selecting the first three rows when doing the sort?

robleyd gravatar imagerobleyd ( 2017-09-22 03:36:56 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-09-24 05:34:35 +0100

spider gravatar image

Solved! Hi Robleyd, No I had not, but you are correct it works. Actually I had tried that earlier, amongst all my other attempts, but for some reason it did not work then, but now it does. Thank you.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-09-22 03:18:02 +0100

Seen: 194 times

Last updated: Sep 24 '17