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.
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.