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

cell protection

ResolvedVersion 2007

James has attended:
Excel Intermediate course
Excel Advanced course

Cell protection

if you forget the password after you've protected a worksheet is there any way to alter the data. If not do you have any suggestions of keeping password names with workbooks better 9e.g. if there a template already stored to retain this info easily

RE: Cell protection

Hi James

Thanks for the post

Now if you forget your password after you have protected your sheet, you dont really have many options, apart from contacting IT to try and find out the password for you

They should be able to do it for you.

As for keeping passwords i keep them in a little book that i always carry round with me but dont tell other work people about - but sorry James that all i can suggest


If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

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