How do you enter an absolute reference in Excel?

Answer 1

This isn't an actual answer, just clarification.

An example for this question would be a semi-absolute coordinate whose absolute portion is a number generated by an equation made up of other cell references.

a.k.a: f(x)=D$($C$1-$A$3) where the part in parantheses is equivelent the row number desired. such as C1 being 65 and A3 being 33, and in turn referencing D32

Answer 2

Use the dollar sign ($), like this: $A$1. You can also press the F4 key to change between the different reference types when you are typing in a cell reference.