Delete Empty/Blank Rows in Google Sheets (2 Easy Ways)

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Google Sheets topics you want me to cover in future videos.

Nice video. Be forewarned; does not work with sheets containing vertical merges.

Thanks very much!

The blanks option doesn't show up.

Thank you, mate. Great video - very helpful.

Excellent way of explanation, very simple and to the point. Thank you very much.

How to do in app

Concise, clear, focused and helpful. Well done. Thanks.

You rock!

Great help, thank you!

Life saver! Thank you

what about if i have a lot of cells i can not select all

the helper row trick is absolutely based. thank you spreadsheet king!

How to do this automatically???

Thank you so much

Thanks for the video. I'm looking for a way to delete blank cells in a column and shift the corresponding rows left. I used the filter to see only the rows with blank cells and then select them all and select "Delete and shift left." However, unlike the situation in this video it deletes cells that are not visible in the filter.

Actually, I just thought that it may have been because I was using Filter View instead of an actual Filter because I'm collaborating. I'll leave the question here either way, but going to try that when I get a chance. That may have been the difference. Thanks, either way.

EDIT/UPDATE: Unfortunately that did not work either.

how to delete empty cells?

Hi Sumit

I'm in a very big problem with data duplicity.
We have near about 30k data.
In the sheet, we have Phone 1, Phone 2, Phone 3, Phone 4, Phone 5 columns.
I need to remove the duplicate number from all the columns having blank space without disturbing the data from respective rows.

How do I delete an empty column that is showing on the second page? I have 6 columns of content that I want to print but in print preview it shows a 7th column. I tried moving the 7th column to the left in the break editing view but it doesn't seem to move. Hopefully, that makes sense. :) Thanks in advance for your help!

Something so hard you have made very simple bless your heart ... Thanks

great instructor, thanks so much

Thank You For this Video, It Became Very Helpful.

Omg thanks a lot 🙏

Bruh, never in my life have I've been so happy to get my question answered so thoroughly and concisely! Thanks Spreadsheet God, thank you!

Thank you very much for the video. I have a question. Is it possible to configure in a way that every time I press down arrow the cursor goes to say 10 cell below in spite of just going to one cell below? Reason I want to do this is the facilitate the accessibility of the sheet with say 500 rows of data. If you have any other suggestion which my speed up the accessibility, I would appreciate that too.

The first method is good!

Thank you so much 💗🥰!!!

Short sweet and to the point- thanks!

thanks mate

this is the worst solution

Brilliant. Thank you!

Nice video. Couldn't you have used the helper column for the sorting without first using the name column to save time?

Great video!

thanks

what a load of crap...

Very clear explanation👏👏

bro u r amazing