3

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.

3

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.

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.