Sign up for our Excel webinar, times added weekly: 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 ( 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
- 3 Ways to Fill Down Blank Cells in Excel ( Download)
- FILL DOWN Until Next Value in Excel (3 Really Easy Ways) ( Download)
- Quickly fill blank cells with data above in Excel ( Download)
- Fill Blank Cells In Excel With Same Text @BrainUpp ( Download)
- How to FILL BLANK CELLS in Excel (with 0 or Text or Formula) ( Download)
- How to fill down blank cell fast in Excel (3 Methods) ( Download)
- Excel Quick Tips - How to Fill Down Blanks Using Keyboard Shortcuts ( Download)
- Quickly fill down blank cells with upper cell value in Excel ( Download)
- How to Copy Down a Formula that Contains Blank Rows in Excel ( Download)
- Fill Down Blank Cells in Excel ( Download)
- How to fill down blank cells in Excel! #excel #exceltips #exceltutorial #excelshorts ( Download)
- Excel Tips and Tricks #53 Fill Down Blank Cells in Excel ( Download)
- Fill Blank Cells in Excel With Value from Above | 3 Ways to Fill Down Blank Cells in Excel | ( Download)
- Fill Blank Cells with Value Above in Excel | Copy Values to Empty Cells Below - 4 Methods inc VBA ( Download)
- Excel Quick Tips - How to fill down blanks correctly in Excel #excel ( Download)
