How to Delete Blank Rows in Excel ? | Excel Tips & Tricks

Do Like 👍👍, Comment & Subscribe
How to Delete Blank Rows in Excel ?
Manually deleting blank rows in excel is very much time consuming. In this video I have shown excel tricks to delete entire blank row or rows that contains blank rows
-------------------------------------------------------------------------
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
-------------------------------------------------------------------------
🔆Instagram :
/ itjunction4all
🔆 Twitter:
/ sunilkr5672
-------------------------------------------------------------------------
#Excel #ExcelTricks #ExcelTips

[@MeoPlayGames]

BRAVO IT HELPED ALOT

[@ItJunction4all]

Thank you 😍

[@natashaspice2655]

Thank you for sharing, your a life saver 🙏

[@ItJunction4all]

You are welcome. I am glad that I was able to help you 🙂

[@natashaspice2655]

@@ItJunction4all I subscribed because I am sure there is a lot more I can learn from you, keep the videos coming and thanks again 🙏

[@ItJunction4all]

Sure.

[@yourservant3159]

Thanks a lot sir.

[@ItJunction4all]

You are welcome 🤗

[@sharlona1098]

thank you it helps a lot

[@ItJunction4all]

You're welcome Sharlona !

[@Just4Fun1.0]

Tq it works!!

[@ItJunction4all]

You are welcome 🤗

[@welcome4474]

Best knowledge 😊

[@ItJunction4all]

Thank You !

[@gopikisna9209]

But what if some rows are partially empty

[@ruthlessrays9761]

Thanks so much!!

[@ItJunction4all]

You're welcome!

[@dbdb]

Thanks this helped

[@ItJunction4all]

Welcome DB ! I am glad that this excel shortcut helped you .

[@prabakaranr8942]

ok but show the rows colour different so that if select entire row delete will be better...

[@ItJunction4all]

Ok sure... thanks for the suggestions 😊

[@Dibakar-Singha]

Thank you sir

[@ItJunction4all]

You are welcome 😍

[@Rytheus]

Thank youuuu! 🎉

[@ItJunction4all]

You are welcome 🤗

[@smpublication1285]

Thank you 3

[@ItJunction4all]

You’re welcome 😊

[@sachinkumarmishra1746]

Very good 👍 sir

[@ItJunction4all]

Thank you ❣️

[@restaurantrecipebyhafsa]

if some cells are empty and some are not and we have to delete only whole empty rows not which have only one or some then what to do now

[@sitarambhaideshmukh5562]

Thanks

[@ItJunction4all]

Welcome Sitarambhai deshmukh !

[@surjeetsingh9609]

Very useful and easy to understand. Thankyou

[@ItJunction4all]

You are welcome 🤗

[@dipansh00]

how to add Blank Lines between multiple rows / data

[@xaniakhan3085]

Thank u so much u just resolved my issue

[@ItJunction4all]

You are welcome 😊

[@xaniakhan3085]

@@ItJunction4all sir I m very weak in Xcel mS offic and power point how can I resolv my this issue wht u suggest to me as expert

[@saurabhkumarkanaujia6406]

Thnks

[@ItJunction4all]

Thanks Saurabh ☺️

[@roxchandu2]

I have a doubt, sometimes if we are trying to enter long number in excel it will not take, it will be converted into some different format which consists of ' . 'and '+' symbol is there a way to avoid that please help me on this if u know.

[@ItJunction4all]

Thanks for writing Chandu ! I have just created shorts for this mentioned problem. You can watch from channel. Let me know if you have any doubts .

[@jaimetheone9150]

Fastest method there is.

[@ItJunction4all]

Which method?

[@jaimetheone9150]

@@ItJunction4all yours! duh!😁

[@ItJunction4all]

@jaimetheone9150 Thank you 😍

[@jaimetheone9150]

@@ItJunction4allSubscribed

[@abdulaseesillath2686]

NO ROWS WHERE SELECTED

[@ItJunction4all]

I did not understand your question.

[@akshaygaikwad6017]

Awesome ❤🎉🎉

[@ItJunction4all]

Thank you! Cheers!

[@Mario10016]

thx

[@ItJunction4all]

You are welcome :)

[@preetivyas2353]

Thank you sir 🙏🏻

[@ItJunction4all]

You are welcome Preeti 🙂

[@thamarujayalath1667]

❤

[@ItJunction4all]

Thank you 😊

[@laylonormamatova7973]

Thank you so much❤I spent an hour how to delete blanks😢,after watch your video,it took me 5 secunds

[@ItJunction4all]

You're welcome!😍

[@Adnanmumtaz-vc2fr]

Many Many thanks for this video ❤

[@ItJunction4all]

You are welcome 😍

[@Isha-vh7hr]

