Fill Blank Cells in Excel With Value from Above


About this tutorial:

Video duration: 2:26
Visit this page to download the sample file, and for written instructions and a macro to fill blank cells.

Some sheets have blank cells, so headings are easier to read. If you want to sort or filter the list, you need to fill in the blanks, by copying the value from above.

This video shows a quick way to select and fill all the blanks, and use a mouse shortcut to change the formulas to values.


  1. This is a great video and great to know going forward love this feature its very helpful but, how does this work when its only one row that needs to be copied the instructions do not work? Thanks so much!

  2. hi im using a file downloaded from SAP in excel format but when i apply the same after selecting the blanks in the the dialog box i get an error as no  blanks were found why is it?how to solve it


Please enter your comment!
Please enter your name here