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.

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.

fillblankcells06

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

Video: Fill Blank Cells

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

Or watch on YouTube: Fill Blank Cells

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.

________________

You may also like...

2 Responses

  1. matt Kent says:

    Thank You!

  2. Lynda F says:

    Thank you – This is a life saver!!!

Leave a Reply to matt Kent Cancel reply

Your email address will not be published. Required fields are marked *