For some reason, you may want to lock cells in Excel to protect them from being edited. In this article, we will show you how to lock or unlock all cells or specific cells in Excel to help you protect the contents in Excel. In addition, if you want to rescue your missing Excel files, you can try MiniTool Power Data Recovery, a professional data recovery software .

You create a worksheet and want to send it to others, but you may be concerned that someone else will tamper with the contents in cells. In a situation like this, how to protect cells in Excel from being re-edited? The answer is: you can make your Excel lock cells according to your requirements.

You can choose to lock cells in Excel. Then anyone who opens this Excel is not allowed to edit the cells that are protected. On other hand, you can also choose to lock specific cells in Excel according to your requirements.

In this blog, MiniTool Software will introduce how to lock cells in Excel and how to lock specific cells in Excel.

These methods work in Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel 2007.

How to Merge or Unmerge Cells in Excel (without Losing Data)?
How to Merge or Unmerge Cells in Excel (without Losing Data)?

Do you know how to merge or unmerge cells in Excel without losing data? In this article, we will show you some useful guides.

Read More

How to Lock Cells in Excel?

In this part, we will show you how to lock all cells in a worksheet. By doing this, all cells in the Excel file will become uneditable.

How to Lock and Protect All Cells in Excel?

Step 1: Select all cells in Excel. You can move the mouse cursor to the top-left corner of the sheet and click your mouse to select all cells. You can also click one cell outside the range of cells that contain contents and press Ctrl + A to select all cells.

Step 2: Under the Home tab, click Format in the Cells group and then select Format Cells from the expanded menu.

select Format Cells under Format

Step 3: The Format Cells interface will pop up. Then, you need to switch to the Protection tab and make sure the checkbox next to Locked is selected.

If you use these steps on a workbook or worksheet you haven’t protected, you’ll see the cells are already locked. This means that the cells are ready to be locked when you protect the workbook or worksheet. You can also see that there is a message saying Locking cells or hiding formulas has no effect until you protect the worksheet (Review tab, Protect group, Protect Sheet button) . This is a guide to tell you how to protect your worksheet to lock cells or hide formulas.