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 –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Nice video. helped me today
I was very helpful. Thank you for sharing.
but, how do you set a zero in all blank cells?
Great video. Saved me having to endlessly scrol down. Learned something new at the same time. Thank you so much, and all the best.
Thanks 👍
You're an angel bro. Thanks a lot
THANK YOU BROTHER
My goodness, you just saved me hours of time. Thank you so much for your straightforward video!
Thank you! Very helpful
Thank u
Good on ya Sumit, saved me heaps of time!
the example above shows NANCY next to number 2. Is it possible to drop number 1 in order to make it right next to NANCY ?
Hi Sumit-It didn't happen by pressing f5 as it gives the brightness decrease option..I had to to home tab an GoTo..PLease suggest
awesome
My goodness, you just saved me hours of time. Thank you so much for your straightforward video!
Thank You, It was urgent to get this way and I found this. Really helpful.
This is absolutely great, i wish i could comment with a gif!
I appreciated the quick video which solved my problem immediately. Thank you!
you saved me today!
You've just saved me a lot of time with this trick, thanks!
Brilliant! So clever, thank you so much.
Thank you Brother 😊😊
Thanks a lot
I can't get my Mac to respond and insert when I press Control + Return (enter). Anyone else experience this?
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
Thank you!!
Ma Sha Allah, very much nice
Thaq its helps me
Thankyou
Tq sir
thanks for making this video. 💝💝💝💝
thank you