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.
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.
________________
Thank You!
Thank you – This is a life saver!!!