| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
range of Formula copy but not changing the content
I would like to ask if any way I can copy formula from range to another range
but the formula will still remain unchange as the source content. (i.e. EXCEL will not change the related cell automatically) i.e. copy formula from "C1" to "D1" but formula in D1 should same as C1 (C1 will NOT change its formula to sum(a2:b2) 12 12 24 =SUM(A1:B1) 342 342 523 523 Tx a lot for your kind assistance. -- aw |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy range without changing formulas? | Excel Discussion (Misc queries) | |||
| Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
| Copy the formatting and content of a range | Excel Discussion (Misc queries) | |||
| Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
| How do you copy RANK w/o it changing the range? | Excel Worksheet Functions | |||
Threaded Mode
