How to Lock a Number in Excel on Mac


The Microsoft Office for Mac software suite includes the Microsoft Excel spreadsheet application. Excel includes a protection feature that allows you to lock certain cells in a spreadsheet document. By locking a cell, you can prevent other users from being able to change the number or text in that specific section of the document. After you enable cell locking in Excel, you must choose a password for granting permission to edit locked cells.

Things You'll Need

  • Mac running OS X 10.5 or later
  • Microsoft Excel for Mac 2004 or later
  • Launch the Microsoft Excel program and open the spreadsheet file that contains the number you want to lock.

  • Open the "Edit" menu at the top of the screen and choose "Select All" to highlight all of the cells in your spreadsheet.

  • Right-click anywhere in the highlighted area and choose "Format Cells" from the contextual menu that appears.

  • Go to the "Protection" tab at the top of the pop-up window and clear the check boxes next to "Locked" and "Hidden." Click "OK" to return to the spreadsheet.

  • Highlight the single cell that contains the number or text you want to lock.

  • Right-click on the highlighted cell and choose "Format Cells" again.

  • Go back to the "Protection" tab, check the box next to "Locked" and then click "OK."

  • Go to the "Review" tab in the top toolbar.

  • Click on the "Protect" icon and then select the "Protect Sheet" option.

  • Enter the password you want to use to lock the spreadsheet and then click "OK."

Related Searches


  • Photo Credit Justin Sullivan/Getty Images News/Getty Images
Promoted By Zergnet


Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!