how paste real forumula, not "relative"

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

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shortcut for copying formulas referencing different worksheets 1
Increment Forumula Series by 4 each row 8
CHAR(10) does not create new line in excel 2007 4
Any way to Paste without Relative reposition? 6
Excel 2007 Paste Special 3
Formula not copying over as before 1
To execute a formula upto in a cell 3
Keeping forumla cell reference after cut and pasting 3

Top