Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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.

Thanks to Doug, a member of our Elevate Excel Training Program (https://excelcampus.com/elevate), for posting this question inside the program.

Read the accompanying blog post & download the example files here:
https://www.excelcampus.com/functions/fill-down-blank-cells

Free Webinar on Power Query, VBA, & More:
https://www.excelcampus.com/blueprint-webinar

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:
https://www.youtube.com/watch?v=jd9PZd7Itzs
Paste Values in Excel with the Right-click & Drag Shortcut:
https://www.youtube.com/watch?v=sVagS3j1ryI
Power Query Overview - Automate Data Tasks in Excel & Power BI:
https://www.youtube.com/watch?v=vq9AgAtSvQg
How to Create a Personal Macro Workbook in Excel and Why You Need It:
https://www.youtube.com/watch?v=rD2-mSbTuL0&t=41s

#MsExcel #ExcelCampus