View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Copying Cells with Fill Handle

If you want "the number" to advance as you copy across, then don't put a $
in front of it, as in:
=$A1*2

Regards,
Fred

"RRG" wrote in message
...
Can anyone help? I am trying to copy cells across a row using the fill
handle
that are referencing another sheet down a column. I am placing a "$" in
front
of the letter as to not change it, but since I am copying across, the
number
will not change. Is there any way to tell Excel that i want the number to
advance as I copy across?