Ask Your Question

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

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

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 close merge delete


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

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

1 Answer

Sort by » oldest newest most voted

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 132 times

Last updated: Sep 24 '17