excel training - Password

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

Resolved · Low Priority · Version Standard

Password

Dana has attended:
Excel Intermediate course

by - delegate Dana [1 post] (2007 Mar 2 Fri, 15:29) Reply

can i put a password on my workbook??

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: password

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 2 Fri, 15:36) Reply

Yes you can do that by going into the Tools menu> Protection>Protect Workbook, you can enter and password and it will ask you to repeat the password and its done. It will flag up a password protection message if you try to open it.

Tracy

RE: password

by - trainer Pete platinum contributer [799 posts] (2007 Mar 3 Sat, 12:25) Reply

Hi Dana,
Agree with everything that Tracy has posted, another method; If you choose "Save As" when saving the workbook, in the Save As dialog box, choose the Tools menu, Choose 'General Options' and apply a password which will prevent the opening of the Spreadsheet to anyone without the password you append.

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Database Tips from an Excel Training Course
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Tips to Facilitate Printing of Excel worksheets
· Tap the Power of Recorded Macros with MS Excel 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