Technology

How to fill blank cells with value below in excel?

3 answer(s)
Answer # 1 #

I use VBA macro for this. Quick code: vba Selection.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[1]C" Selection.Value = Selection.Value

[1 Month]
(4)
Answer # 2 #

Shortcut lovers: Alt+E+S → V (Paste Special Values) after using formulas helps finalize the fill.

[1 Month]
(3)
Answer # 3 #

Select the column → Press Ctrl+G → Special → Blanks → type = then arrow down → press Ctrl+Enter. This fills all blanks with the value from below.

[1 Month]
(2)

Related Questions