Can you please help me???

[Lynelle]

I am trying to create a multiplication chart. I am trying
to "fill right" my formula to make it easy, HOWEVER, the
formula changes. So, it goes A1, then B1, then C1 etc. I
know there is a way to make it so that the number always
stays A1 but I can't remember it and it's frustrating me
like crazy. Can you help me??? Thanks!!!

 

[Dan E]

Lynelle,

You can use absolute and relative references

ie
= 2*A1 will change both A and 1 as you drag it
= 2*$A1 will only allow the 1 to change and A will
stay as A
= 2*A$1 will only allow the A to change and 1 will
stay as 1
= 2*$A$1 will not allow either the A or the 1 to
change, it will always stay as $A$1

For more info search "About cell and range references"
in excel help it has a section "More information about
relative and absolute references." that you might find
helpful.

Dan E

 

[Jon Peltier]

Lynelle -

Use dollar signs in the cell references. If you use A1, it will fill
right as B1, C1, etc, and it will fill down as A2, A3, etc. Refer to
this handy table:

Ref Fill Right Fill Down
A1 B1, C1, D1 A2, A3, A4
A$1 B$1, C$1, D$1 A$1, A$1, A$1
$A1 $A1, $A1, $A1 $A2, $A3, $A4
$A$1 $A$1, $A$1, $A$1 $A$1, $A$1, $A$1

So the dollar sign locks the column or row designator that it precedes.

- Jon