Protection

Resolved · Low Priority · Version 2007

Thu 5 Nov 2009, 16:34 Delegate Efua said...

Efua has attended:
Excel Intermediate course

Protection

How do I protect a worksheet

Fri 6 Nov 2009, 09:50 Trainer Amanda said...

RE: Protection

Hello Efua

Thank you for your question and welcome to the forum.

To apply protection to a worksheet, go to the Review tab, and click the Protect Sheet button.

Create a password (if you wish), and tick any actions that you want people to be able to perform even when protection is applied.

If you have entered a password, you will be prompted to enter it again.

Click OK to apply protection.

Kind regards
Amanda

Training courses

	98.8 % recommend us
	More live stats...

Training information:

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