4

I want to be able to sort columns in a sheet. I know how to do this, and I know how to freeze 1 or two top rows so that the headings don't get sorted.

My question is this:
How do I prevent a "totals" row from being sorted?

e.g. in the image below, I want to be able to sort by number of bananas, but I don't want the totals to move when I start sorting:

screen shot

With a bit more googling, seems the best way is to select the cells I want to sort, right click and select "Sort Range". Is there any other way?

  • 3
    With a bit more googling, seems the best way is to select the cells I want to sort, right click and select "Sort Range". Is there any other way? – tomh Jan 23 '17 at 17:22
1

Try using Filter Views as they allows you to set the range. The following screen snippet shows the Filter View range setting, just click on it to set the appropriate range reference.

For details see Sort and filter your data

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.