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

Подписаться 13 тыс.

Просмотров 355 тыс.

50% 1

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

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 141

@surjeetsingh9609 Год назад

Very useful and easy to understand. Thankyou

@ItJunction4all Год назад

You are welcome 🤗

@xaniakhan3085 10 месяцев назад

Thank u so much u just resolved my issue

@ItJunction4all 10 месяцев назад

You are welcome 😊

@xaniakhan3085 10 месяцев назад

@@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

@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.

@laylonormamatova7973 11 месяцев назад

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

@ItJunction4all 11 месяцев назад

You're welcome!😍

@PYSCOMAN123 8 месяцев назад

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

@ItJunction4all 8 месяцев назад

You are welcome 😍

@pradhyumansinghrathore9261 Год назад

Thank you, Excellent solution

@ItJunction4all Год назад

You are welcome!

@natashaspice2655 10 месяцев назад

Thank you for sharing, your a life saver 🙏

@ItJunction4all 10 месяцев назад

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

@natashaspice2655 10 месяцев назад

@@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 10 месяцев назад

Sure.

@Adnanmumtaz-vc2fr 2 месяца назад

Many Many thanks for this video ❤

@ItJunction4all 2 месяца назад

You are welcome 😍

@akshaygaikwad6017 Месяц назад

Awesome ❤🎉🎉

@ItJunction4all Месяц назад

Thank you! Cheers!

@veeramanoharm2056 Год назад

Thank you so much for the video. It helped me

@ItJunction4all Год назад

You're welcome Veera Manohar M !

@MeoPlayGames 11 месяцев назад

BRAVO IT HELPED ALOT

@ItJunction4all 11 месяцев назад

Thank you 😍

@preetivyas2353 Год назад

Thank you sir 🙏🏻

@ItJunction4all Год назад

You are welcome Preeti 🙂

@pushkaran1116 8 месяцев назад

Thank you very useful

@ItJunction4all 8 месяцев назад

You are welcome 😍

@welcome4474 10 месяцев назад

Best knowledge 😊

@ItJunction4all 10 месяцев назад

Thank You !

@yourservant3159 Год назад

Thanks a lot sir.

@ItJunction4all Год назад

You are welcome 🤗

@sachinkumarmishra1746 9 месяцев назад

Very good 👍 sir

@ItJunction4all 9 месяцев назад

Thank you ❣️

@sharlona1098 Год назад

thank you it helps a lot

@ItJunction4all Год назад

You're welcome Sharlona !

@teiganroberts2297 9 месяцев назад

Very useful, thank you

@ItJunction4all 9 месяцев назад

You are welcome 🤗

@gameruk0141 Год назад

Thank you 👍🙂😃😊😀😘

@ItJunction4all Год назад

You are welcome 🤗

@gopikisna9209 5 месяцев назад

But what if some rows are partially empty

@roxchandu2 2 года назад

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 2 года назад

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 .

@samikhan-gc6uk Год назад

Very helpful 👍

@ItJunction4all Год назад

Thanks for your feedback Sami khan !

@ireneelbie5022 10 месяцев назад

Thank you!!! 🙏

@ItJunction4all 10 месяцев назад

You are welcome 😊

@therealistthereis3852 8 месяцев назад

Very useful

@ItJunction4all 8 месяцев назад

Thank you 😊

@Joyokhomina55 8 месяцев назад

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

@ruthlessrays9761 Год назад

Thanks so much!!

@ItJunction4all Год назад

You're welcome!

@ranjith7553 Год назад

Thank You!

@ItJunction4all Год назад

Welcome Ranjith 😊

@manishkumar-fu9xl Год назад

Thank you so much

@ItJunction4all Год назад

You're most welcome Manish !

@RahulGupta-tt1go 11 месяцев назад

How to do total of each row please tell me

@ItJunction4all 11 месяцев назад

Can you describe your requirement?

@Dibakar-Singha 2 месяца назад

Thank you sir

@ItJunction4all 2 месяца назад

You are welcome 😍

@Raman970 2 года назад

Thanks for this

@ItJunction4all 2 года назад

Welcome Upkar Singh !

@dbdb Год назад

Thanks this helped

@ItJunction4all Год назад

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

@Rytheus Год назад

Thank youuuu! 🎉

@ItJunction4all Год назад

You are welcome 🤗

@Just4Fun1.0 Год назад

Tq it works!!

