# Revision history [back]

However, normally standard cell references are best, as answered here and here. That is, simply use:

=OFFSET(A4,-1,5)


When this formula is filled down or copied, the A4 reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as $A$4 instead.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=OFFSET(A4,-1,5)
=F3


When this formula is filled down or copied, the A4 reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as $A$4 instead.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=F3


When this formula is filled down or copied, the A4 reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as $A$4$F$3 instead.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=F3


When this formula is filled down or copied, the reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as $F$3=$F$3 instead.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=F3


Or perhaps you want this in cell A4:

=OFFSET(A4,-1,5)


When this formula is filled down or copied, the reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as =$F$3 instead.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=F3


Or perhaps you want this in cell A4:

=OFFSET(A4,-1,5)


When this formula is either of these formulas are filled down or copied, the reference references will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as =$F$3 instead.