Practice · cells are editable. Fill genuine blanks within selected column runs. Existing zero, false, empty text and formulas remain data. A leading blank stays blank; the header outside your selection is not a seed.
Loading your interactive spreadsheet…
Selected: none
Preview before filling
0 undo action(s), 0 redo action(s).
Explain the current workbook
These checks read applied worksheet cells. Editor fields prepare a change; use the matching action button to put that change into the worksheet. A saved record describes a checked attempt on this device.
No current lesson check.
Report formulas and the blank distinction
COUNTBLANK counts formulas returning empty text, while this fill treats those formulas as occupied. COUNT counts only numeric flags; COUNTA also counts logical and text values.
G2 =SUMIF(A2:A13,F2,D2:D13)
G3 =COUNTIF(A2:A13,F2)
G4 =COUNTBLANK(A2:A13)
G5 =COUNT(B2:B13)
G6 =COUNTA(B2:B13)
G7 =SUM(D2:D13)
Cell
Actual value
Actual formula
A2
(blank)
B2
(blank)
A3
(blank)
B3
(blank)
A4
(blank)
B4
(blank)
A5
(blank)
B5
(blank)
A6
(blank)
B6
(blank)
A7
(blank)
B7
(blank)
A8
(blank)
B8
(blank)
A9
(blank)
B9
(blank)
A10
(blank)
B10
(blank)
A11
(blank)
B11
(blank)
A12
(blank)
B12
(blank)
A13
(blank)
B13
(blank)
G2
(blank)
G3
(blank)
G4
(blank)
G5
(blank)
G6
(blank)
G7
(blank)
Sources and previews remain in this browser. Both modes keep target formatting. Ordinary unmerged, non-array selections support up to 400 cells; selected gaps start independent column runs. Error sources propagate as errors, while error-looking text stays text.
