Excel tutorial - Filling in blank cells vertically

It's not unusual to receive Excel data formatted for the eye, but not formatted nicely to manipulate in a database. Sometimes, spaces are left blank, as in this example:


There is a quick way to fill in the blanks in mass, rather than one section at a time.

Step 1

Step 2

Enter this column in cell B2:

Step 3

Explaining the formula


See more Excel tips