How To Delete Blank Rows In Google Sheets

Подписаться 2,7 млн

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

50% 1

In this #shorts I'll show you how easy it is to remove blank rows or blank cells in Google Sheets. Data cleaning does not have to be boring, manual or difficult!
🌍 My Online Excel Courses ► www.xelplus.com/courses/
🎬 LINK to more RU-vid Shorts videos: • Shorts (Tips, Tricks &...
🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
📚 Excel RESOURCES I Recommend: www.xelplus.com/resources/
🎥 GEAR I use: www.xelplus.com/resources/#gear
More resources on my Amazon page: www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: / lgharani
Twitter: / leilagharani
LinkedIn: / leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#googlesheets #shorts

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

27 ноя 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@selffaiz7566 12 дней назад

Thank you ma'am😊

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

I prefer to use 'remove duplicates' to get rid of any blank rows

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

Safer too, as here it's only one blank column, isn't it?

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

I prefer ~>filter the blank rows>>copy the whole data into another sheet 😌

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

Yeah, just block all and remove duplicate 👍

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

will this delete other duplicates other than empty cells?

@ItsAssassin Год назад

@@rubyattwoodit will delete any duplicate entries there is...

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

That works if all the rows are blank. My way is using: F5, choose blank, right klick remove rows up.

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

F5 is underrated.

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

THANK YOU!! I never knew this and it's so much easier and faster than what I was doing before!!

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

Glad it helped!

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

You can use Ctrl+ G then Alt + S Select black and all space can go

@tjd7964 Год назад

Thanks so much

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

Nice tip! Thanks Leila. Thumbs up!!

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

Thanks for watching!

@Mal-xl8jh Месяц назад

So to delete a row better do this ? Let them blank?

@noman.sarfraz 2 года назад

It's awesome man

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

Just press ctrl+ G --> special--> choose blanks and delete all blanks

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

Special ?

@Game-id8iz 4 месяца назад

Dats for excel

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

Hi Leila nice to meet you. I recently discovered your channel and I am impressed with your content. I would like you to activate the Spanish translation option. I appreciate your contribution, greetings from Venezuela

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

Dear Leila, What is the difference for below terms microsoft 365 vs office 365 vs dynamics 365 vs windows 365

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

Can you tell me how i can prevent users to delete rows on google sheet

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

Whats the name of the song ?

@savisavitha5853 6 месяцев назад

The music is irritating .. due to high volume

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

I would like to know how to insert a row after either every odd or even rows, hahahaha

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

Blank rows

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

Or just sort the table and delete that block.

@dodgecarlincila879 Год назад

Hi Leila, I have a 5column x 100 rows. I would only like to remove rows that are completely blank and remain the rows that have atleast 1non-blank cell.

@dodgecarlincila879 Год назад

without moving the entry of the cells up or down 1 or two cells

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

So smart!! If Microsoft had a feature where you could hit ctrl+f and then search for "blank" and then it would highlight them and then we could delete them. That would save time.