View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
grumpydope grumpydope is offline
external usenet poster
 
Posts: 2
Default Excel 2007 copy cells without cell reference being adjusted

How can I copy a row of cells to a different row without the cell references
in those cells being adjusted? If I have a reference in cell A1 (=B15) and I
copy the cell to B1 then the reference is adjusted (=B16). Any help?