The "smart" solutoons only work if you are trying to fill _all_ blanks cells in a defined rectangular area. Only Damiross's solutions works if you want to enter a value in any seection of non-contiguous cells. Others require the value to be numeric.

To answer Bob Duncan: Yes it does!