excel training courses - absolute referencing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Absolute referencing

excel training courses - Absolute referencing

resolvedResolved · Low Priority · Version Standard

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?

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


 

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


Server loaded in 0.1 secs.