Delete Empty Rows with these Excel Shortcuts #shorts

Quickly remove or delete blank rows in Excel. Don't highlight the row and delete from the menu. That can take forever. Instead use quick Excel keyboard shortcuts to automatically select and remove empty rows in your data.

🚩Let’s connect on social:

👉 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!

#Excel #shorts

[yuniar]

For me, i use filter. Choose the blank one, then delete it.

[adpatza]

Leila, 20+ years user of Excel here and this is new for me. Thanks! I also usually used a filter, but having options is great.

[adambathe]

I just sort a column A-Z
Boom, all blank rows are at the bottom of the sheet.

[Secretgeek]

When you bring up the special menu you can press 'k' to select 'Blanks'.

Saves a couple of button presses. 😊

[henryadams]

Do you know how many years I've been formatting the data as a table, then filtering columns based on empty cells, then deleting those, and finishing by unfiltering to get rid of those empty rows? This is so much better, what you've shown us today. Thank you!

[drzpapi]

This works well as long as the whole row is empty.
You could always highlight column A only, add a filter, and then filter on blanks. This way allows you to see if there's data in a cell further down.
Delete and vuala.

[ObuLg]

Had no idea about CTRL minus, Thanks!

[tajmohammad]

Thanks a lot for giving us such information!

[pipagamer]

thank you very much, saved me a bunch of work

[MadsFeierskov]

I typically use F5 instead of Ctrl+G. It's the same shortcut.

[nandinisingh]

Very useful formula for large data sheet👏

[rogue]

That is delete cells, not rows. If you have in the blank row a cell filled in and you use this, you will get a messed up dataset.
What you can do is to select the important column, select blanks through this method, then hit shift+space, then delete ctrl+minus. It would be useful to check bottom right after you selected the blanks if you have count (only one cell won't be shown as count 1)

[dilinacherath]

You save my whole life.. thank you very much for that ❤❤❤

[nonopanzu]

Wagwan Leila.
I use Excel for long time but I didn't know that trick. Thanks!
Jah Bless.

[dhruvakumarmohan]

WOW.. SO EASY ... NEED MORE SIMPLE TRICKS LIKE THANK YOU...

[CharanyaCI]

Thanks a lot . It helped me a lot on time

[hhn_enthusiast]

You are literally changing my life right now, I'm in love 😍😍

[lgvdbroek]

Hi Leila, its an old one, but still a good one.
Many probably didn't know this yet, given the reactions 😂
Thanks for sharing again. 👍

[HalpPlsxx]

This saved my life. I am currently working on a spreadsheet that I clean and filtered recently for my organization. Thanks alot!

[LHCB]

There should be a caveat that this only works if there are no blank cells in a non-empty row. It can super mess up a file if there is. Nice trick, though!