Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

protection

ResolvedVersion 2007

Tom has attended:
Excel Intermediate course

Protection

How do I password protect a range of cells, rather than a whole sheet

RE: Protection

Hi Tom

Thank you for your question and welcome to the forum.

Good question! I'm not sure how you would do this or if it's possible - I will research this a bit further to see if I can come up with a definite answer for you.

Kind regards
Amanda

RE: Protection

I think you can only set the password for the whole sheet, but you can select which cells to lock.

This link gives info for version 2007, but I imagine it's similar for version 2003.

http://office.microsoft.com/en-us/help/HP100785801033.aspx

There are other links with more info on that page.

Rich

Thu 26 Mar 2009: Automatically marked as resolved.

Excel tip:

3D formulas find and replace

After you know all the components of a 3D reference, you can change them to suit by using a localised Find and replace crt+f, if need be.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.17 secs.