| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy--paste--special "formula" for a whole column
hOW DO YOU copy a formula from one cell to the rest of the cells in the
column? I don't want the contents just the formula. I want to auto-enter it in the whole column otherwise I have to edit each cell. The problem is I can get copy/paste-special "formula" to work for one cell at a time but I want to change all of the cells not just one at a time? tia, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy--paste--special "formula" for a whole column
That should work so maybe your problem has to do with relative vs. absolute
addressing of cells. I don't know your level of expertise and maybe you've already checked this but, if not, see if you have "$" in cell references where they don't belong or if you have any missing ("$" causes that particular row or column to always be used rather than using the cell that's in the same relative row or column to the cell where you paste the formula). If this isn't it, a little more information on what "can't get . . . to work" would be helpful. Will "Janis" wrote: hOW DO YOU copy a formula from one cell to the rest of the cells in the column? I don't want the contents just the formula. I want to auto-enter it in the whole column otherwise I have to edit each cell. The problem is I can get copy/paste-special "formula" to work for one cell at a time but I want to change all of the cells not just one at a time? tia, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy--paste--special "formula" for a whole column
When you say you don't want the contents, only the formula, if the copied
formula points to a cell(s) with data entered, you will return a result. That is how formulas work. If the cell(s) pointed to contain nothing, you could get any number of results. Errors, nothing, zeros, etc. Show us an example of the formula you want copied down the column. Gord Dibben MS Excel MVP On Tue, 31 Jul 2007 07:34:06 -0700, Janis wrote: hOW DO YOU copy a formula from one cell to the rest of the cells in the column? I don't want the contents just the formula. I want to auto-enter it in the whole column otherwise I have to edit each cell. The problem is I can get copy/paste-special "formula" to work for one cell at a time but I want to change all of the cells not just one at a time? tia, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use "paste special" inside a formula? | Excel Discussion (Misc queries) | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| "paste special" a hyperlink to another worksheet... | Excel Worksheet Functions | |||
| Inactivating of "Paste special" while linking charts | Charts and Charting in Excel | |||
| I would like to copy & "paste special" an entire book | Excel Worksheet Functions | |||
Linear Mode
