stop auto fill from thinking for itself!!!!!!!
 

I have Office 2003. I figure an example will make things easier. I want B5
to =A5*A1, B6 to =A6*A1, B7 to =A7*A1, and so on. When I try to auto fill I
can't keep the formula refering to cell A1. It automatically goes to A2 then
A3, etc. How can I use the auto fill function to fill in a range of cells
which all refer back to one common cell?

stop auto fill from thinking for itself!!!!!!!
 

Use $A$1 instead of A1. This creates an "absolute reference".
If you wanted just the column to stay at A, you would use $A1. If you wanted
just the row to stay at 1, you would use A$1. For your purposes: =A5*$A$1
can be copied down to produce A6*$A$1, etc.
************
Anne Troy
www.OfficeArticles.com

"1vagrowr" wrote in message
...
I have Office 2003. I figure an example will make things easier. I want
B5
to =A5*A1, B6 to =A6*A1, B7 to =A7*A1, and so on. When I try to auto fill
I
can't keep the formula refering to cell A1. It automatically goes to A2
then
A3, etc. How can I use the auto fill function to fill in a range of cells
which all refer back to one common cell?

stop auto fill from thinking for itself!!!!!!!
 

1vagrowr

In B5 =A5*$A$1
and fill down.


George Gee



1vagrowr wrote:
I have Office 2003. I figure an example will make things easier. I
want B5 to =A5*A1, B6 to =A6*A1, B7 to =A7*A1, and so on. When I try
to auto fill I can't keep the formula refering to cell A1. It
automatically goes to A2 then A3, etc. How can I use the auto fill
function to fill in a range of cells which all refer back to one
common cell?

stop auto fill from thinking for itself!!!!!!!
 

try:

=a5*$a$1

The $a signs mean not to adjust that column and the $1 means not to adjust that
row.

So $a$1 means don't change anything.

You may want to look at help for "About cell and range references", then "The
difference between relative and absolute references".

Chip Pearson has some nice notes, too:
http://www.cpearson.com/excel/relative.htm



1vagrowr wrote:

I have Office 2003. I figure an example will make things easier. I want B5
to =A5*A1, B6 to =A6*A1, B7 to =A7*A1, and so on. When I try to auto fill I
can't keep the formula refering to cell A1. It automatically goes to A2 then
A3, etc. How can I use the auto fill function to fill in a range of cells
which all refer back to one common cell?

--

Dave Peterson