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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
Back
Top