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,