Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
1vagrowr
 
Posts: n/a
Default 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?
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default 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?



  #3   Report Post  
George Gee
 
Posts: n/a
Default 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?



  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
turn off auto fill options box Excel 2003 martock Excel Discussion (Misc queries) 2 October 13th 05 02:23 AM
Auto Fill Options adarling Excel Discussion (Misc queries) 1 April 8th 05 03:09 AM
Auto fill option box disappeared sbrimley Excel Worksheet Functions 5 February 4th 05 04:21 AM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 05:45 AM
Auto Fill Options Patti B Excel Discussion (Misc queries) 3 December 9th 04 01:49 AM


All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"