| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can't copy/paste the formula
I want to copy this formula down through the whole column. I tried
copy/paste special/forumla from row 4 to row 5 of the column I'm on. It copies the formula without changing the relative row down one and leaves all the rows on 4. I can copy/paste special/formula then I drag down the + sign on the right of the box I copied it to to change the whole column. This isn't working on this formula and I don't know why? tia, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can't copy/paste the formula
post your formula, we will be better able to offer an answer.
"Janis" wrote: I want to copy this formula down through the whole column. I tried copy/paste special/forumla from row 4 to row 5 of the column I'm on. It copies the formula without changing the relative row down one and leaves all the rows on 4. I can copy/paste special/formula then I drag down the + sign on the right of the box I copied it to to change the whole column. This isn't working on this formula and I don't know why? tia, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can't copy/paste the formula
Are the references absolute or relative?
Do you have calculation set to automatic? Gord Dibben MS Excel MVP On Tue, 14 Aug 2007 11:06:00 -0700, Janis wrote: I want to copy this formula down through the whole column. I tried copy/paste special/forumla from row 4 to row 5 of the column I'm on. It copies the formula without changing the relative row down one and leaves all the rows on 4. I can copy/paste special/formula then I drag down the + sign on the right of the box I copied it to to change the whole column. This isn't working on this formula and I don't know why? tia, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy / Paste Formula | Excel Discussion (Misc queries) | |||
| copy and paste formula | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| formula for copy and paste | New Users to Excel | |||
| why cant I copy and paste a formula? | Excel Discussion (Misc queries) | |||
Linear Mode
