View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas[_2_] Bob Umlas[_2_] is offline
external usenet poster
 
Posts: 68
Default Filling Formulas Horizontally

Take out the "$" in your formula.

Bob Umlas
Excel MVP

"xtrailer" wrote in message
...
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!