Copy vals from "holding tank" to blank cells

[bclayshannon]

I don't normally "mess with" Excel much, but I have a rather large sheet that would be quite tedious to complete without using a formula I could apply to all balnk cells within a range.

How could I apply the same formula to all blank cells in a range (a "rectangle" I could first select/highlight, I suppose) that would be:

If this cell is blank, copy the value at Cell[this row, specified column] to this cell.

(a particular column will have the "default" vals for each row - which is what currently blank cells should be populated with).

Also: If these default vals are later manually overwritten, how would I prevent the formula from reverting it back - by deleting the formula in that particular cell?

[dangelor]

Try using the GOTO pop up window (F5), under the Special button, select "Blanks"

[bclayshannon]

Try using the GOTO pop up window (F5), under the Special button, select "Blanks"

OK, that's cool - it selects all of the blank cells. But now how do I get those blank cells to populate with the value at column V (in my case) in the respective row?

[dangelor]

Try copying the formula, select the blanks and then paste with Ctl+V.

[bclayshannon]

Try copying the formula, select the blanks and then paste with Ctl+V.

It's the formula that I need

[dangelor]

Use Paste Special = formulas?