| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
How to do the exact copy of a formula
Michal wrote:
Let's say that I have a formula in A1 cell and it refers to A2. I want to copy it to B1 but I still want it to refer to A2. So I want to create exact copy of a formula, so it does not change its refernce cells. Hi Michal, Add the $ sign before what shouldn't change ! Copying A1 to B1 with ... will give ... A2 - B2 $A2 - $A2 A$2 - B$2 $A$2 - $A$2 Regards FxM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Mass Copy??? | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
| Formula copy | Excel Worksheet Functions | |||
Threaded Mode
