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?