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.)

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.

--
Biff
Microsoft Excel MVP


"Cirene" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.)
>