Thread: Copy vals from "holding tank" to blank cells

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?

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

Originally Posted by dangelor

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?

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

Originally Posted by dangelor

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

It's the formula that I need

Use Paste Special = formulas?