| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas from cell to cell to cell to.......
Thanks Miguel; works perfect!
Miguel Zapico wrote: Use the $ sign to fix the cell and/or the row. Something like: =(C1*$D$1)+742 If you press F4 when you are entering the cell address, the dollar signs will appear, you can keep pressing it to see all the options. Hope this helps, Miguel. 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 [quoted text clipped - 9 lines] I want D1 to remain the same. ?????? -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
