• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Excel 2016: How to Lock or Unlock Cells

Excel 2016: How to Lock or Unlock Cells

By Mitch Bartlett 6 Comments

Are you unable to modify cells because they are locked? Here’s how to lock or unlock cells in Microsoft Excel 2016 and 2013.

  1. Select the cells you wish to modify.
  2. Choose the “Home” tab.
  3. In the “Cells” area, select “Format” > “Format Cells“.
    Excel Format Cells option
  4. Select the “Protection” tab.
    Excel locked setting
  5. Uncheck the box for “Locked” to unlock the cells. Check the box to lock them. Select “OK“. As the dialog box says, locking cells or hiding formulas has no effect until you protect the worksheet. You can do so under the “Review” tab by selecting “Protect Sheet“.
    Excel protect sheet

FAQ

But, why is “Protect Sheet” is grayed out?

If it’s a shared workbook, “Protect Sheet” may be grayed out. Unshare it by selecting “Review” > “Share Workbook“, then deselect “Allow changes by more than one user…“.

Otherwise, multiple worksheets are selected. Right-click any tab, then select “Ungroup Sheets“.

You Might Also Like

  • Enable/Disable Display of Formulas in Cells in Excel
    Enable/Disable Display of Formulas in Cells in Excel
  • Enable Slashes (/) in Excel 2016
    Enable Slashes (/) in Excel 2016
  • Excel 2016: How to Install and Use Macros
    Excel 2016: How to Install and Use Macros
  • Excel 2016: Unhide Rows or Columns
    Excel 2016: Unhide Rows or Columns
  • Copy and Paste Values Without Formulas in Excel 2019, 2016, & 365
    Copy and Paste Values Without Formulas in Excel 2019, 2016,…
  • Google Sheets: Set Cells to Same Size
    Google Sheets: Set Cells to Same Size
  • Google Sheets: Protect Cells
    Google Sheets: Protect Cells
  • Google Sheets: Remove Formatting From Cells
    Google Sheets: Remove Formatting From Cells
  • How to Automatically Lock Your Windows PC Using Dynamic Lock
    How to Automatically Lock Your Windows PC Using Dynamic Lock

Filed Under: Office Tagged With: Excel 2013, Excel 2016

Reader Interactions

Comments

  1. RI says

    May 26, 2022 at 1:48 pm

    I have followed the instructions but instead of only my locked cells, it locked all cells. Feature is not working properly.

  2. Michael says

    May 24, 2022 at 11:02 pm

    This didnt work on the selected cells only but the whole sheet. Same as MS instructions which also don’t work

  3. ruk thapa says

    March 19, 2020 at 11:46 am

    This formula is not working. As i have been following this formula to lock the cell value or number which cannot be edited or changes anything in that cell but it is allowing to edit. Please help why this not working.??

  4. Jan Safran says

    January 8, 2020 at 9:15 pm

    Thank you. It worked for me.

  5. Gordon Rettke says

    November 5, 2018 at 11:57 am

    I followed very carefully but it ended locking all my cells rather than just the cells I chose.
    Also, the instructions needed another step at the very end.. It did not say what to choose from a long list
    of options.

  6. kanchan says

    August 23, 2018 at 5:29 am

    I have locked my Filter lock in excel sheet

Did this help? Let us know!

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • How to Build the Best Themed PC for Your Budget
  • Windows 11: How to Change the System Sounds
  • Windows 11: How to Get the Battery Report
  • How to Fix Mic Not Working on Android
  • Google Maps: How to Use Coordinates
  • How to Turn Yourself into WhatsApp Stickers
  • What to Do When WhatsApp Web Doesn’t Work
  • Windows 11: How to Turn on Bluetooth

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

© Copyright 2022 Technipages · All Rights Reserved · Privacy