Skip to content
Back to template gallery
Microsoft Excel
Microsoft Excel

How to lock cells in Excel

In this guide, you will learn how to configure cell locking and protect a worksheet in Microsoft Excel. You will select your data, adjust the protection settings within the Format Cells dialog, and enable sheet protection from the Review tab. Finally, you will test the protection settings to ensure your worksheet is secured against unauthorized edits.

Operations
13 steps 5 min Community template
1

Open the Excel sheet

In Excel, you can lock specific cells to prevent users from editing them while allowing them to edit other cells.

www.microsoft.com
Open the Excel sheet
2

Press Ctrl + A to select the worksheet.

3

Press Ctrl + 1 to open Format Cells.

4

Click the Protection tab

Open the Protection tab and click the "Locked" checkbox in the Format Cells dialog to change the lock status to Uncheck.

www.microsoft.com
Click the Protection tab
5

Click the OK button

Click the OK button at the bottom of the Format Cells dialog to apply your changes.

www.microsoft.com
Click the OK button
6

Select the cells you want to lock

Click the column B header to select the entire column in the spreadsheet.

www.microsoft.com
Select the cells you want to lock
7

Press Ctrl + 1

8

Click the Protection tab

Click the Locked checkbox in the Format Cells dialog to change the lock status of the selected cells to Locked

www.microsoft.com
Click the Protection tab
9

Click the OK button

Click the OK button at the bottom of the Format Cells dialog to apply your changes.

www.microsoft.com
Click the OK button
10

Click the Review tab

Click the Review tab in the top ribbon to access the worksheet protection and review tools.

www.microsoft.com
Click the Review tab
11

Click the Protect Sheet button

Click the Protect Sheet button in the ribbon toolbar to restrict editing access to the current worksheet.

www.microsoft.com
Click the Protect Sheet button
12

Click the OK button

Click the OK button at the bottom of the Protect Sheet dialog to apply your settings. Ensure Select unlocked cells is checked.

www.microsoft.com
Click the OK button
13

Test whether the cells are locked by editing the Department cell value

Test whether the cells are locked by editing the Department cell value

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.