how to lock multiple cells in excel for mac

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.

FAQ But, why is Protect Sheet is grayed out If its 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.

You Might Also Like EnableDisable Display of Formulas in Cells in Excel Excel 2016: How to Install and Use Macros Enable Slashes () in Excel 2016 Excel 2016: Unhide Rows or Columns Copy and Paste Values Without Formulas in Excel Excel 2019 2016: Force Open as Read Only Prompt How to Automatically Lock Your Windows PC Using Dynamic Lock Google Sheets: Protect Cells Filed Under: Office Tagged With: Excel 2013, Excel 2016 Reader Interactions Comments 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.

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.

Required fields are marked Comment Name Email This site uses Akismet to reduce spam.

Recent Posts How to Disable Shader Pre-Caching in Steam Powerpoint Slide Goes Blank: Fix it With This Guide Fix PowerPoint Errors While Exporting Videos How to Enable Syntax Highlighting in Sublime Text 3 Steam: How to Change the Homepage for the in-Game Overlay Browser Fix Powerpoint Goes Back to the First Slide How to Change the Theme in Sublime Text 3 How to Add a New Steam Library Folder Whos Behind Technipages My name is Mitch Bartlett.

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

How To Lock Multiple Cells In Excel For Mac