| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy formula with one cell constant
How can I copy the formula so that B2 stays constant and only the row changes?
A B C 1 2 2 10 =A2*B1 3 20 =A3*B1 4 30 =A4*B1 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a formula to a cell containing a constant value | Excel Discussion (Misc queries) | |||
| Formula won't display as cell set to Constant | Excel Discussion (Misc queries) | |||
| Excel: Format Control: 'cell link' reamins constant. How to copy | Excel Worksheet Functions | |||
| How do I copy a function with a called cell constant? | Excel Worksheet Functions | |||
| Copy a formula maintaining a constant cell | Excel Worksheet Functions | |||
Threaded Mode
