Forum Discussion
Formula to fill blank cells with first value in column
Is there a way to fill all blank cells (ex: C2:DL157) with the value from row 1 (basically fill blank cells with the header)?
Select C2:DL157.
Press F5 to activate the Go To dialog.
Click the Special... button.
Select Blanks, then click OK.
Make note of the address of the active cell in the name/address box on the left hand side of the formula bar.
For example, if it is a cell in column C such as C12, enter the formula =C$1
But if it is a cell in - say - column F such as F37, enter the formula =F$1
Confirm the formula by pressing Ctrl+Enter, not just Enter or Tab.