shortcut for copying a formula with relative references

[Shawn]

Does anyone know a shortcut for copying a formula with
relative references as a formula with absolute references
without having to put in all those little $'s?
Spreadsheet programs much less powerful than Excel have
this capability....
Thanks! Shawn

 

[Peo Sjoblom]

F2, Shift + Home, F4, Ctrl + C, Esc, F5, Ctrl + V

 

[Debra Dalgleish]

If you want another cell to contain exactly the same formula:

1. Copy the formula in the formula bar, and press Enter
2. Select the destination cell
3. Click in the formula bar, and paste

 

[Guest]

Thanks again!
Shawn

-----Original Message-----
F2, Shift + Home, F4, Ctrl + C, Esc, F5, Ctrl + V

--

Regards,

Peo Sjoblom




.

 

[RagDyer]

You can copy formulas exactly (not changing cell references), by selecting
the formula in the formula bar, right click and choose "Copy", then just
right click in new cell, and choose "Paste".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Does anyone know a shortcut for copying a formula with
relative references as a formula with absolute references
without having to put in all those little $'s?
Spreadsheet programs much less powerful than Excel have
this capability....
Thanks! Shawn