How To Lock Cells In Excel

To lock cells in Excel, select the cells you want to lock, right-click and choose “Format Cells,” go to the “Protection” tab, check the “Locked” box, and then protect the worksheet by clicking on “Review” > “Protect Sheet.”

In the world of spreadsheets, Microsoft Excel is a powerful tool that has become a go-to application for data analysis, financial forecasting, project management, and much more. With its array of features and functions, Excel empowers users to organize, manipulate, and analyze data with ease. One important aspect of working with Excel is protecting the integrity and security of your data. In this blog post, we will dive into the topic of locking cells in Excel and explore various techniques to safeguard your critical information from accidental alterations or unauthorized access. Whether you are a beginner or an experienced user, understanding how to lock cells in Excel is crucial to maintaining the integrity and confidentiality of your data. So, let’s get started and learn the essential techniques to keep your Excel spreadsheets secure.

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


Step 1: Select the cells you want to lock

To lock cells in Excel, open your workbook, go to the desired sheet, and select the cells you want to protect by clicking and dragging your cursor.

Next Step

Step 2: Open the Format Cells dialog box

To access the ‘Format Cells’ dialog box, right-click on the selected cells. Alternatively, go to the Home tab, choose Cells group, and click on Format -> Format Cells.

Next Step

Step 3: Go to the Protection tab

In the Format Cells dialog box, accessible through the right-click menu or Ribbon toolbar, click on the Protection tab. It is the second tab among options like Number, Alignment, Font, and Border to customize cell formatting and protect cell content.

Next Step

Step 4: Check the Locked option

Under the Protection tab, ensure both checkboxes, Locked and Hidden, are selected. By default, all cells have the Locked option enabled. If it’s not, check “Locked”.

Next Step

Step 5: Click OK.

Once you’ve clicked on the “Locked” box, simply close the Format Cells dialog box by clicking OK.

Next Step

Step 6: Protect the worksheet

This action will prompt a dialog box to appear. Enter a password if desired and choose the options you want to restrict, such as editing, formatting, or sorting.

Next Step

Step 7: Set a password

In the “Protect Sheet” window, enter your password (optional) and select the option to protect the worksheet and locked cells. Click OK to complete the process.

Next Step

Step 8: Confirm your password

During the account setup process, you will be prompted to reenter your password to ensure accuracy. Simply input the same password as before and click the OK button to confirm it.


In conclusion, learning how to lock cells in Excel is a valuable skill that can help protect the integrity and confidentiality of your data. By implementing cell locking, you can prevent accidental edits or unauthorized changes, ensuring the accuracy and reliability of your spreadsheets.

We explored two main methods for locking cells in Excel – using the “Protect Sheet” feature and applying cell-specific formatting. The “Protect Sheet” option provides a comprehensive level of protection by allowing you to restrict various actions, such as editing cells, inserting or deleting columns, formatting cells, and more. On the other hand, cell-specific formatting allows you to choose which cells to lock, providing more flexibility in your data protection strategies.

Remember to review and test your locked cells to ensure they are functioning correctly before sharing your spreadsheet with others. Additionally, it is crucial to keep the password used for sheet protection safe, as losing it may result in irreversible loss of access to your protected cells.

By applying these techniques, you can enhance the security of your Excel workbooks and have peace of mind knowing that your valuable data is safe from accidental modifications or unauthorized access. So, start implementing cell locking in your spreadsheets today and take full control over your data!

Table of Contents