Filter by Categories
Select all
Budget
Business Statements
Calendars
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Inventory
Investments
Invoice/ Bill
Maintenance
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Quotation
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
UAE VAT
UK VAT
Filter by File Types






How to lock cells in Microsoft Excel ?

How to Lock Cells in Microsoft Excel

Background

Suppose that your boss wants you to protect an entire workbook, but also wants to be able to change a few cells after you enable protection on the workbook. Before you enabled password protection, you had unlocked some cells in the workbook. Now that your boss is done with the workbook, you can lock these cells.

This tutorial is relevant for Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019 and Excel 2016.

Lock cells in Desktop version of Excel 

Follow these steps to lock cells in a worksheet:

  1. Select the cells you want to lock.
  2. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.
  3. On the Protection tab, select the Locked check box, and then click OK to close the popup.

    Note: If you try 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.

  4. On the Review tab in the ribbon, in the Changes group, select either Protect Sheet or Protect Workbook, and then reapply protection.

    Tip: It’s a best practice to unlock any cells that you may want to change before you protect a worksheet or a workbook, but you can also unlock them after you apply protection. To remove protection, simply remove the password.

    In addition to protecting workbooks and worksheets, you can also protect formulas.

Lock cells in Web version of Excel

Excel for the web can’t lock cells or specific areas of a worksheet.

If you want to lock cells or protect specific areas, click Open in Excel and lock cells to protect them or lock or unlock specific areas of a protected worksheet.

Content

Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes