Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+course - Excel 2007

	98.1 % recommend us
	More live stats...

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

Training information:

microsoft+excel+course - Excel 2007

Resolved · Low Priority · Version Standard

Reply Fri 7 Dec 2007, 10:58Delegate Gemma said...

Gemma has attended:
Excel Introduction course
Powerpoint Introduction course

Excel 2007

How do you password protect a spreadsheet?

For upcoming training course dates see: Pricing & availability

Reply Fri 7 Dec 2007, 13:05Trainer Pete said...

RE: Excel 2007

Hi Gemma, Thanks for the post, in answer to your question, to protect the worksheet you would choose the menu option Tools, Protection and then from the pop out choose Protect Worksheet, the application of a password is optional, you will have to enter it twice, the second time for confirmation. To protect the Workbook you would choose Menu option, File Save As and in the dialog box choose the Menu Option Tools, within the the pop out, choose General Options, insert your chosen password twice, remember if you lose the password you will not be able to gain access to the workbook. Hope that helps, best regards Pete.

Excel articles

· Say It With Ribbon
· Securing Critical Company Information With Simple Visual Basic Training Courses
· Using Find And Replace In Excel
· Creating Error Alerts In Excel Using Data Validation
· Training Budgets In A Bad Economy

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips