View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Filling Formulas Horizontally

hi
not sure but in your example you have an absolute reference on the column ie
$C.
this is telling excel to always leave the column reference at C.
remove the absolute reference and the formula should drag and fill across.

Regards
FSt1

"xtrailer" wrote:

I am buidling a speadsheet in which one worksheet access info from another. I
want to fill out an "access" formula horizontally in one of the worksheets.

The fomula is: 'Access Info'!$C3 which I want to fill out to D3, E3, F3 etc
horizontally. I tried the fill handle, but it just copies the same formula
(and formatting) over. Help!