Repair missing labels in a real worksheet
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).
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.