Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Low Priority · Version 2003

Reply Thu 8 May 2008, 17:54Delegate Kerry said...

Kerry has attended:
Excel Intermediate course

Excel

How do I password protect a whole document (eg have to enter a password to open it)

For upcoming training course dates see: Pricing & availability

Reply Thu 8 May 2008, 20:18Trainer Pete said...

RE: Excel

Hi Kerry,
Thanks for your post, welcome to the forum, in answer to your question there are two ways to set a Workbook password;
1. Go to Menu command File>Save As and in the Save In dialog box, click the Tools tab, from the menu choose General Options and then insert your chosen password, Confirm the password, Click Ok, Name and Save your Workbook. When you next open you will be prompted for a password.
2. Whilst in the Workbook, select the Menu command Tools>Options and in the Security Tab enter Password and Confirmation. As above you will be prompted before you can open the workbook.
Remember not to lose the password, if you do you will not be able to open the Workbook (Ever). I hope that has been of use to you, if so please click the resolved link, regards Pete.

Excel articles

· How To Create A Simple Currency Convertor In Excel 2010
· What's mine is yours: Sharing data in Excel
· So what's new in Excel 2007?
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Summing Up Scenarios With Excel

Please browse our web site to find out more about
excel training and other Microsoft training courses.

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips