how paste real forumula, not "relative"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cirene - 07 Dec 2007 03:22 GMT

When i copy a formula from one cell to another Excel adjusts any relative
cell references in whatever you are copying. How do i get it to paste the
EXACT forumula without adjusting it?

(I know I can copy/paste the actual text of the forumula but I'm sure
there's another less manual way to do it.)

Reply to this Message

T. Valko - 07 Dec 2007 04:13 GMT

Make the references absolute:

=SUM(A1:A10)
=SUM($A$1:$A$10)

Another option:

Copy the formula from the formula bar. Hit escape, then paste it wherever
you want it.

Signature

Biff
Microsoft Excel MVP

> When i copy a formula from one cell to another Excel adjusts any relative
> cell references in whatever you are copying. How do i get it to paste the
> EXACT forumula without adjusting it?
>
> (I know I can copy/paste the actual text of the forumula but I'm sure
> there's another less manual way to do it.)

Reply to this Message

Rate this thread: