How to FILL BLANK CELLS in Excel (with 0 or Text or Formula)

In this video, I will show you a super-fast way to select all the blank cells in a data range and fill these blank cells with any value/formula you want.
To select all the blank cells in a data range, you can use the Go To Special dialog box. In the Go To Special dialog box, there is an option called Blank - which instantly selects all the blank cells at one go.
Once you have all the blank cells selected, you can fill all these at one go by first typing the content that you want in these blank cells and then using Control + Enter (hold the control key and press the Enter key).
Doing this would fill the content in the active cell in all the blank cells, that were already selected.
This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@cathyqinKoreanEnglishSongs]

expecting a livestream of this, it is your wonderful instructions that saved the day!

[@lizastufflococucs6200]

hands down best video on RUclips. Tip Control + A will select the entire area of a range you are in even if it's not yet a table.

[@Up4Excel]

CTRL + ENTER is a great tip....I previously used to copy a cell and then paste once the blanks are selected. Thanks.

[@alainanielson1904]

I appreciated the quick video which solved my problem immediately. Thank you!

[@leerobbo92]

Wonderful, I really appreciate how straightforward this tutorial is. No BS, no long-winded introductions, just a very clear, concise explanation. Subbed!

[@shihabthangal1405]

My goodness, you just saved me hours of time. Thank you so much for your straightforward video!

[@RicksterBerlin]

There is a place in Excel Heaven for you, Sumit. Thank you.

[@sophiezarski1253]

Wait, so the excel tests where cells are just blank and there is no formula available you just write not available for every cell?

[@franvasi759]

Thank you! This helped immensely with filling blank cells in a huge report! Great tip!

[@vijayshettar8460]

Thanks bro for saving time

[@CrystalElaine31]

Direct and to the point! Thanks!

[@geofox9484]

I write code all day in py and js but don't know anything about excel, thanks so much! Because of you I didn't have to bother a sr. dev about a silly excel issue

[@ashhao8548]

Thanks mate, quick and straightforward video, does exactly what I was looking for. Cheers!

[@timmyvawwter8898]

EXCELLENT VIDEO! well done, sir!!

[@nikhilbawaskar4469]

That is exactly what I am searching for thanks dude 🍷

[@user-fb8jb5yi6g]

Excellent! I was scratching my head on this one!

[@alexandrewmaceda1388]

you're a Savior. Thank you for this.

[@karthickr8775]

Super bro..your video helps me to fill huge file which is assigned to me by my boss

[@user-lh1gh4ke9s]

Thanks a lot. This video is really helpful for me and u save my problem.

[@stuartreilly6305]

Worked a charm, thanks for posting!

[@kl32nefkwhnilshfi]

Useful and easy to understand, thanks!

[@ankuragrawal9836]

Very straightfwd and to the point, thanks!

[@usmanali81]

We can use the FIND & SELECT > REPLACE functionality as well for filling blank cells with any value.

[@kapiljha7515]

Your example is very valuable for me thanks a lot sir

[@user-wp2zr3ou6j]

Thank you Brother! good explanations! it has worked and it was tiresome while filling empty space with zeros

[@j.d.mosley-matchett9802]

Thank you, Sumit. I knew there was a simple solution, but couldn't figure it out on my own.

[@zulfi1969]

Me too; I tried with conditional function but failed to achieve what I wanted. We never choose the simplest way at first place (in this case I didnt know) :)

[@sergioriverarocha1525]

You've just saved me a lot of time with this trick, thanks!

[@drsalammd]

Excellent, easy way of telling

[@jillianandrews8202]

Literally saved my life THANK YOU !

[@Abo_Ezn93]

Love you man

[@trumpexcel]

😊

[@rutujathalkar2630]

Hey Sumit thanks for precise video for GO-Special-Blank formula utilization. I had learned this previously but after watching your video it's been fixed in mind due to easy steps

[@fazanfazanovski2712]

Great video. Saved me having to endlessly scrol down. Learned something new at the same time. Thank you so much, and all the best.

[@LuzAvendano-tj2gk]

Pefectly explained. Thank you!

[@shanmugam1098]

very special morning

[@jasonjunior1308]

You're an angel bro. Thanks a lot

[@ratheesh.r.svellanad2875]

Simple but very big information. Thank you so much. Great......

[@Saifmd889]

Thank You, It was urgent to get this way and I found this. Really helpful.

[@zoltanrudolf]

Brilliant video! I've watched it twice :-)

[@Traumabonded888]

Saved me about 20 hours.

[@fionncliffe5706]

Good on ya Sumit, saved me heaps of time!

[@akashkamal3758]

very simple ... very useful

[@michelledillard6316]

Very helpful, thank you.

[@wakegirl49]

Thank you so much for sharing your knowledge with us!❤ Do you know if there's another way besides manually, to select all the blank cells in a range using Excel for Android, that doesn't require the control key shortcut (since Android keyboards lack the control key)?

[@mjjrr1331]

Thank you kind sir! This was very useful! :)

[@Lzv-td2bs]

So helpful!!

[@rockking437]

thank you so much and keep uploading more useful videos

[@brightgardenentrepreneuria910]

Thanks, short and to the point.

[@rumeysaaydemir835]

thank you so much! great video

[@mohsink4u]

Nice video. helped me today

[@farrukhshahzad292]

I was very helpful. Thank you for sharing.

[@gregoryharington6686]

Excellent Summit!

[@trumpexcel]

Thanks for commenting Gregory! Glad you liked the video

[@sdncurugartandeducation812]

May God Bless You Sir! This is very Helpfull!!!

[@Smithyswife229]

Thank you brother! Quick and simple!! Saved my butt!

[@RolandPitts]

TrumpExcel the GOAT

[@farhanawali4008]

Thank you
Like the way you explain the concept -Simple to the point yet powerful applications

[@lokeshsain374]

Thanks 👍

[@nehadhawan3441]

Big thank you!!!🙂

[@CHZ8959]

Nice!! Thank you.

[@fatemeh2560]

so cool! thank you!

[@daraghahramani7858]

THANK YOU SO MUCH

[@johnscallon4901]

love it, thank you

[@ngonimichaelmayeresera749]

Insightful thank you

[@lakbaylaboy2644]

you saved me today!

[@sevenemirates820]

Thank You so much. I really surprised when I see the result. I need this in data analysis Sheet.

[@surjagain]

Thank you, this is a really useful tip :) Do keep them coming!

[@trumpexcel]

Thanks for commenting.. Glad you're liking these short Excel videos :)

[@doremi9604-]

Thank youuuuuuuuuuuuuuuuuuuuuuuuu!!!

[@ahmadrusyaidi4670]

THANK YOU BROTHER

[@clairebesinio3838]

Thank you! Very helpful

[@pattyanais3132]

Beautiful! Thank you!!

[@TroyFortra]

Thank you!

[@mar25947]

THANK YOU!!

[@mohammadafsari4686]

Well done , after select empty cells , how can fill up cell in empty cell

[@awesh1986]

Hey thanks for this tip SUMIT I learnt this long time back from some random video. But yes this is just awesome.

[@simranthiara8233]

Thanks, got stuck at the last part where I wanted to put the same value in all blank cells. Was hitting just Enter instead of Ctrl + Enter

[@chatrapathikrishnaji128]

Many thanks man,you made my research work very easy

[@Youtuber69863]

Hi. Splendid and crisp. Thanks. Hope you have many more such solutions in the Make it Simple mode.

[@msexcelgooglesheet374]

thanks for making this video. 💝💝💝💝

[@GoogleUser-kt9if]

Thank you!!

[@immortalgladiator5376]

Thanks for the information.
I am struggling to fill values in a huge data. My question is if I want to fill unique values in each of those blank cells then how do I do that?

[@theoldbroadsdog2638]

Thank you !!!

[@123mailashish]

Excellent.

[@indian2030]

Understood thanks bro...

[@pkykannada8150]

Thank you bro 😍☺

[@noumanaziz5711]

very helpful

[@suwalalchoudhary139]

Hi Sumit this is a very useful tips

[@trumpexcel]

Glad you found it useful Suwalal!

[@naya_gpl]

Thank you for the tips! Super helpful

[@harsinchh4342]

Great, Thanks.

[@kootuporriyl]

Very useful

[@qiaoyanli7153]

Now I have a new question in regard to your tutorial. How to fill these continuous blank data with the nearest average values before and after? Is there an easy way to achieve instead of doing that manually.

[@x_0rin]

thanks man!

[@nishantpatnaik974]

Thanks a lot!!! :)

[@stutipunglia3168]

Thanks a lot for this quick tip!

[@skyview059]

Thank you sooooooooooo much for you video tutorial. :)

[@joblack1838]

Thank you

[@michellepozzini3561]

This is absolutely great, i wish i could comment with a gif!

[@shabbirkanchwala-abwaab6263]

Wow
I need to fill blank cell very often.... this is very useful to me
Thnx
Sir,
How to make selected Cell/Text BLINK?
Pls Help

[@trumpexcel]

Glad you found the video useful! To make these blink you will have to use VBA. You can use conditional formatting to highlight all blank cells in a dataset,

[@shabbirkanchwala-abwaab6263]

@@trumpexcel conditional format do highlight but I wish to BLINK .... CELL/TEXT for easy n fast recognition
Pls share VBA Code if u can

[@Bendueee]

Thank you so much! This helped me with my data analysis!!!

[@tonymwaring]

Brilliant! So clever, thank you so much.

[@thomaswilkins8499]

Thankyou !

[@not_so_nabin]

thank you so much

[@fadzilyunos2985]

Tq Brother for sharing ..