excel training courses - Absolute referencing

Resolved · Low Priority · Version Standard

Wed 29 Nov 2006, 16:39 Delegate Kate said...

Kate has attended:
Excel Introduction course

Absolute referencing

Is it safest to always put in the dollar signs before every column and row reference or can that sometimes goes wrong?

Wed 29 Nov 2006, 22:14 Trainer Amanda said...

RE: Absolute referencing

Hi Kate

Thanks for your question.

You do not need to make every cell in a formula into an absolute reference (the name for a cell that has $ before the column letter and row number), you only need to do this when you need a specific cell in your formula to remain constant/the same in order to get the correct formula result.

Most of the time leaving your formula how it is without making an cells into an absolute reference works fine.

Amanda

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips