How to unprotect cells in Google Sheets

Unprotecting a cell in Google Sheets refers to removing the protection that prevents users from editing or modifying certain cells within a spreadsheet. Unprotecting cells can be useful when creating complex formulas or when using a template that requires customization.

In this tutorial, we will learn how to unprotect cells in Google Sheets. Google Sheets allows us to remove protection from a protected range of cells by utilizing the Protect Sheets and Ranges feature in the Data tab. Within this feature, it is possible to eliminate the protections by deleting them.

Method 1: Using the Data Tab

Step 1 – Locate the Data Tab 

  • Locate and click on the Data tab.
  • A drop-down menu will appear.

Step 2 – Click on the Protect Sheets and Ranges  

  • Click on Protect Sheets and Ranges in the drop-down menu.

Step 3 – Click on the Protection 

  • Click on the Protection to be removed.

Step 4 – Click on the Delete range or sheet protection Button

  • Click on the Delete range or sheet protection Button.
  • A notification dialog box will appear.
  • Click on the Remove option.
  • The cells will be unprotected.

Method 2: Using the Context Menu

Step 1 – Right-Click Anywhere on the Sheet

  • Right-click anywhere on the sheet.
  • A context menu will appear.

Step 2 – Click on the “View more cell actions” Option and Select Protect Range

  •  Click on the “View more cell actions” option.
  • Select the “Protect Range” option.

Step 3 – Click on the Protection 

  • Click on the Protection to be removed.

Step 4 – Click on the Delete range or sheet protection Button

  • Click on the Delete range or sheet protection Button.
  • A notification dialog box will appear.
  • Click on the Remove option.
  • The cells will be unprotected.