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

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

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

Excel Worksheet Protection

Wednesday, November 17th, 2004 by | Filed Under: MS Excel
 
Loading...


Excel Worksheet Protection

So, we’re all looking to protect our worksheets from changes—changes others may make or changes we may accidentally make.

Since we’re all here for the same thing, let’s get right to it.

To protect your entire worksheet from changes you need to go to the Tools menu, Protection submenu, Protect Sheet choice.

image

The Protect Sheet window will open – giving you choices as to what to protect and about a password.

image

Uncheck any option that you don’t want protected and enter a password in the bottom if you want one.

Click OK.

Excel will then ask you to re-enter the password just to be sure that there were no typos.

Re-enter the password and click OK.

And… that’s it—no more changes to your worksheet!!!

What was that I heard?

You only want to protect some cells?

Maybe, oh let’s say, only the cells containing the formulas?

Can that be easily done too?

Yep. (Just the answer you were looking for I’m sure.)

Here’s what to do to protect only some cells.

I must say first that you need to start with the worksheet completely unprotected.

Next you need to tell Excel which cells to “Lock” when you protect the sheet.

By default, they’re all set to be “Locked”.

So, somehow you need to change the settings for the cells that shouldn’t be protected.

The logic you take depends upon how much of the worksheet you’re trying to protect.

If you have just a few cells that are not to be protected then highlight them and go to the Format menu, Cells choice. (Ctrl + 1)

On the Protection tab uncheck the Locked box.

image

Then click OK.

Now go through the Tools menu to Protect the sheet. (As we did above.)

Voila!

Only the cells you didn’t change the “Locked” status for are protected.

One last thing…

What do you do if you’ve got only a few cells you want protected? (That is, most of the cells are not to be protected.)

I guess there are lots of ways but, one way might be to select the entire sheet with the Select All button.

image

Go through the Format menu, Cells choice to unlock the cells of the entire sheet. (Described above.)

Click in the sheet to remove the “entire sheet highlighting”.

Now go back and highlight the cells you need protected.

Return to the Format Cells window, Protection tab. (Format menu, Cells choice or Ctrl + 1)

Re-check the “Locked” box.

Click OK.

Finally, go through the Tools menu to Protect the sheet.

And there you have it…

“No touch my cells” is easier than you could have ever imagined.

~ April

Comments are closed.

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:

Subscribe

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.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: