| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula without changing all values
I would like to copy a formula to several cells=(B197-$B198)/$B198 . I want the B198 to stay the same and the B197 to change as the formula is moved. I thought the $(dollar sign) would make the B198 stay, but it is changing as I copy. How do I make the B198 stay the same.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Of Values After A Copy And Paste Special: Why ? | Excel Discussion (Misc queries) | |||
| copy formula without changing the row. | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Changing Formula elements to values | Excel Worksheet Functions | |||
| need to copy/paste formula w/o it changing | Excel Discussion (Misc queries) | |||
Threaded Mode
