| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 -- Copying a formula to Paste Special into column cell
Trying to copy a cell to be able to paste that formula (=D10*D5) into
subsequent cells like this: Copy | Paste Special | Formula, however, what's happening is that it's copying the total from that cell and bringing it all the way down. I remember this problem from a few or more years back and, as I recall, it's a glitch between different versions of Excel, however, I can't recall the "fix." Am I in the right ballpark? Thanks for any help. Florence |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 -- Copying a formula to Paste Special into column cell
ToolsOptionsCalculation.
Make sure you are set to "Automatic" Easier method of copying formulas is to just click on the fill handle(black lump at right bottom corner of the cell) and drag down or across. Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 13:02:11 -0700, FlorencePS wrote: Trying to copy a cell to be able to paste that formula (=D10*D5) into subsequent cells like this: Copy | Paste Special | Formula, however, what's happening is that it's copying the total from that cell and bringing it all the way down. I remember this problem from a few or more years back and, as I recall, it's a glitch between different versions of Excel, however, I can't recall the "fix." Am I in the right ballpark? Thanks for any help. Florence |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 -- Copying a formula to Paste Special into column
Awesome, Gord! I KNEW it was something simple like that. My coworker thanks
you. "Gord Dibben" wrote: ToolsOptionsCalculation. Make sure you are set to "Automatic" Easier method of copying formulas is to just click on the fill handle(black lump at right bottom corner of the cell) and drag down or across. Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 13:02:11 -0700, FlorencePS wrote: Trying to copy a cell to be able to paste that formula (=D10*D5) into subsequent cells like this: Copy | Paste Special | Formula, however, what's happening is that it's copying the total from that cell and bringing it all the way down. I remember this problem from a few or more years back and, as I recall, it's a glitch between different versions of Excel, however, I can't recall the "fix." Am I in the right ballpark? Thanks for any help. Florence |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy--paste--special "formula" for a whole column | Excel Discussion (Misc queries) | |||
| preparing pivot fields for copying and paste special for sorting | Excel Discussion (Misc queries) | |||
| Special paste column widths is not coming up in Excel 2007? | Excel Discussion (Misc queries) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Excel 2003 - paste special option | Excel Worksheet Functions | |||
Linear Mode
