Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
turn off auto fill options box Excel 2003 | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) |