5

I can sort a Google Docs spreadsheet on any column, but that sorts ALL of the rows. I don't want to sort the rows that contain the column labels. Is there a way to protect them from being sorted?

I tried protecting those rows from changes, but I can't protect rows from myself. I tried sharing the document with a different account and protecting those rows from that account, then working on it from that account, but the spreadsheet froze in the other account as soon as I protected any rows.

1 Answer 1

7

You can freeze the row(s) with column headers, using the menu: View > Freeze > 1 row (or another number).

The frozen rows are not included when executing "Sort sheet A-Z" or "Sort sheet Z-A" from the expandable menu next to column names, or when sorting the sheet from "Data" submenu.

1
  • Hi, I don't think this works for people that are viewers. A viewer can sort, and get a "local only" view, but the frozen rows are included, making the view pretty ugly.
    – Jack
    Feb 28, 2021 at 20:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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