How do I stop the autopaste function in Excel?

J

Jules

How do I stop or prevent the autopaste function in Excel. For example, if
you want to copy of formula in cell C1 that says "SUM(A1:B1)", and you want
that exact copied formula to be in D1, I don't want D1 to say "SUM(B1:C1)".
Anyone know how to stop that?
 

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

VBA Coding Help for Beginner 0
Merging cells and formats 8
Conditional Formatting Formula 3
split range address into individual cell addresses 9
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Excel - Wich Function should I use? 1
Nameing a function 1
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1

Top