How to add password on my Excel file?

Asked By Marvin Cadayong 0 points N/A Posted on - 09/22/2011

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.

• Status: Open
• Question Views: 2088
• Answer Count: 4
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Mr. John

Go To Solution

Best Answer

Best Answer

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!

About Mr. John

Questions
0

Answers
6

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 09/22/2011
• Question Category: MS Excel

Answered By Ace Baker 5 points N/A #127796

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.

About Ace Baker

Questions
0

Answers
12

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 09/22/2011
• Question Category: MS Excel

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.

About Franksat

Questions
0

Answers
10

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 09/22/2011
• Question Category: MS Excel

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.

About ellenV

Questions
8

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/18/2012
• Question Category: MS Excel