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 training

	98.1 % recommend us
	More live stats...

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

Training information:

Excel training

Resolved · Low Priority · Version 2003

Reply Wed 27 May 2009, 16:32Delegate Jean said...

Jean has attended:
Excel Intermediate course

Excel training

How do you password protect a work sheet?

For upcoming training course dates see: Pricing & availability

Reply Thu 28 May 2009, 09:34Trainer Carlos said...

RE: Excel training

Hi Jean

To protect the contents of an Excel worksheet you do the following:

1. In the Tools menu, Select Protect
2. Click Protect Sheet

A dialog box appears allowing you to enter a password (although this is optional)

3. Enter the password and click OK

4. A new dialog box will ask you to Confirm the password.
5. Re-enter the password and clickOK.

NB. This will protect the contents of that entire worksheet. This is because Excel protects worksheet cells that are "Locked"- and all Excel worksheet cells come locked as a default.

Hope this helps

Carlos

Wed 3 Jun 2009: Automatically marked as resolved.

Excel articles

· Database Tips from an Excel Training Course
· Compare Different MS Excel Training Methods
· How to Create Better Excel Spreadsheets: Part Four
· Correct In, Garbage Out
· Microsoft Excel provides the building blocks of shared information

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

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips