| 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? |
| 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) | |||
Threaded Mode
