How to excel at Excel Series 1: How to Lock Cells in Excel

Part 1:

Imagine spending 20 hours working on a spreadsheet just to send it to a coworker and have them inadvertently change cells that shouldn’t be changed. That would be frustrating, to say the least. Thankfully, Excel offers a quick solution to lock cells and prevent them from being edited.

Excel automatically locks all the cells in a sheet or workbook when you protect it. To do this, follow these easy steps:

Step 1: Navigate to the Review tab.

Step 2: Click Protect Sheet. In this window, you can enter an optional password that would be required for anyone to enter in order to unlock the sheet.

Step 3: Click OK.

So, that’s how to lock cells in Excel. Now, when you or anyone else tries to edit the cells that have been locked, they’ll be notified via a pop-up message that they can’t do so unless they unlock it. The cells can then only be unlocked when the sheet is unprotected. Just follow the same steps but click Unprotect Sheet instead of Protect Sheet.

Read more easy Excel tips and tricks on our blog.

Download BizInsight Overview Download BizBroadcast Overview