Pasting a Formula into a new column or worksheet, but so that itdoesn't change

[Dave K]

Hello - When I copy and paste a formula into a new column, Excel
assumes that I wanted to use references to different columns.

That is, each time that I want to copy and paste a formula into a new
column, or sheet, I have to either first make it an absolute
reference---or I have to paste it into Word, and then paste it into
Excel to keep it as the same formula.

Does anyone know if there is an easier way to paste a formula so that
the reference doesn't change, and the formula thus stays the same?

Thanks!!

 

[RagDyer]

One way is to copy it *from the formula bar*!

Click in the cell containing the formula.
Select the *entire* formula in the *formula bar*.
Right click in that selection and choose "Copy".
NOW ... hit <Enter>.

Navigate to the new location.
Right click in the new cell and choose "Paste".

And you're done!

 

[Dave K]

One way is to copy it *from the formula bar*!

Click in the cell containing the formula.
Select the *entire* formula in the *formula bar*.
Right click in that selection and choose "Copy".
NOW ... hit <Enter>.

Navigate to the new location.
Right click in the new cell and choose "Paste".

And you're done!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !








- Show quoted text -

Thanks!

 

[Pete_UK]

Another way is to put an apostrophe in front of the equals sign in the
first formula. This turns it to text, so it can be copied anywhere
without change. Then just remove the apostrophe from both cells.

Hope this helps.

Pete

 

[RagDyer]

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

One way is to copy it *from the formula bar*!

Click in the cell containing the formula.
Select the *entire* formula in the *formula bar*.
Right click in that selection and choose "Copy".
NOW ... hit <Enter>.

Navigate to the new location.
Right click in the new cell and choose "Paste".

And you're done!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------"Dave








- Show quoted text -

Thanks!

 

[Tyro]

You can also copy the formula from the cell. Just select the cell with the
formula, press F2 to enter edit mode, press Ctrl+Shift+Home to select the
formula, press Ctrl+C to copy the formula, then press Escape. Select the
cell where you want the formula, press Ctrl+V to paste the formula.

Tyro