How To Lock Cells in Google Sheets – Guide
If you share your work with others, they might be able to edit cells that you have locked. This is useful when multiple people are working on the same spreadsheet and someone accidentally edits a cell. ..
Google Sheets is the best spreadsheet software available. It has many features over Microsoft Excel, and is free to use. If you’ve never used it, take a look at our starter guide to Google Sheets for some tips.
- Lock cells to prevent editing
- Add a password to protect the spreadsheet
How to Lock Cells in Google Sheets
You can block cells in Google Sheets. This includes entire rows and columns as well. See how. ..
Select the cells you want to lock. ..
Selecting Protect Range from the menu will protect all cells in the selected range.
On the right side of the browser, name the selection if you like (but don’t press Enter). You don’t need to give a name, but you can make it easier to find a protected set of cells later.
You can now set permissions for your account so that only approved people can see your posts and comments. ..
In the Edit Range Permissions dialog, you can choose to show a warning or restrict who can edit the range. If you choose Restrict who can edit this range, you can add email addresses of each person you want to allow editing. When you’re done, click the green Done button. ..
How to Unlock Cells in Google Sheets
You can stop protecting certain cells in a spreadsheet by clicking on the " Protect " button.
If the Protected Pages and Ranges sidebar isn’t visible in your spreadsheet, click Data in the menu bar at the top of the screen and choose Protected Pages and Ranges.
To unlock a cell or range of cells, click on the cell or range you want to open. ..
Final note
This guide will show you how to lock cells in Google Sheets so that you can prevent other users from editing or deleting the data in those cells. ..
