"Constants" in a spreadsheet

[j4nd3r53n]

Sometimes I need to divide/multiply a column of numbers with the same value, which in turn is calculated from numbers in other cells. It would be handy if I could first calculate that value somewhere in the sheet, and then reference it in a column - however, if I just reference the calculated cell in the first cell of the column of my calculations, then copy the it to the next cells, the reference "moves", as designed - see the attached, simple example.

Is there a way to avoid that? I think it must be something that many would find useful.

[RoryOF]

You might find [Tutorial] Absolute, relative and mixed references a useful resource.

[FJCC]

In this specific case, make the formula in B4

Code: Select all

=A4*$G$2

and then copy it down.