How to unlock cells in Excel

You can trust PC Guide: Our team of experts use a combination of independent consumer research, in-depth testing where appropriate - which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

Are you wondering how to unlock cells in Excel? We’ve got you covered right here.

There’s a great feature in Microsoft Excel that allows you to lock cells and prevent them from being edited when you share your spreadsheet with others. However, sometimes you want others to be able to edit certain cells, so you’ll need to learn how you can unlock them.

This is where we come in. In This guide, we will explain how to unlock cells in Excel so you can share your spreadsheets easily.

Here’s how you can quickly unlock cells in Excel.

The first thing you need to do is select a cell you want to unlock. You can either select an individual cell or a row/column.

Next, you need to press right-click to open a menu, and click on Format Cells.

Learn how to create and unlock cells in Excel to create an organized spreadsheet.

All you need to do now is uncheck the box next to Locked, and click OK. Once done, the cells will be unlocked.

How to change the format of a file in Windows 10 and unlock cells in Excel.

If you want to unlock all cells in Excel, simply press Ctrl + A to select all cells, and then proceed with the above steps.

How to unlock all cells in a protected Excel sheet

If you want to unlock all cells in a protected Excel sheet, there’s a method for it too.

First, got to the Review tab, which is right next to the Data tab.

Next, click on the Unprotect Sheet button. Once done, all the cells will be unlocked. Don’t worry, you won’t have to enter any password for it.

The excel spreadsheet with an unlocked cells.

Conclusion

And that’s how to unlock cells in Excel! It’s super easy to do and it’s a great method for protecting parts of your spreadsheet so others who can access it cannot make changes or edits that can affect your data. So, only give the password for the protected spreadsheet to those who are permitted to make edits. Then you will be able to work as a group on the perfect spreadsheet.

Learn more about Excel through these helpful guides: