3 Ways to Fill Down Blank Cells in Excel

Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
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:
www.excelcampus.com/functions...
💻 ☕👉Free Webinar on Power Query, VBA, & More:
www.excelcampus.com/blueprint...
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:
• 5 Quick Keyboard Short...
Paste Values in Excel with the Right-click & Drag Shortcut:
• Quickly Paste Values I...
Power Query Overview - Automate Data Tasks in Excel & Power BI:
• How To Automate Data T...
How to Create a Personal Macro Workbook in Excel and Why You Need It:
• How to Create a Person...
#MsExcel #ExcelCampus

[@DougHExcel]

Thanks for covering the different examples

[@simonasterisk3440]

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!

[@lastmilerunnerlastmilerunn5703]

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

[@timmytesla9655]

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

[@Burak-lz9jk]

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

[@tri3dtips]

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

[@arodlo7072]

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

[@nadermounir8228]

Excellent tutorial. Thank you so much

[@mgashumba]

Thank you so much for these videos

[@lettysantos7753]

Thanks jon, love your voice.

[@venusamadeo4605]

Thank u for this, sir. Very helpful.

[@abdurrahmanhakim4612]

thanks you, you made my day 👍👍

[@christellemarchand3618]

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

[@estebanzapata5960]

Thanks, this helped me alot!

[@tunastarmedia2699]

Thanks, Time Saver.

[@ExcelCampus]

Glad it helped, @tunastarmedia2699 😀

[@cadjiton]

Great, Thank You.

[@deborahbatista4642]

Great content, easy to follow

[@ZeratulX]

Great tips Jon!!! thank you

[@SamerDebs]

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

[@johnmeijer1246]

Awesome. You excell in explaining

[@chonzadaniel]

Great stuff. Thanks Jon for sharing the techniques!

[@ExcelCampus]

Thanks Emmanuel! 🙂

[@mahansor8295]

Many thanks ☑️

[@MathJunkz]

Very easy! Thanks!

[@ExcelCampus]

You're welcome @clorettalewis1711! 😀

[@chia-chenchang3865]

Super helpful Thanks so much!

[@ferdianrayendra1998]

Nice trick formula,, thank you

[@DianaVillalobos-mh9jk]

Life saver! GREAT content and super simple! 😄

[@ExcelCampus]

Thanks, Diana! :)

[@mSherjeelr]

chatgpt suggested me this video

[@darrylmorgan]

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

[@ExcelCampus]

Thank you Darryl! 🙌

[@wayneedmondson1065]

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

[@tuhintalukder3359]

Thank You.

[@grahamparker7729]

Love this one Jon 👍🏻

[@mk_powerbi2873]

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

[@wadelackey9218]

Thank you so much!!!!

[@ExcelCampus]

You're welcome! 😀

[@omarnader776]

Great solution, thanks a lot

[@ExcelCampus]

Thanks Omar! 🙂

[@kebincui]

Excellent tips👍. Thanks

[@ExcelCampus]

Glad it was helpful! 😀

[@abdulhafizolawale2599]

Awesome!!!

[@ExcelCampus]

Thanks Abdulhafiz! 🙂

[@melenyhui3956]

Hi Jon. Great video. Just wonder what if one of the company name cell is blank, ( as the first method )it would be keep filling up other company's name above. I have to find other columns where has same patterns and use if function to fill down the blank cells. Any formula could help?

[@yaw7shni]

Waaaaw, this is cool. Thanks 🤩

[@petejuneaux7549]

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

[@bestenglishtutor1]

Good job

[@abdullahshikder8369]

Thanks

[@vrramnath]

Will you be able to show how to improve data visualization through excel?

[@jewelsoncagakit8423]

Hey Jon, thank you for this trick .. Now im curious if its possible to work on 2 columns, i.e. blank cells of column 1 will be filled with its corresponding data from column 2 . .

[@MadhuSingh-ln7gg]

It's really nice

[@beena3794]

Love it :)

[@mohamedchakroun4973]

Thanks for this cool filling down techniques :-) I like macro technique thanks for this macro solution. Could i have your personal workbook containing macros existing in your macro rubban thanks :-)

[@CCAFO]

Great!

[@felipelandim2881]

Great.

[@boojiebonde3421]

Hi, I am one of your subscriber and your video presentation very helpful and informative for line if work, by they way i just having a little hard to create a drop down list text with percentage value and equal to average,if you can help me,really appreciate.😊

[@mimikyi6122]

Thank you Jon. I would like to know, how do I create My Macros Ribbon? :D

[@chandanmadaan3888]

That is awesome tutorial. I need your help, I need to fill blank spaces as $0.00 how can i do so by using macros?

[@fengfuxu4822]

thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers". Sub ListPrinters() Dim prt As Printer For Each prt In Printers Debug.Print Prt.deviceName Next prt End Sub

[@mehmetdogu384]

IF you write a formular for example: =b1*20+b5 enter and continue to the end of column of 30 000 it does not accept. Can you show how to sort it? Thanks in advance..

[@CCAFO]

Hello, how to fill the same value from below to above cell?

[@martamm7989]

Cool example> I have question regarding to this. For instance Cell B2" 25354Aimbo" Cell B3 is address of this company "Street 125" and it is repetitive for all companies. One common thing is that in each Company name is number at beginning. ..... I prefer delete this address and received the result as you have ? Please may you help me with this case ?

[@audunskrindo5877]

Regarding the first wya: I have a list with more than 30000 rows that I need to do this on. When I have come all the way to Select blanks the response from Excel is (found no blanks) even though I see them on my screen - they are there. What can be wrong? I even selected the whole column and pasted it as values in a totally blank sheet. Still Excel does not find the blanks between. Help me out here. The trick only works when I write the "headerwords" randomly myself.

[@KevKevAllen]

I need to fill down while having one part of the formula remain constant. Example: C1*D1 and C2*D1 and C3*D1

[@EricDunn-ci3ks]

Is there a way to un-fill-down cells? I have now a column that has an entry all the way down to forever. I don't want to delete the entries above a certain row, but would like to delete what appears to be an auto-fill entry all the way down from that row. Thanks.

[@ExcelCampus]

Hi Eric! 😊 Select the first cell that you want to delete (single click, not double). Hold down both the Shift key and the Ctrl key. Then press the down arrow once. Let go of all three keys. If all of the entries you want to delete are selected, press the delete key; if not, repeat the Shift+Ctrl+Down Arrow step as many times as needed until you reach the exact end of your deletion, then press delete. If you went too far, you can hold Shift and press the Up arrow to go up one cell, or Shift+Ctrl+Up Arrow to go up an entire section. Hope this helps! 🙂

[@mazeembutt1]

So I have a question. so far no one could assist me with my file data. Hope you can assist. Please Advise.

[@mehmetdogu384]

formi=uar was like =b$1*10+b5 al the way to the last row of 30k rows

[@shamoonahmed9109]

Hi Jon, Could you please help me to find out blank's cells in excel, as my data contain product with picture, and we want to find out product without pictures. = ISBLANK will show all cells are empty as formula read image cells also empty.

[@ExcelCampus]

Nice question, Shamoon! Try the COUNTBLANK function to yield the number of blank cells per range. I placed a stock image in a cell (Insert > Pictures > Place in Cell > Stock Images...), and COUNTBLANK did not count that cell as empty. For counting non-blank cells, use COUNTA.

[@jouuueee]

Is there a way to convert the formula within a cell to the actual value of the formula result.

[@jouuueee]

I literally asked this question just as you explain how to do it damn it thank you

[@ericleszkowicz898]

😳

[@w3y2023]

Thanks alot you are the best teacher

[@ExcelCampus]

Wow, thanks! 😀