How to Protect a Worksheet & Only Allow Edit in Certain Cells in Excel 2007


Microsoft Excel 2007 is a spreadsheet program that is a part of the Microsoft Office suite. Excel 2007 allows your business to track expenses, manage inventory and create financial reports. You can also use Excel 2007 to track personal expenses, create chore lists and manage your budget at home. These spreadsheets can be shared with others in a protected mode that allows others to edit only the fields you specify to protect your original document.

  • Open Microsoft Excel 2007 by clicking on the "Excel" icon on your desktop.

  • Use your mouse to highlight the cells on the worksheet that you want to protect from editing.

  • Locate the "Home" tab at the top of the screen. Click on the "Format" option that is located in the "Cells" subgroup.

  • Click the "Protect Sheet" option under the "Protection" subgroup.

  • Type a password into the "Password to Unprotect Sheet" space. If you don't want to use a password, leave the space blank. Click the "OK" button.

  • Click the "Format" button on the "Home" tab. Click on the "Lock Cell" option under the "Protection" subgroup.

Related Searches


  • Photo Credit Stockbyte/Stockbyte/Getty Images
Promoted By Zergnet


You May Also Like

  • Samsung Cell Phone Instructions

    For many years, Samsung has manufactured cell phones for many different phone networks. Though there are differences in the design and features...

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!