Filling Formulas Horizontally

[xtrailer]

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!

 

[Bob Umlas]

Take out the "$" in your formula.

Bob Umlas
Excel MVP

 

[FSt1]

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]

That did the trick, thanks! What is the function of the $ symbol?

 

[Bob Umlas]

The "$" "freezes" that part of the reference when filling or copy/pasting.
If D4 contains =$C4 and you copy it and paste it to cell Z12, you'd see
=$C12 -- the column remains "frozen". If D4 contains =C$4 and you copy it to
Z12, you'd see =Y$4. If D4 contains =$C$4 and you copy it to Z12 you'd see
=$C$4, and if D4 contains =C4, if you copy it to Z12 you'll see =Y12.
HTH