copy-->paste-->special "formula" for a whole column

[Guest]

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,

 

[Guest]

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

 

[Gord Dibben]

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