Copying cell contents (formula) as is

  • Thread starter Thread starter GBL
  • Start date Start date
G

GBL

Hi:
Probably having a senior moment!! Being new to Excel doesn't help,
either!!
Is there a simple way to copy a working formula to another cell without
"stepping" the cell-references? I want to copy the original formula of a
cell to a second cell and have the second cell contain an exact duplicate of
the first cell.
Thanks in Advance
 
You either need to use absolute addressing. i.e., instead of

=A1 + 2

use

=$A$1 + 2

OR

copy the formula (say, from the formula bar), double click in the
cell to enter Edit mode, and paste the formula.
 
edit the cell you want to copy and press F4 to put
$(creates an absolute reference) in front of the cell
reference. i.e., in cell b2, it says =+B3, press F2 to
edit, then press F4 to change it to =+$B$3, you can press
F4 to toggle and change whether the row or cells gets the
absolute reference.
 
Back
Top