Channel: Excel Campus - Jon

Category: Education

Tags: fill empty cellfill blanksfill blank cells in excel with textfill blank cells in excelexcel fill downcopy value from above in excelexcel value from row aboveblank cells in excelblank rowsexcelfill blank cellsexcel fill blank cellsfill blank cells in excel with value from aboveexcel blank cellsexcel value from cell aboveexcel campus3 ways to fill down blank cells in excelfill blank cells in excel with a valuefill blank cells in excel column

Description: 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 (excelcampus.com/elevate), for posting this question inside the program. 📁Read the accompanying blog post & download the example files here: excelcampus.com/functions/fill-down-blank-cells 💻 ☕👉Free Webinar on Power Query, VBA, & More: 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: youtube.com/watch?v=jd9PZd7Itzs Paste Values in Excel with the Right-click & Drag Shortcut: youtube.com/watch?v=sVagS3j1ryI Power Query Overview - Automate Data Tasks in Excel & Power BI: youtube.com/watch?v=vq9AgAtSvQg How to Create a Personal Macro Workbook in Excel and Why You Need It: youtube.com/watch?v=rD2-mSbTuL0&t=41s #MsExcel #ExcelCampus