Excel 2007

Resolved · Low Priority · Version 2007

Thu 5 Mar 2009, 15:19 Delegate David said...

David has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course

Excel 2007

How do I lock my excel spreadsheet so that it cannot be opened at all without a password?

Thu 5 Mar 2009, 15:46 Trainer Cress said...

RE: Excel 2007

Hello David
Thank you for your question

Open the excel spreadsheet and go to File, Save As. At the top right select Tools, Options and a box should appear to let you enter a password to open and a password to modify. Enter and save.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Thu 12 Mar 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips