Delete Empty Rows with these Excel Shortcuts #shorts

Thanks alot @LeilaGharani
This has helped me super quick as was stuck and this made it SUPER FAST
Really appreciate this short vid ❤👍🏻

This is great!

thanks

Super trick

Thank youuu❤❤❤

You go too fast

Wow very usefull thanks a lot

Not working on large data

Worked for me, thanks

Hi mam, how to add blanks columns when we have rows in 1000

thanks..made my time saver

tks

Thank You

This has been very helpful

Thanks, God bless you 🙏

Thank You so much!!

AWESOME

thank you this is great!!!

Cant do on excel mobile

It works! Oh, this is so awesome!! Thank you for sharing!

This did not work for me

I love you. 🎉

This a good one !!

Select all, CTRL+SHIFT+L, Sort column B, CTRL+SHIFT+L, Done

@Leila Question: What if the entire row is not empty? Wouldn't this mess up the data? Is there a workaround?

I get the error " cannot use that command on overlapping selections"

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

thank you

Use shift+space before ctrl+minus
Thats highlights the complete rows and you dont haf to maually shift cells up 😉

F5

Great 👍👍

Filter blank and and control minus much better

I need to only remove the blanks if everything in that row is blank. Not ever blank cell ... thoughts?
Sorting doesn't work as column "a" might be blank in row 3; but it has value that I need in row 3 column X,Y,Z or visa versa.

Thank you❤

Can we do this to columns also🤗

Thank you

Super !

Select range, Ctrl+T, filter, delete works too

In the Same Row, if some cell are blank then this formula also delete this row.. in above, If we delete the order ID (cell) of Jack Potter then by using above formula we will lost entire row of this...

Easier way: filter blanks, remove all rows, unfilter. Done.

I have documents that often have a count, and i need to convert that count into new lines and make them x of y. is there an way to do this with a formula?

learn ctrl+-

I used this in a macro to select & delete objects years ago. Initially I was copying and pasting from a bank file which had a bunch of check boxes which this helped to get rid of.

Is filter for an important black cell and delete that way. Often times my data may have a blank cell in an important row and celebrate blanks like this would select those blank cells also then confuse the system on what I was doing.

So, what we need PC's!!!!!!!!!!!!

NOT a perfect method. If I have cells in a row that are blank, data from rows below move up to blank cells. Screwed up the list!
CORRECT METHOD- I select the whole tabIe, sort by primary key ascending order, then all blank rows move down !

please don't do short - do normal videos to let us put/save them into our watching lists!

Now i need this

👏🏿👏🏿👏🏿👏🏿