How To Unlock Cells In Excel

To unlock cells in Excel, select the cells you want to unlock, right-click and choose Format Cells, go to the Protection tab, uncheck the Locked option, and finally protect the worksheet.

In today’s digital age, Microsoft Excel has revolutionized the way we handle data and information. With its powerful features and capabilities, Excel has become an essential tool for businesses, organizations, and individuals alike. One of the most common tasks when working with Excel is the need to unlock cells in order to make changes or updates to the data. Whether you’re a beginner or an experienced user, knowing how to unlock cells in Excel is a skill that can greatly enhance your productivity and efficiency. In this blog post, we will explore various methods and techniques to unlock cells in Excel, allowing you to unleash the full potential of this versatile software. So, let’s dive in and unlock the secrets of Excel!

How To Unlock Cells In Excel: Step-by-Step


Step 1: Open Excel Document,

To unlock specific cells in an Excel document, open the file and access the “Review” tab. From there, select “Protect Sheet” and uncheck the “Locked” option for the desired cells, allowing them to be edited.

Next Step

Step 2: Select Cells,

To select specific cells for unlocking, simply click and drag your mouse. To unlock all cells on the worksheet, press CTRL+A.

Next Step

Step 3: Navigate to the Protect group,

Once on the Ribbon, navigate to the Review tab. Look for the ‘Protect’ group and proceed to click on it.

Next Step

Step 4: Select Protect Sheet,

From the drop-down list, select ‘Protect Sheet’. A dialog box will appear, allowing you to configure the settings and permissions for protecting the sheet, such as preventing edits or limiting access to certain users.

Next Step

Step 5: Enter the Password,

If the sheet is password protected, you can unprotect it by entering the password in the ‘Unprotect Sheet’ dialog box, allowing you to remove the restrictions and access the contents of the sheet.

Next Step

Step 6: Open the Format Cells dialog,

To modify the formatting of the cells you have selected, simply right-click on one of the cells and choose the Format Cells option from the menu that appears.

Next Step

Step 7: Select Protection Tab,

Within the Format Cells dialog box, you can select the ‘Protection’ tab to customize protection options for the selected cells, providing additional security for the data within.

Next Step

Step 8: Remove Check Mark,

By default, the ‘Locked’ box is checked. To deselect it, simply click on the box, removing the check mark.

Next Step

Step 9: Click OK,

Once you uncheck the ‘Locked’ box, simply click ‘OK’ to close the dialog box and save your changes.

Next Step

Step 10: Reapply Sheet Protection,

To re-protect the sheet, preserve your selected cells unlocked by setting a password in the ‘Protect Sheet’ option.

Next Step

Step 11: Save Changes,

Make sure to save your workbook by clicking File and Save or using CTRL+S to keep your changes intact.


Unlocking cells in Excel is an essential skill that can greatly enhance your productivity and efficiency when working with spreadsheets. Whether you need to protect sensitive data or allow collaborators to make changes to specific cells, understanding how to unlock cells is crucial in harnessing the full potential of Excel. By following the steps outlined in this blog post, you can confidently navigate the cell protection options, customize permissions for individual cells, and ensure the integrity of your data. With this newfound knowledge, you have the power to take control of your spreadsheets and unlock a world of possibilities in Excel.

Table of Contents