About this lesson
How to sort data and protect sheets and ranges.
Sorting and protecting ranges
Google Sheets gives the option of sorting data, as well as protecting certain cells from being edited.
When to use
Use “Sort data” when you have a set of data and you want to change how it’s organized. Use “protect range” when you want to prevent certain cells from being edited, either by yourself or by others.
- Select the cells you want to sort
- Click “Data” - “Sort range” or right click, and click “Sort range”
- Check the box “Data has header row” if the first row of the data contains headers
- Click which column to sort by
- Click whether to sort in order (A-Z) or reverse order (Z-A)
- If necessary, click “+ Add another sort column” to add another sorting rule (this will be used to break ties)
- Click “Sort”
- Select the cells you want to protect
- Click “Data” - “Protected sheets and ranges” or right click, and click “Protect range”
- Optional: Enter a description
- Choose which cells are protected
- Range: Protect the selected range
- Sheet: Protect everything on the chosen sheet except the selected range
- Click “Set permissions”
- Show warning when editing this range: Displays a warning when you change something in the selected cells. NOTE: This warning can be turned off for 5 minutes at a time
- Restrict who can edit this range: Choose who has permission to edit the selected cells.
NOTE: Add email addresses to give people permission
- Click “Done”
Lesson notes are only available for subscribers.