docs / articles / Excel Keyboard Shortcut: Lock Cell in a Flash

Excel Keyboard Shortcut: Lock Cell in a Flash

Sara Jul 09, 2026 2026-07-09 04:40:45

Ever found yourself wishing you could lock a cell in Excel to prevent accidental edits? You're not alone. Excel's keyboard shortcuts can save you time and effort, and locking a cell is no exception. Let's dive into how you can do this efficiently.

How to lock some cell with password in excel | Excel Tips and Tricks #05
How to lock some cell with password in excel | Excel Tips and Tricks #05

Before we get started, ensure your Excel version is up-to-date. The steps below are applicable to Excel 2013 and later versions, including Excel Online.

Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

Understanding Cell Protection in Excel

In Excel, cell protection is a feature that allows you to lock cells to prevent unwanted changes. It's particularly useful when you want to preserve formulas, data, or formatting in specific cells.

How to Lock Cells in Excel: A Step-by-Step Guide | MyExcelOnline
How to Lock Cells in Excel: A Step-by-Step Guide | MyExcelOnline

Cell protection is part of Excel's worksheet protection feature. When you protect a worksheet, you can choose which cells to lock and which ones to leave unlocked.

Locking a Single Cell

How to Lock a Cell in Excel
How to Lock a Cell in Excel

To lock a single cell in Excel, follow these steps:

Keyboard Shortcut: Select the cell, then press Ctrl + 1 (Windows) or Cmd + 1 (Mac) to open the Format Cells dialog box. Go to the Protection tab, uncheck the Locked box, then click OK.

Locking Multiple Cells

How to Fix Arrow Keys Scrolling in Excel
How to Fix Arrow Keys Scrolling in Excel

If you need to lock multiple cells, you can do so in a similar manner:

Keyboard Shortcut: Select the cells, then press Ctrl + 1 (Windows) or Cmd + 1 (Mac). In the Format Cells dialog box, go to the Protection tab, uncheck the Locked box, then click OK.

Protecting the Worksheet

How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide
How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide

After locking the cells, you'll want to protect the worksheet to prevent accidental unlocking.

To do this, select the Review tab, then click Protect Sheet. In the Protect Sheet dialog box, you can add a password for an extra layer of security. Once you're done, click OK.

Management training, Soft skills, Power BI, Excel Learning solutions
Management training, Soft skills, Power BI, Excel Learning solutions
How to Move Selected Cells in Excel with Keyboard (4 Methods)
How to Move Selected Cells in Excel with Keyboard (4 Methods)
Lock Cells in Excel
Lock Cells in Excel
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
an image with the text excel lock specific cells protect cells from editing
an image with the text excel lock specific cells protect cells from editing
Excel Shortcuts Every Professional Should Know
Excel Shortcuts Every Professional Should Know
Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips
Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips
Delete Blank Cells
Delete Blank Cells
Excel shortcuts and tips
Excel shortcuts and tips
⌨️ Top 50 Keyboard Shortcuts You Must Know in 2026 ⚡ Work Faster & Boost Productivity!
⌨️ Top 50 Keyboard Shortcuts You Must Know in 2026 ⚡ Work Faster & Boost Productivity!
Most Useful Excel Keyboard Shortcuts You Must Know
Most Useful Excel Keyboard Shortcuts You Must Know
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
Excel shortcut ...✅
Excel shortcut ...✅
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
an image of a computer keyboard with the words excel ctrl shortcuts
an image of a computer keyboard with the words excel ctrl shortcuts
Copy Only Visible Cells in Excel
Copy Only Visible Cells in Excel
Computer tricks😉
Computer tricks😉
Excel shortcut keys
Excel shortcut keys
a computer screen with the text ctrl + g on it
a computer screen with the text ctrl + g on it
5 Powerful Excel Formatting Shortcuts
5 Powerful Excel Formatting Shortcuts

Unprotecting the Worksheet

If you need to unlock the cells or make changes to the protected worksheet, you'll first need to unprotect it:

Keyboard Shortcut: To unprotect the worksheet, select the Review tab, then click Unprotect Sheet. If you set a password, you'll need to enter it here.

And there you have it! You're now equipped with the knowledge to lock cells in Excel using keyboard shortcuts. Happy Exceling!