@ItJunction4all Год назад

You are welcome 🤗

@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 😊

@shaktienterpriseskanpurup8985 Год назад

THANK YOU...

@ItJunction4all Год назад

You're welcome!

@snehlata2305 2 года назад

Very nice👌

@ItJunction4all 2 года назад

Thanks a lot !

@smpublication1285 8 месяцев назад

Thank you 3

@ItJunction4all 8 месяцев назад

You’re welcome 😊

@arshadsgalllery9898 7 месяцев назад

Same for columns?

@ShooterXshahid-u1p 10 месяцев назад

Thanks ❤❤

@ItJunction4all 10 месяцев назад

You are welcome ❤️

@restaurantrecipebyhafsa 8 месяцев назад

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

@JawadKhan-xz8wz Год назад

Thank you broo

@ItJunction4all Год назад

Welcome Jawad Khan !

@buchibot Год назад

Thank you

@ItJunction4all Год назад

You are welcome 🤗

@Balaji_Healthcare_ Год назад

Solved 💞

@ItJunction4all Год назад

Thanks Yash !

@sitarambhaideshmukh5562 Год назад

Thanks

@ItJunction4all Год назад

Welcome Sitarambhai deshmukh !

@tonysky12 9 месяцев назад

shukriya

@ItJunction4all 9 месяцев назад

Thank you ❣️

@Mario10016 9 месяцев назад

thx

@ItJunction4all 9 месяцев назад

You are welcome :)

@dipansh00 Год назад

how to add Blank Lines between multiple rows / data

@roxchandu2 2 года назад

Thank u

@ItJunction4all 2 года назад

Welcome Chandu !

@abdulaseesillath2686 Год назад

NO ROWS WHERE SELECTED

@ItJunction4all Год назад

I did not understand your question.

@himanshusom4080 11 месяцев назад

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

@ItJunction4all 11 месяцев назад

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

@himanshusom4080 11 месяцев назад

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

@jaimetheone9150 10 месяцев назад

Fastest method there is.

@ItJunction4all 10 месяцев назад

Which method?

@jaimetheone9150 10 месяцев назад

@@ItJunction4all yours! duh!😁

@ItJunction4all 10 месяцев назад

@jaimetheone9150 Thank you 😍

@jaimetheone9150 10 месяцев назад

@@ItJunction4allSubscribed

@saurabhkumarkanaujia6406 Год назад

Thnks

@ItJunction4all Год назад

Thanks Saurabh ☺️

@thamarujayalath1667 Год назад

❤

@ItJunction4all Год назад

Thank you 😊

@niyatiwalke9110 Год назад

Tysm😅

@ItJunction4all Год назад

Welcome Niyati Walke !

@vaishumane5109 11 месяцев назад

This is not working for large data

@ItJunction4all 11 месяцев назад

What volume of data you tried ?

@sarjuyadav4764 11 месяцев назад

How to do with 2 lakh data

@abhishekkumarsingh4389 Год назад

Control+g

@ItJunction4all Год назад

Thank you 👍

@Isha-vh7hr Год назад

🤟👍

@ItJunction4all Год назад

Thank you 🙂

@PradeepYadav-gu9hp Год назад

Sir 1 line krni h bus

@ItJunction4all Год назад

Yes Pradeep !

@scottwilkerson1208 Год назад

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

@ItJunction4all Год назад

All columns will be deleted 😊

@feedpoorpeople4149 Год назад

Worked tnku😊

@ItJunction4all Год назад

You are welcome 🤗

@parthjograna6377 Год назад

Thank you sir 😊

@ItJunction4all Год назад

You are welcome 🤗

@Ajeetjaiswal1997 Год назад

Thank you 🙏

@ItJunction4all Год назад

You are welcome 🤗

@mukultyagi8066 Год назад

Thank you sir

@ItJunction4all Год назад

Welcome Mukul Tyagi !

@ForYou-hq5uu 9 месяцев назад

Thank you

@ItJunction4all 9 месяцев назад

You are welcome

@sanjivanientertainments Год назад

Thanks

@ItJunction4all Год назад

You are welcome

@bittusaini25 Год назад

Thank you Sir ❤

@ItJunction4all Год назад

You are welcome 🤗

@shylo3446 Год назад

Thank you

@ItJunction4all Год назад

You're welcome Shylo !

@TradewithVikasK Год назад

thanks

@ItJunction4all Год назад

Welcome !