Setting a Password to Open an Excel Workbook

One of the students in my Intermediate Excel class this week asked me how to set an Excel workbook so a password is required to open or modify it. This is fairly easy.

When you have finished creating your Excel workbook, click on the Office Button in the upper left hand corner, then click on Save As. On the Save As dialog box, click on the Tools button on the bottom left side of the screen. Then click on General Options.

On the General Options box, you can set a password to open or modify the workbook. It is critical that you remember your password. If you forget your password, Microsoft cannot retrieve it. You can also set a recommendation that the file be opened as Read Only.

Computer Basics: Saving Passwords and Usernames in a Web Browser

At the Troy Public Library's Technology Center, we teach several classes that cover basic computer skills. However, in these classes we can't cover everything. Using our blog, I hope to cover some of those topics about which we receive many questions, but can't always address in classes.

One common question that we are asked is: How can my web browser remember my password information so that I don't have to type it in all the time? Follow the steps below to have Firefox 3 or Internet Explorer 7 remember this data to make life a little easier!

For Firefox 3:

1. Click on Tools, then click Options.

2. Click on the Privacy tab.

3. Make sure that there is a check next to "Remember what I enter in forms and the search bar." Also make sure there is no check next to "Always clear my private data." If this is checked, all saved data (information in forms, passwords) will be erased every time you close Firefox!

For Internet Explorer 7:

1. Click on Tools, then click Internet Options.

2. Click on the Content tab, then click on the Settings box under AutoComplete.

3. Make sure "Forms" and "User names and passwords on forms" is checked.