Filling Formulas Horizontally
 

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!

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!

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!

Filling Formulas Horizontally
 

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

"Bob Umlas" wrote:

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!

Filling Formulas Horizontally
 

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

"xtrailer" wrote in message
...
That did the trick, thanks! What is the function of the $ symbol?

"Bob Umlas" wrote:

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!