🤟👍

[@ItJunction4all]

Thank you 🙂

[@Ajeetjaiswal1997]

Thank you 🙏

[@ItJunction4all]

You are welcome 🤗

[@pradhyumansinghrathore9261]

Thank you,
Excellent solution

[@ItJunction4all]

You are welcome!

[@samikhan-gc6uk]

Very helpful 👍

[@ItJunction4all]

Thanks for your feedback Sami khan !

[@PYSCOMAN123]

Thanks a lot sir, you saved us a ton of time.

[@ItJunction4all]

You are welcome 😍

[@Joyokhomina55]

Does its work too when you already use pivot table in your data .. because it’s didn’t work in mine

[@veeramanoharm2056]

Thank you so much for the video. It helped me

[@ItJunction4all]

You're welcome Veera Manohar M !

[@pushkaran1116]

Thank you very useful

[@ItJunction4all]

You are welcome 😍

[@buchibot]

Thank you

[@ItJunction4all]

You are welcome 🤗

[@roxchandu2]

Thank u

[@ItJunction4all]

Welcome Chandu !

[@ireneelbie5022]

Thank you!!! 🙏

[@ItJunction4all]

You are welcome 😊

[@ForYou-hq5uu]

Thank you

[@ItJunction4all]

You are welcome

[@himanshusom4080]

मैंने Excel में बहुत सारे data को एक साथ select करके delete कर रहा था, लेकिन वो delete नहीं हुआ, क्या problem हो सकता है?🤔🤔

[@ItJunction4all]

आप blank rows delete कर रहे हो या data delete कर रहे हो इस method से? ये method blank rows delete करने के लिए है l

[@himanshusom4080]

@@ItJunction4all मैं row को नहीं,डाटा delete कर रहा था।

[@feedpoorpeople4149]

Worked tnku😊

[@ItJunction4all]

You are welcome 🤗

[@manishkumar-fu9xl]

Thank you so much

[@ItJunction4all]

You're most welcome Manish !

[@gameruk0141]

Thank you 👍🙂😃😊😀😘

[@ItJunction4all]

You are welcome 🤗

[@sanjivanientertainments]

Thanks

[@ItJunction4all]

You are welcome

[@FoodandMusic_]

You saved my time. Thank you

[@ItJunction4all]

You're welcome Rakesh Chintada ! I hope you have subscribed my channel for all future videos updates.

[@therealistthereis3852]

Very useful

[@ItJunction4all]

Thank you 😊

[@ShooterXshahid-u1p]

Thanks ❤❤

[@ItJunction4all]

You are welcome ❤️

[@shaktienterpriseskanpurup8985]

THANK YOU...

[@ItJunction4all]

You're welcome!

[@abhishekkumarsingh4389]

Control+g

[@ItJunction4all]

Thank you 👍

[@tonysky12]

shukriya

[@ItJunction4all]

Thank you ❣️

[@shylo3446]

Thank you

[@ItJunction4all]

You're welcome Shylo !

[@mukultyagi8066]

Thank you sir

[@ItJunction4all]

Welcome Mukul Tyagi !

[@JawadKhan-xz8wz]

Thank you broo

[@ItJunction4all]

Welcome Jawad Khan !

[@ranjith7553]

Thank You!

[@ItJunction4all]

Welcome Ranjith 😊

[@parthjograna6377]

Thank you sir 😊

[@ItJunction4all]

You are welcome 🤗

[@bittusaini25]

Thank you Sir ❤

[@ItJunction4all]

You are welcome 🤗

[@RahulGupta-tt1go]

How to do total of each row please tell me

[@ItJunction4all]

Can you describe your requirement?

[@Raman970]

Thanks for this

[@ItJunction4all]

Welcome Upkar Singh !

[@TradewithVikasK]

thanks

[@ItJunction4all]

Welcome !

[@snehlata2305]

Very nice👌

[@ItJunction4all]

Thanks a lot !

[@Balaji_Healthcare_]

Solved 💞

[@ItJunction4all]

Thanks Yash !

[@arshadsgalllery9898]

Same for columns?

[@vaishumane5109]

This is not working for large data

[@ItJunction4all]

What volume of data you tried ?

[@sarjuyadav4764]

How to do with 2 lakh data

[@PradeepYadav-gu9hp]

Sir 1 line krni h bus

[@ItJunction4all]

Yes Pradeep !

[@teiganroberts2297]

Very useful, thank you

[@ItJunction4all]

You are welcome 🤗

[@niyatiwalke9110]

Tysm😅

[@ItJunction4all]

Welcome Niyati Walke !

[@scottwilkerson1208]

Negative. This method deletes ONE column. I have thousands.

[@ItJunction4all]

All columns will be deleted 😊