copy and paste question

H

hb2474

I want to copy and past this cell into another cell but want the exact
formula in it. What it does is that it moves the formula over by how
many cells you paste it too. I would really appreciate it.
 
C

Cutter

Put a dollar sign ($) in front of the column and row reference before
copying and pasting.
Example: = $A$1

This is called absolute referencing.
 
Top