Greetings.
I need a help on how to add security password to one of my Excel files? I am using Microsoft Office Excel 2007 and I have this important and confidential file and I want to add extra security by entering a password before it can be opened.
I already explored the menus in Excel but I can't find the option for putting a password to my file.
Your help will be highly appreciated.
Thank you.
Answered By
Mr. John
0 points
N/A
#127795
How to add password on my Excel file?
Dear,
Thanks for asking Techyv about your problem. Please follow the procedure below. I am also giving a screen shot for your better understanding.
-
Open your Excel file.
-
Click on the top left corner Office Button, then Click Save As. Save as window will open.
-
Click Tools from the Left side bottom and now click General Options. Now password option will come.
-
Put a password to open and password to modify then click OK and save the file.
Please do this procedure to protect your file and keep it safe.
Please note, don’t forget this password. If you forget, then there's no way to open this file again.
Cheers!
How to add password on my Excel file?
Hi Marvin,
There are a number of ways of setting a password for your Excel file so that no one else can access the contents of the file. The easiest way of doing this would be to click on "save as", and on the save as window, click on tools, and then on General Options.
This is what you would be looking at:
Under Password to Open, you can set that a password will be asked when the file is accessed. In the Password to Modify, you can set that a password will be asked when changes are to be done to the document.
Hope this helps you answer your question.
Answered By
Franksat
0 points
N/A
#127797
How to add password on my Excel file?
To add a password to your Excel sheet, you have to:
-
Open your Excel sheet in Office.
-
Click on Save As. A window will open.
-
Now click on the tools button and then select the General option.
-
Now this is the field where you add a password to your Excel sheet.
-
Now enter your password for the sheet and confirm it.
-
Click next. The password is added to your sheet.
Answered By
ellenV
0 points
N/A
#127798
How to add password on my Excel file?
I also need to put a password in my excel file to make it private. I'm thankful to this thread! Mr. John, thank you very much for the solution.