Excel

The UK's most regular instructor-led training courses.
Training information: excel training · Excel/courses/london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Excel

Kerry has attended:
Excel Intermediate course

by - delegate Kerry [1 post] (2008 May 8 Thu, 17:54) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course				List price £495
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 May 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Jun 5 Thu + 6 Fri	Bayswater	6	book now	£450	£485
2003/XP	2008 Jun 12 Thu + 13 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Jun 19 Thu + 20 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Jul 3 Thu + 4 Fri	Southwark	6	book now	£450	£485
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	5	book now	£450	£485
Full Schedule: See all 65 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Pete platinum contributer [571 posts] (2008 May 8 Thu, 20:18) Reply

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.

· A Beginners Guide To Formulas In Excel
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Microsoft Excel Training Course
· Microsoft Excel Courses Teach Advanced Macro Techniques
· How to check for and reduce errors in Microsoft Excel

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

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Excel

Related articles

Excel tip:

Repeating headings on spreadsheets that print on more than one page