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

password

ResolvedVersion 2010

Stacey has attended:
PowerPoint Introduction course
Excel Intermediate course
Excel Intermediate course

Password

How do I take off a password for an Excel document? Have tried 'unprotecting' but does not seem to remove it. The password comes on every time I open the document.
Thanks

RE: Password

Hello Stacey,

Thank you for your question. Assuming you have the password, open the document, then enter the password. Now click File - Save As. Next to the Save button (bottom right), there is a Tools button. Click this, then select General Options. Delete the password (shown by dots) in the Password to Open field. Afterwards, click Save. Click Yes when asked if you want to replace existing file. When you close and reopen the document, it should be unprotected.

I hope this helps.

Kind regards
Marius Barnard
Excel Trainer

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

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.