Copying cell contents (formula) as is

[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

 

[J.E. McGimpsey]

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.

 

[Monica]

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.