Table of Contents
This tip is about the how to Lock Cells in Google Sheets on your Browser. So read this free guide, How to Lock Cells in Google Sheets on your Browser step by step. If you have query related to same article you may contact us.
How to Lock Cells in Google Sheets on your Browser – Guide
Google Spreadsheet security is very important because, whether the changes are made on purpose or accidentally, the best way to stop them is to put tight controls on the spreadsheet that keep your data locked from change.
Let’s learn how to block cells in Google Sheets. It will also help you learn about spreadsheet protection to ensure that critical data is never modified in your spreadsheets.
BLOCK CELLS AND LINES IN THE GOOGLE SHEETS WEB
You can lock individual cells or use a keyboard/mouse to select multiple cells. It’s your wish.
Step 1: After selecting cells in a row and/or column, right click to select Protect range.
Step 2: a pop-up will slide and open on the right side of the screen. You can enter a description and check or uncheck cells. Select the Sheets tab if you have multiple sheets open. When you are sure which cells you need to block, click Set Permissions.
Step 3: Select ‘You Only’ if you don’t want anyone else to edit the range. Select Custom if you want to enter the names of users who are allowed to edit the range.
Click ‘Copy permissions from another range’ if you already have another cell range locked and want to apply the same changes (name, description, etc.) to this range as well.
Step 4: You will enter the names of the editors or those who will be allowed to edit the selected cells. There is also an option to set a warning message if someone tries to edit the selected range. Click Done button when you are satisfied.
You can use the same settings to lock rows and even columns. Instead of selecting individual cells, you click the row or column title and drag to select multiple rows or columns. The protected track is highlighted to differentiate it from the unprotected track.
Still, if anyone tries to edit any cells in the protected range, they will get an error message.
Final note
I hope you like the guide How to Lock Cells in Google Sheets on your Browser. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.