View Single Post
  #3   Report Post  
Old May 5th 10, 04:26 PM posted to microsoft.public.excel.newusers
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 117
Default Copy and Pasting Formulas are incrementing

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?