View Single Post
  #1   Report Post  
Old May 5th 10, 04:13 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

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?