• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Excel Tutorials

Microsoft Excel Tutorials

  • Home
  • Tutorials
  • Learn
    • Formulas
    • Power Query
    • Errors
    • Videos
    • Charts
    • Shortcuts
    • Pivot Tables
    • Macros
    • Basics
    • Analysis
  • 240+ Excel Shortcuts
  • Privacy Policy
You are here: Home / Analysis / Lock Cells in Excel
Lock Cells in Excel

Lock Cells in Excel

posted on November 6, 2019

Have you ever wanted to lock a couple of cells rather than the whole sheet in your Excel worksheet? Locking an entire Excel sheet is different thing than locking separate cells.

WorkbookDownload

Previously In Analysis: Merge Cells in Excel

Here is the explanation:

All of the cells are locked by default, but you need to protect the excel worksheet so that locked cells should have effect. 

Here we first need to unlock all the cells

After that, we need to select that single target cell and then lock it

At last, we need to protect the worksheet so that our target cell will get locked

 Steps are explained below to know how to lock the cells:

STEP1: Locking Cells

Firstly, you need to click the upper left corner to select all of the cells:

Lock Cells in Excel

Now, select the format option just by clicking right in any cell.

Lock Cells in Excel

Make sure that Locked option is unticked so that your entire sheet is unlock, Then Click OK

Lock Cells in Excel

Now select the format cells by right-clicking on your target cell.

This time make sure to tick the Locked option so that your target cell get lock then Click OK.

Lock Cells in Excel

STEP2: Protect Your Spreadsheet

Now you need to protect your Excel spreadsheet to see that whether lock is working or not.

So, for checking that you must right-click on the Worksheet Name and select Protect Sheet.

Lock Cells in Excel
Here you will need to type in a password and Click OK after that. To show you in my example, I typed in excel as the password to lock this.

Now if you will try to edit the target cell, Excel will not be allowing you to do that but if you try to edit the other cells it will work fine.

Lock Cells in Excel

Filed Under: Analysis, Shortcuts Tagged With: excel shortcuts, Lock Cells, Lock Cells in Excel

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Download 240+ Shortcuts

Microsoft Excel comes with varieties of keyboard shortcuts which are stated below with excel shortcut name and its keys for Windows and Mac.

Categories

  • Basics
  • Formulas
  • Pivot Tables
  • Charts
  • Power BI
  • Analysis
  • Shortcuts
  • Macros
  • Add-Ins

Recent Comments

  • Olivia on Convert Formulas to Values in Excel
  • Pkv on How to Insert Comment In Power Query Steps?
  • Rahul on How to Insert Comment In Power Query Steps?
  • David on How to Insert Comment In Power Query Steps?
  • sofia on How to use Workday Formula in Excel?

Footer CTA

Get Weekly Updates in your mailbox

Get Started Now

Copyright © 2021