Instructions on how to block cells in Google Sheets spreadsheets

116

Locking individual cells in the Google Sheets spreadsheet is the best way to limit the data in the modified spreadsheet – whether accidentally or intentionally – by people with access to your spreadsheet.

Fortunately, Google’s Sheets online spreadsheet software offers potent options to restrict others from modifying your properties.

The following article will guide you to lock your Google Sheets spreadsheet with many options that apply in different situations, depending on the object and level of the lock you desire.

Lock properties in Google Sheets

The most significant highlights of Google Sheets (as well as other Google applications) is that anyone who has the right to edit can collaborate on cloud documents in real time.

People who are opening documents can see other people’s modifications almost instantly. However, sometimes you don’t want people you are sharing content editing documents within some specific fields, but you don’t want to revoke their editing rights entirely.

You then need to use the cell lock feature in the Google Sheets spreadsheet.

First, open the browser and access the Google Sheets spreadsheet to lock the box. Blackout to select the cells to lock.

Lock properties in Google Sheets

After the blackening is complete, select the “Data” menu and click on the “Protect Sheets and Ranges” option.

Lock properties in Google Sheets

The Protect Sheets and Ranges option bar will appear on the right side of the window.

Here, you can enter a concise portrayal of why you need to lock and click on the green “Set Permissions” button to switch to the permission settings dialog for locked cells.

Lock properties in Google Sheets

By default, anyone who has the right to edit documents is allowed to modify every cell on the spreadsheet.

Click on the drop-down menu below the command “Restrict who can edit this range” (Limit who can edit this property) and select “Custom” to set who is allowed to edit the cells calculator is selected.

Lock properties in Google Sheets

Just below will appear a list of people who have granted permission to edit the current spreadsheet file. By default, all of these people have the right to revise the cell.

So if you want to “prohibit” anyone who is not allowed to modify the currently selected cell, uncheck the checkbox next to the person’s name and press “Done” to finish.

Lock properties in Google Sheets

From now on, when unlicensed editors try to modify the content inside, a dialog like the one below will appear to indicate that they do not have permission to edit the cell:

Lock properties in Google Sheets

Displays a warning when a user modifies any cell

If you still want to allow everyone to edit the cell content, but before they fix, the software will display a warning, do the following:

Open the Google Sheets sheet you need to set up an alert. Access the Data menu > Protect Sheets and Ranges on the main toolbar.

Lock properties in Google Sheets

Then, click to select the cell key you want to edit.

Lock properties in Google Sheets

Select the “Set Permissions” button.

Lock properties in Google Sheets

Click on the “Show a warning when editing this range” option (Display a warning when editing this block) and press the “Done” button.

Lock properties in Google Sheets

The next time someone wants to edit the locked cells, they will receive a warning like this: ” Be careful! You are editing a part of the spreadsheet that should not have been modified unintentionally. Would you like to continue? “

Lock properties in Google Sheets

Lock entire sheet (sheet) in Google Sheets

If you want to lock the entire sheet so that no one can modify them except you, the simplest way is just to set up sharing for others with “view” rights and not “edit” rights.

However, in case you want to lock most parts of the worksheet, but still “leave” a few editable boxes – often in registration forms or payment invoices … Then, you always will have to grant editing rights to others, but it will be very costly if you have to sit down to spread almost all of the spreadsheet cells to lock them, leaving only a few cells to edit …

In this case, you can use another method that is easier to do and less time-consuming: it is to lock the entire sheet and only allow editing some cells.

How to do it: You still open your document, as usual, go to the Data menu> Protect Sheets and Ranges.

Lock properties in Google Sheets

On the toolbar that appears on the right-hand side of the screen, click the Sheets tab, select the sheet you want to set up in the list below, then click the “Set Permissions” button.

Lock properties in Google Sheets

And similar to locking specific cells, in the next dialog box that appears, you need to select the list of users who have the right to edit this upcoming sheet.

Action as follows: Click on the option “Restrict who can edit this range” (Limit who can edit this block “and choose Customized … to set it up.

Lock properties in Google Sheets

The following is a rundown of individuals who have granted permission to edit the current spreadsheet file.

If you want to “prohibit” anyone who is not allowed to modify the selected spreadsheet, uncheck the checkbox by the individual’s name and press “Done” to finish.

Lock properties in Google Sheets

People who have access to your documents can still open and view the content of the spreadsheets you have locked, but will not be able to edit or make any changes to them.

Add “exceptions” in locked sheets.

Following the previous section, after setting up the entire sheet, you can still “leave” some boxes that allow others to edit. If this section is not set, Google Sheets will lock all cells in the sheet by default.

Click the Data menu > Protect Sheets and Ranges in the toolbar. In the settings bar on the right, click on the sheet lock setting that you need an exception to.

Lock properties in Google Sheets

Click to select the “Except Certain cells” checkbox (except for some specific cells) and enter the cell or block of cells you want to allow people to edit.

You can click on the table at the side to switch to the mouse mode to directly blacken the block to unlock.

If you want to select multiple cells/blocks as an “exception,” click the “Add another range” button below to select another block.

Lock properties in Google Sheets

After the setting is complete, if other people edit the cells/blocks outside the “exception” area, they will receive a message saying they do not have permission to edit these boxes:

Lock properties in Google Sheets

Unlock cells / cells / spreadsheets

To remove settings for cell/cell/ spreadsheet settings, open the Protect Sheets and Ranges bar again. Click to select the configuration to delete.

Lock properties in Google Sheets

Next, click on the trash can image next to the vital description.

Lock properties in Google Sheets

You will receive a message asking to confirm the deletion of your basic lock setting. Click the “Remove” button to finish.

Lock properties in Google Sheets

After removing the setting of the cell key, anyone who has the right to edit your spreadsheet file can edit the contents of the previously locked cells/worksheets.

I hope this article will help you!

LEAVE A REPLY

Please enter your comment!
Please enter your name here