View Single Post
  #2  
Old April 22nd, 2010, 11:40 PM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
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?