| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Focing a cell to be used
Is it possible to keep a cell used when you drag an equation to multiple cells?
1200*a1^(b1) 1200*a2^(b1) .. .. .. 1200*an^(b1) the way it stand now, draging the equation leads to both cells roaming. I want to fix one cell. The question is how. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Focing a cell to be used
Use an absolute reference. Where you now have b1, use $b$1.
(There are also mixed references. $b1 would keep the column fixed as you copy across; b$1 would keep the row fixed as you copy down). "NAUBryan" wrote: Is it possible to keep a cell used when you drag an equation to multiple cells? 1200*a1^(b1) 1200*a2^(b1) . . . 1200*an^(b1) the way it stand now, draging the equation leads to both cells roaming. I want to fix one cell. The question is how. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
