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?