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

worksheet protection

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Worksheet protection

Worksheet protection

ResolvedVersion 2003

Dee has attended:
Excel Advanced course
Excel Intermediate course

Worksheet protection

We have an important worksheet that is currently protected and we'd like to change the password because its so easily mis-typed. Is there a way to change the passwords once they are in place?

Cheers for the help!

Dee

RE: Worksheet protection

Hi Dee, thanks for your query. This is simply a matter of opening the Protect Sheet dialog box and overtyping with the new password. That should reset it to what you want.

Hope this helps,

Anthony

RE: Worksheet protection

Thanks!

All the resolutions this week have helped a lot!

Dee

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

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.09 secs.