View Single Post
  #4   Report Post  
Old May 5th 10, 04:31 PM posted to microsoft.public.excel.newusers
anickless anickless is offline
external usenet poster
First recorded activity by ExcelBanter: May 2010
Posts: 2
Default Copy and Pasting Formulas are incrementing

Thank you that solved the issue. I just never knew much about the formulas.
its been awhile

"RonaldoOneNil" wrote:

Your original formula needs to have an absolute reference to stop it changing
as you paste into another column

i.e. $A$1 instead of just A1

"anickless" wrote:

Hi i am trying to paste formulas from one column to another, however when I
do a paste - special - formulas it seems in increment the cell references
with the formulas

e.g the correct formula would be A1

but when I paste formulas it comes up as B1

what is going on here?