ExcelBanter - How do I stop the autopaste function in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I stop the autopaste function in Excel? (https://www.excelbanter.com/excel-worksheet-functions/5462-how-do-i-stop-autopaste-function-excel.html)

Jules

How do I stop the autopaste function in Excel?

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?

Frank Kabel

Hi
=SUM($A$1:$B$1)

--
Regards
Frank Kabel
Frankfurt, Germany

Jules wrote:
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?

All times are GMT +1. The time now is 09:52 AM.