How to lock cells in Microsoft Excel for Mac

If you do complex formulations and workings using Microsoft Excel, you might surely be using the lock cells feature to prevent your formulas or functions in your worksheet intact and unaffected when other cells are edited, or you do not want important data to have tampered when you collaborate with your colleagues.

If you are new to Excel on your Mac/Macbook, you may want to know how it is done! Let's find out in below easy steps.

  • Step 1: Open the spreadsheet on your Mac.
  • Step 2: Now select the cell or cells that you want to lock.
  • Step 3: Control-Click (Right-click) and select Format Cells..
    Format Cells option Excel for Mac
  • Step 4: Now make sure the the Locked checkbox is selected. Closed the Format Cell dialog.
    Check Locked under Protection
  • Step 5: Now on the Ribbins, select Review tab.
  • Step 6: Click on Protect Sheet.
  • Step 7: Now:

    Uncheck "Select locked" If you don't want others to select locked cells.

    Check "Select unlocked" If you want others can select and fill out unlocked cells.

    Protect the sheet and contents of locked cells
  • Step 7: Now enter the Password and Verify it.

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail:

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap