• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

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

Excel 2016: How to Lock or Unlock Cells

By Mitch Bartlett 4 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…
  • Excel 2019 & 2016: Force "Open as Read Only" Prompt
    Excel 2019 & 2016: Force "Open as Read Only" Prompt
  • 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

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

Reader Interactions

Comments

  1. 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.??

  2. Jan Safran says

    January 8, 2020 at 9:15 pm

    Thank you. It worked for me.

  3. 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.

  4. kanchan says

    August 23, 2018 at 5:29 am

    I have locked my Filter lock in excel sheet

Did this help? Let us know! Cancel reply

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 Set Up a Recurring Meeting in Teams
  • Fix: Microsoft Teams Keeps Freezing My Computer
  • Are you having problems with the Galaxy S21 Wi-Fi? Here’s how you can fix it
  • How to Migrate Skype For Business Users To Teams
  • How to Get the Most out of Google Files App
  • Fix Microsoft Teams Channel Email Not Working
  • Microsoft Teams: Cannot Create New Folder in Files
  • Fix: Microsoft Teams Guests Can’t Chat

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.

Follow me on Twitter, or visit my personal blog.

You May Also Like

© Copyright 2021 Technipages · All Rights Reserved · Privacy