how paste real forumula, not "relative"

  • Thread starter Thread starter Cirene
  • Start date Start date
C

Cirene

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.
 
Back
Top