How to fill all Blank Cells in Excel within seconds

1. Select the entire data range including blank cells.
2. Go to the Home tab → click Find & Select → choose Go To Special.
3. In the popup, select Blanks → click OK.
4. All blank cells will be selected.
5. Without clicking anywhere else, type =D4 (or the reference to the cell just above the blank).
6. Press Ctrl + Enter to fill all selected blanks with the value from the cell above.

This technique is quick and especially useful for filling missing entries like Department or Designation from the row above.

Example: