3 Ways to Fill Down Blank Cells in Excel

In this video, we explore 3 methods for filling blank cells with the values above them. This is useful when you have a column of data with blank cells below each header section in a report.
Filling down each section manually with the Fill Handle can be time consuming. So in this video we look at different ways to save time and automate the fill down process with: a formula, a macro, or with Power Query.

📁Read the accompanying blog post & download the example files here:

💻 ☕👉Free Webinar on Power Query, VBA, & More:

Table of Contents:
0:00 - Intro
1:03 - Formula
4:06 - Power Query
5:42 - Free Webinar on Power Query & VBA
6:00 - VBA Macro
9:01 - Pros & Cons
10:56 - Conclusion + Free Gift

Related Videos:
5 Keyboard Shortcuts to Paste Values in Excel:
Paste Values in Excel with the Right-click & Drag Shortcut:
Power Query Overview - Automate Data Tasks in Excel & Power BI:
How to Create a Personal Macro Workbook in Excel and Why You Need It:

#MsExcel #ExcelCampus

[simonasterisk]

I didn't originally think this would be useful, but it turns out that these methods can be very helpful. Right now I need to add the number for the car to each row in a 155 page pdf. That would take long without these features!

[lastmilerunnerlastmilerunn]

Jon Thankyou!! I was struggling since data was 3L + rows. Appreciate it!!

[DougHExcel]

Thanks for covering the different examples

[Burak-lzjk]

Thanks John. I came across this video randomly and wish I had known this before.Formula trick is just amazing and very easy

[MrTrD]

I like the first method more. I was able to fill horizontally. Thanks, great video

[timmytesla]

This video saved me a lot of time. Thank you!

[arodlo]

Excelent!!! I like it because you explain very clearly

[mk_powerbi]

Dear,
this is quick and nice, thx for video.

I'm using also small other technique, if you have data like video- open the filter list, click only "empty" boxes then type into [cell B3] =B2, copy this cell and paste down :)

Enjoy!

All the best for you!
MK313

[petejuneaux]

If I would have known this trick 10 yrs ago, I would be 3 years younger!!

[SamerDebs]

The first technique is very useful, I had no idea we could do that.

[darrylmorgan]

Cool Tutorial 3 Great Solutions...Thank You Jon :)

[DianaVillalobos-mhjk]

Life saver! GREAT content and super simple! 😄

[christellemarchand]

Nice... very helpful, , clear and practical!!! Thank you!

[chonzadaniel]

Great stuff. Thanks Jon for sharing the techniques!

[wayneedmondson]

Hi Jon. Awesome! Great solutions. Thanks for the tips :)) Thumbs up!!