How to fill blank cells with value above in Excel? - ExtendOffice.com

When we set up data in Excel, we always leave a blank cell if the data for that cell is the ... and a Go To Special dialog box will appear, then check Blanks option.

www.extendoffice.com