| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 column multiplied by 1 row throughout sheet
I want to copy a formula from 1 cell or a group of cells in which the column
and row values will not change. Ex: Cell D6 = C6*D5 Cell H11 = C11*H5 Cell J15 = C15*J5 I want to be able to copy this formula into several cells without the C or the 5 changing. How can this be achieved? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
1 column multiplied by 1 row throughout sheet
Use a dollar sign ($) to maintain the column or row or both when copying a
formula. =$C6*D$5 HTH, Paul -- "Rob Maeurer" <Rob wrote in message ... I want to copy a formula from 1 cell or a group of cells in which the column and row values will not change. Ex: Cell D6 = C6*D5 Cell H11 = C11*H5 Cell J15 = C15*J5 I want to be able to copy this formula into several cells without the C or the 5 changing. How can this be achieved? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
1 column multiplied by 1 row throughout sheet
hi
use absolute reference instead of relative reference relative reference.... =C6*D5 asolute reference.... =$C$6*$D$5 regards FSt1 "Rob Maeurer" wrote: I want to copy a formula from 1 cell or a group of cells in which the column and row values will not change. Ex: Cell D6 C6*D5 Cell H11 = C11*H5 Cell J15 = C15*J5 I want to be able to copy this formula into several cells without the C or the 5 changing. How can this be achieved? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I input a number it is being multiplied 10,000 | Excel Discussion (Misc queries) | |||
| Column multiplied by single cell | Excel Worksheet Functions | |||
| pounds multiplied by hours | Excel Worksheet Functions | |||
| same cell multiplied by set value | Excel Discussion (Misc queries) | |||
| Multiplied Values | Excel Discussion (Misc queries) | |||
Linear Mode
