Excel 2007 | How To Protect Selected Cells

Protecting selected cells is a great feature to use if users need access to your spreadsheets. This gives people the option to modify your spreadsheet with the exception of the few cells that you’ve protected. Use this tip if you’re creating forms, schedules or applications!

As always, let us know if there are things you need help with. You can receive these updates automatically through email by clicking below:

Subscribe to admins4admins.com by Email

 

HOW TO PROTECT SELECTED CELLS

1. Select all cells containing data.

2. Click on “Home” tab.

3. Choose the “Format” option on the ribbon to open the drop down list.

4. Click on “Lock Cell” option at the bottom of the list.

5. Right click on the cell that you want to protect.

6. Choose “Format Cells”.

7. Click on “Protection” tab.

8. Click to select the “Locked” box.

9. Click “OK”.

DOWNLOAD THE STEP-BY-STEP INSTRUCTIONS HERE:

How To Protect Selected Cells (PDF)