Formatting functions

Resolved · Low Priority · Version 2010

Thu 26 Oct 2017, 16:44 Delegate Giuseppe said...

Giuseppe has attended:
Excel Intermediate course

Formatting functions

How to lock cells?

Fri 27 Oct 2017, 11:31 Trainer Sarah said...

RE: Formatting functions

Hi Giuseppe

Lock cell references in formulas by making it absolute (add in dollar signs):

Relative cell reference = A1
Absolute cell reference = $A$1

You can do this manually, or use the shortcut F4.

Hope this answers your question!

Regards,

Sarah
Excel Trainer

Fri 3 Nov 2017: Automatically marked as resolved.

Training courses

	98.7 % 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