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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave K - 04 Feb 2008 22:56 GMT

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!!

Reply to this Message

RagDyer - 04 Feb 2008 23:35 GMT

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!

Signature

HTH,

RD

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

> Hello - When I copy and paste a formula into a new column, Excel
> assumes that I wanted to use references to different columns.
[quoted text clipped - 8 lines]
>
> Thanks!!

Reply to this Message

Dave K - 05 Feb 2008 01:09 GMT

> One way is to copy it *from the formula bar*!
>
[quoted text clipped - 29 lines]
>
> - Show quoted text -

Thanks!

Reply to this Message

Pete_UK - 05 Feb 2008 01:36 GMT

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

> > One way is to copy it *from the formula bar*!
>
[quoted text clipped - 36 lines]
>
> - Show quoted text -

Reply to this Message

RagDyer - 05 Feb 2008 02:05 GMT

Appreciate the feed-back.

Signature

Regards,

RD

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

On Feb 4, 5:35 pm, "RagDyer" <ragd...@cutoutmsn.com> wrote:

> One way is to copy it *from the formula bar*!
>
[quoted text clipped - 33 lines]
>
> - Show quoted text -

Thanks!

Reply to this Message

Tyro - 05 Feb 2008 04:35 GMT

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

> Hello - When I copy and paste a formula into a new column, Excel
> assumes that I wanted to use references to different columns.
[quoted text clipped - 8 lines]
>
> Thanks!!

Reply to this Message