Google Sheets Beginners: Protecting cells, ranges and sheet tabs (23) [updated Feb 2022]
Google Sheets
Have you ever had your editors edit something on your Google Sheet that they weren’t meant to? Find out how to protect cells, ranges and sheet tabs in Google Sheets.
The main tutorial
In this tutorial, I’ll cover,
Why you may need to protect certain parts of your Google Sheet 00:02
Protecting a range of cells. 00:50
Selecting editors to your protected range. 01:22
How protected ranges look for the user. 01:46
Protecting entire columns. 02:35
Editor hierarchy. 03:18
What to protect? 04:13
The ‘protect’ sidebar. 05:17
Protecting an entire sheet tab. 05:57
Viewing a list of what has been protected in your Google Sheet. 07:17
Hot tip for hiding sheet tabs from other users. 07:42
If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:
How to prevent editors from moving columns and rows
You can prevent editors from moving columns and rows by selecting a range of rows, for example,Β A1:E1Β and preventing the user from editing those cells. Now when the editor tries to move any of those columns, they will not be able to.
check out the video tutorial below for more on this:
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.