Excel Tutorial: How To Lock Cells In Excel Online


Working with Excel Online is a convenient way to collaborate and manage data, but it's essential to ensure that sensitive information is protected. Locking cells is a crucial feature that prevents accidental editing or unauthorized access to specific data within a spreadsheet. In this Excel tutorial, we will cover the step-by-step process of locking cells in Excel Online to help you keep your data secure.

Key Takeaways

  • Locking cells in Excel Online is crucial for protecting sensitive information and preventing unauthorized access.
  • The benefits of locking cells include preventing accidental edits, protecting formulas and data integrity, and ensuring data security and confidentiality.
  • Following the step-by-step guide on locking cells in Excel Online can help ensure that your data remains secure.
  • Sharing locked cells with others requires careful consideration, and it's important to share the password separately to maintain security.
  • Regularly reviewing and updating locked cells, training team members on respecting locked cells, and keeping passwords secure are essential for effective management of locked cells in Excel Online.

The benefits of locking cells

Locking cells in Excel can provide several important benefits to users, including:

A. Preventing accidental edits

By locking cells, you can prevent accidental changes to important data or formulas. This can help to maintain the accuracy and reliability of your spreadsheets, especially when multiple users have access to the file.

B. Protecting formulas and data integrity

Locking cells that contain formulas or critical data can help to protect the integrity of your calculations and analyses. This can be particularly important in financial or scientific applications where accuracy is paramount.

C. Ensuring data security and confidentiality

Locking cells can also help to ensure the security and confidentiality of sensitive information. By restricting access to specific cells, you can prevent unauthorized individuals from viewing or modifying sensitive data.

How to lock cells in Excel Online

Excel Online is a powerful tool for creating and managing spreadsheets, and locking cells can help protect important data from being accidentally modified. Here's a step-by-step guide on how to lock cells in Excel Online.

Step-by-step guide on selecting the cells to be locked

  • Select the cells: Open your Excel Online spreadsheet and click and drag to select the cells you want to lock. You can also select entire rows or columns.
  • Go to the "Review" tab: Once the cells are selected, navigate to the "Review" tab in the Excel Online ribbon.
  • Click "Allow Users to Edit Ranges": In the "Changes" group, click on "Allow Users to Edit Ranges".

Instructions on accessing the "Format Cells" dialog box

  • Open the "Format Cells" dialog box: After clicking "Allow Users to Edit Ranges," a new dialog box will appear. Click on "New" to define the range of cells that you want to lock.
  • Set the range: In the "New Range" dialog box, specify the range of cells to be locked by selecting them or typing their references directly into the field.
  • Click "OK": Once the range is defined, click "OK" to close the dialog box.

Demonstrating the process of locking cells with a password

  • Set a password (optional): If you want to protect the locked cells with a password, click on "Protect Sheet" in the "Review" tab and enter a password in the "Password to unprotect sheet" field.
  • Confirm the password: Re-enter the password to confirm, and click "OK".
  • Save the changes: Once you have set the password, click "OK" to save the changes and lock the selected cells. Your cells are now locked and protected from editing without the specified password.

Sharing locked cells with others

When working on a spreadsheet in Excel Online, you may want to restrict access to certain cells to maintain data integrity. However, there may be instances where you need to share the spreadsheet with others while keeping these cells locked. Here's how you can achieve this:

A. Explaining how to share a spreadsheet with locked cells

First, you'll need to lock the cells you want to restrict access to. To do this, select the cells, right-click, and choose "Format Cells." In the Format Cells dialog box, go to the "Protection" tab and check the box that says "Locked." After that, go to the "Review" tab, click on "Protect Sheet," and set a password to protect the sheet.

Once the cells are locked and the sheet is protected, you can proceed to share the spreadsheet with others. Go to the "Share" button in the top right corner of the Excel Online interface, enter the email addresses of the people you want to share the spreadsheet with, and click "Send." They will receive an email with a link to access the spreadsheet.

B. Highlighting the importance of sharing the password separately

It's crucial to highlight the importance of sharing the password to unlock the cells separately from the link to the spreadsheet. This ensures that only authorized individuals can access the locked cells. When sharing the password, it's best to use a secure communication method, such as sending it through a secure messaging platform or telling it to the recipient in person, to maintain data security.

Tips for managing locked cells

Locking cells in Excel online can help protect sensitive information and prevent accidental changes to important data. Here are some tips for effectively managing locked cells:

A. Regularly reviewing and updating locked cells as needed

  • B. Regularly review the locked cells in your Excel online spreadsheets to ensure that they are still relevant and necessary. Remove any unnecessary locks to streamline the user experience.
  • C. Update locked cells as needed to reflect changes in your data or business processes. This will ensure that the locked cells continue to serve their intended purpose.

B. Training team members on the importance of respecting locked cells

  • B. Educate your team members on the importance of respecting locked cells in Excel online. Explain the reasons behind the locks and emphasize the impact of unauthorized changes to the data.
  • C. Provide clear guidelines on which cells are locked and the appropriate procedures for requesting access or updates to locked cells.

C. Keeping a record of passwords for locked cells in a secure location

  • B. Keep a secure record of passwords for locked cells in a designated location, such as a password-protected document or a secure database. Only authorized personnel should have access to this information.
  • C. Regularly review and update the list of passwords to ensure that only current team members have access to the necessary information.

Troubleshooting common issues with locked cells

When working with locked cells in Excel online, you may encounter some common issues. Here are some tips for troubleshooting these issues:

A. Addressing issues with forgotten passwords

If you have forgotten the password for a locked cell or worksheet, it can be a frustrating experience. Here are some steps you can take to address this issue:

  • Check for password hints: Look for any password hints that you may have set up when locking the cells. Sometimes, these hints can jog your memory and help you remember the password.
  • Use a password recovery tool: There are third-party tools available that can help you recover forgotten passwords for Excel worksheets. Be cautious when using these tools and ensure that they are from a reputable source.
  • Contact the person who locked the cells: If you are working on a shared document, reach out to the person who locked the cells. They may be able to provide you with the password or assist in unlocking the cells.

B. Providing solutions for unlocking mistakenly locked cells

It's not uncommon to accidentally lock cells in Excel online. Here are some solutions for unlocking mistakenly locked cells:

  • Check for cell protection settings: Go to the "Review" tab and click on "Unprotect Sheet." If prompted, enter the password to unlock the cells.
  • Copy and paste the data: If you are unable to unlock the cells, consider copying the data to a new worksheet where the cells are not locked. This will allow you to work with the data without being hindered by locked cells.
  • Use the "Format Cells" feature: To unlock cells, you can use the "Format Cells" feature to remove the protection. Simply select the locked cells, right-click, and choose "Format Cells." In the "Protection" tab, uncheck the "Locked" box and click "OK."


A. Locking cells in Excel Online is a crucial aspect of protecting the integrity of your data and ensuring that important information remains unchanged. By following the tutorial, you can easily secure specific cells and prevent unwanted edits or modifications.

B. I encourage all readers to apply the tutorial in their Excel Online usage to enhance the security and reliability of their spreadsheets. The simple steps outlined in this tutorial can make a significant difference in protecting your data and maintaining the accuracy of your work.

C. If you have any feedback, questions, or need further clarification on locking cells in Excel Online, please feel free to reach out. Your input is valuable, and I am here to assist you in mastering this important skill for effective data management.

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles