Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Protect Individual Cells from Being Edited in Excel 2007

Monday, April 23rd, 2012 by | Filed Under: MS Excel, MS Office Help

Riani from South Africa writes:

Is there a way to protect only some information on a Microsoft Excell worksheet? I dont want to protect the sheet or book, because I still need info from them that needs to be typed in – just some formulas.

Once you have your excel worksheet created, select all the cells in the worksheet by left clicking the arrow next to Column A & on top of Row 1 and then right click and go to Format Cells. Go to the protection tab and left click the box next to “Locked” so there is no checkmark.

Step 1

step 2

Next, highlight the cells you wish to protect and right click on them and click on format cells. Click on protection tab again and then left click on the box next to Locked so that there is a checkmark in the box.

Step 3

step 4

Now, go to the Review Panel and click “protect sheet” and enter a password.  Click OK and enter the password again. Click OK again.

step 5


You can edit all the cells, except the ones you protected.

Step 6


Tags: , , , , ,

5 Responses to “Protect Individual Cells from Being Edited in Excel 2007”

  1. Don Shelton says:

    I have been working on the above for sometime and figured out how to do it;
    however, I have several Excel Financial formulas on a worksheet and it would take forever to highlight all of them. I found a hint on the Excel
    in googling it and the writer said you use from the clipboard paste specail and all of your formulas will highlighted and be protected at using this sequence and I cannot figure out how to do this? I sure someone has figure out how to do this.

  2. Rosy says:

    It seems like you did not answer the issue – you showed how to lock the cells but she only wanted to lock formulas and wanted to be able to change the data in those cells?

  3. Tasha Peters says:

    good site!! You could start many more. I love all the info offered. I will stay tuned.

  4. Anil Reddy says:

    Wrong solution.It’s protecting entire sheet not of specific cells

  5. pranav says:

    select the entire sheet and click the right click on mouse and click on format cells and in protection unselecte the entire sheet then selct specific cells area and locked it then protect the sheet you can get defenet result

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive