I have a spreadsheet in Google Sheets, there is a header and 13 rows containing data.

There is then a row containing the average of the cells above.

I'd like to be able to sort the various columns in order of size, unfortunately whenever I try to do this the "Averages" row is sorted along with them.

Is there any way to exclude the bottom row from the filter?

  • Welcome. This sounds like a design error. Why not just put the averages above the header row? – Tedinoz Jul 11 '20 at 5:12
  • That works, thanks. – KCH Jul 12 '20 at 16:09

Your Answer

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

Browse other questions tagged or ask your own question.