Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Probably simple, but I can't find answer. I want to copy a formula from 1
cell to a lot of other cells. When you do this, any cell addresses in the formula change based on where you copied the formula to. How can I make 1 of the cell addresses in the formula stay the same no matter where I copy it? It would be a "constant" in my formula and only changed from a "data entry sheet". Thanks, Tom Example: In A1 I might have: =(C1*D1)+742 If I move this to A2, it will become: +(C2*D2)+742 I want D1 to remain the same. ?????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
copying formulas to another cell | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Excel: hold a reference to a single cell when copying formulas? | Excel Worksheet Functions |