Protect a cell, sheet, or range for editing. In this video, learn how to lock sheets for editing and add additional editors.
- [Instructor] You can protect a cell, range, … or entire sheet for editing. … Right or secondary click inside any cell … and choose Protect range. … Click to add a sheet or range. … Enter a description. … To protect just one particular cell or a range, … you can enter it in the Range tab. … To protect an entire sheet, … click Sheet and select the sheet … that you want to lock for editing. … You can also set exclusions, … that is, certain cells that you can edit … within that range or sheet. … Click Set permissions, … and it defaults to only you being able to edit the range. … Click the down triangle, choose Custom, … and here's where you can enter names … to add additional editors. … I'll click Done. … The range is locked for editing. … This is not a true security measure, … as anybody can still print or copy the data, … they just can't edit it. … To unprotect your sheet or range, … click back inside … and change the range permissions … or delete it entirely by clicking the trashcan icon. …
- Wrapping text
- Collaborating with others on a spreadsheet
- Freezing and locking panes
- Auto-filling data quickly
- Rotating cell data
- Formatting spreadsheets
- Protecting sheets
- Inserting links
- Filtering views
- Undoing unwanted changes
Skill Level Intermediate
1. Google Sheets Quick Tips
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.