Fill Blank Cells in Excel With Value from Above

I’m updating some of the pages on my website, and found an old video that shows how to fill blank cell in Excel 2003. Wow, that version came out 10 years ago! So, it’s time to do an update.

You can see the new video below, and I show the steps in Excel 2013. The same instructions will work in Excel 2010 or 2007.
[Update] I’ve also added a newer video, that shows the steps in Excel 365.

Blank Cells on the Worksheet

It’s a solution to a common problem – you get data from someone, and some columns 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.

Blank cells on worksheet
Blank cells on worksheet

With a few simple steps, you can fill all the cells, using the first value shown above the blank cells.

Video: Fill Blank Cells – Excel 365

This video shows a quick way to select and fill all the blanks, and use a mouse shortcut to change the formulas to values. I used Excel 365for this video.
The steps are the same in other versions of Excel.

Video: Fill Blank Cells – Excel 2013

This video shows a quick way to select and fill all the blanks, and use a mouse shortcut to change the formulas to values. I used Excel 2013 for this video.

Get the Sample File

To download the sample file, please visit my Contextures website: Fill Blank Cells

The file is zipped, and in xlsm format – it also contains a macro that you can use to fill blank cells.

________________

0 thoughts on “Fill Blank Cells in Excel With Value from Above”

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.