| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste Formula-dropping 1st cell address
Formula is =Sum(D3:D8)/Sum(C3:C8)
Steps: Copy Formula Paste to cell below Problem: Formula drops the cell address "C3" and "D3" but properly added the cell address "C9"and "D9", i.e., when pasted formula looks like this; =Sum(D4:D9)/Sum(D4:D9) I've looked under the Excel Options but can not see anything that is causing this to happen. Thanks -- kesitton |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste a formula in a locked cell | Excel Discussion (Misc queries) | |||
| Need code to copy and paste based on cell address. | Excel Discussion (Misc queries) | |||
| Copy/Paste Hyperlink Address | Excel Discussion (Misc queries) | |||
| How can I copy/paste a hyperlink address without the link? | Excel Discussion (Misc queries) | |||
| Repeat Cell Formula w/out copy/paste? | Excel Discussion (Misc queries) | |||
Threaded Mode
