Pretty sure this guy created Excel.

I don't use excel but im saving this

Just sort by blanks, highlight, batch delete. Done.

@coltonasdfasdf

2 ай бұрын

This works if you’re doing the work manually. But it doesn’t work if you use automation software because the computer can’t see where to delete without a value attached (like the column he creates)

This guy out here making people's life easier.

Awesome! Many thanks. You are best excel shorts!

@easy_sheets

10 ай бұрын

Thanks!

When the solution is way more complicated than the problem

This is the best subscribe decision I’ve ever made Obsessed w this channel ❤

Thanks. It's really helpful

I may be missing something but once you have the columns to see if a row is empty (the blank and 1 values) could you not just filter and delete it then

@easy_sheets

10 ай бұрын

Yes you can, if you don't want to remember keyboard shortcuts that's valid. I just include the shortcuts for those who want to know the fastest way!

Wow ,very smart way 😊

Wow. Awesome!

Nah I’m gonna stick to going through every column, thanks.

@youngthecub7490

10 ай бұрын

For real

@tubeo94

10 ай бұрын

Good luck with 30 thousand rows.

@DefinitelyNotAFerret

10 ай бұрын

I wish I could do that… but working with a database with thousands of information from 2009 to current day… 😅 would take WAY too long. I definitely bit off more than I could chew 😂

I use go to then special then check on blanks that would highlight all the blanks then right click and delete all . Thanks

Also you can concat the whole row and then filter out the blanks?

@JStephs1950

7 ай бұрын

That works and seems a lot simpler than the multi-step formula entry.

Thanks!

You can select Blank instead unchecking 'Text'

Just applay the "only blanks" Filter to all Collumns, CTRL-A, delete Columns. Way faster in this example

@mansooralt

10 ай бұрын

It will still leave blank columns... try it..

@JStephs1950

7 ай бұрын

@@mansooralt Isn't the point of the video to delete blank rows? I didn't see anything about deleting blank columns. The point is to get rid of records which do not contain any data. If you get rid of named columns, then you are getting rid of data categories which currently do not contain any data. If data later is acquired which should be stored in that named column, you will have an error if you try to enter it, because the column will no longer exist.

Very nice

Any excel course to enroll... really helps a lot in my career? Please advise me Sir

@easy_sheets

9 ай бұрын

I'm releasing a course next week!

Thanks

Use column filter, select 1, then delete blank rows?

I would use Power Query for this

Wow

Select all, find, go to special, blanks, click delete button

@easy_sheets

6 ай бұрын

The problem with this approach is that if there are any partially empty rows, it will delete those, messing up your data.

Why use an if statement when the counta will suffice already? Filter out non zero counts so only zero counts shown, then delete them all

@easy_sheets

10 ай бұрын

That works. The point of the IF is to allow us to select those rows with go to special so we can delete them quickly. You can still do it without but you'll need to filter, then select all the filtered empty rows, and delete them, then clear filter. So whatever you prefer. There's probably 100 ways to do the same thing.

Another video saved... Also a question.. How can I search for multiple cells with different data such as 123456a 75698b 32454c etc.. they also are in multiple colums and rows at the same time. is there a way to select all of those via some sort of search function?

@JudgeDreddMegaCityOne

10 ай бұрын

Ctrl+f

@Amducyas

10 ай бұрын

@@JudgeDreddMegaCityOne I can't search for them at the same time.. I have to search for each cell separately and I have 1433 cells to ctrl + f

@JudgeDreddMegaCityOne

10 ай бұрын

@@Amducyas vlookup?

Great tip. But shouldn't there be a button for it?

@easy_sheets

9 ай бұрын

There should be but there isn't!

Or use power query to delete empty rows

How do you quickly apply this formula to every row. My document has 50,000 rows. When I do exactly what you do it doesn’t fill the formula for the rest and flash fill isn’t working for formulas

@coltonasdfasdf

2 ай бұрын

Manually inputting the formula in each row would be just as tedious (or more)as finding and deleting each blank row

Thanks for the videos!! If I want to extract the geodata ( longitude and latitude) from an address that have (city, street and street number) is it possible to do it in a function. I used to copy them from google maps!😐

for some reason, doing it this way give me anxiety

If I have 50 columns, I'm doing something incredibly wrong though, aren't I?

@quantumchaos

8 ай бұрын

Not if you're dealing with an extremely large data set and don't want to have a bunch of cross referential tables. I've got one with 120 columns currently, and that's still referencing 8 other tables to get all the data I need for it.

@JudgeDreddMegaCityOne

8 ай бұрын

@@quantumchaos That sounds like a nightbare

How do you create a formula for a cell but it suddenly applied to the whole table? Did I miss anything? :O

@easy_sheets

10 ай бұрын

Because it's a table not a range. tables will do that automatically.

@ahmadfikri5032

10 ай бұрын

@@easy_sheetsI see, thank you! I’m new to this. Really appreciate you not dismissing my seemingly dumb question 😂❤

Or use power query

Would this work for 2013?

Hmm

Power query remove blank rows

Is this in your course?

That’s kinda longer than just using filters for that small data set

@JStephs1950

7 ай бұрын

It's an example. It's less time-consuming if you have a large dataset.

I have time and I like deleting one by one. Why do you make me feel like I am silly?.

got

Ugh this 💩is hard 😮

Jai shree ram jai hanuman baba 🚩🚩🙏🙏🌼🌼🌻🌻🌹🌹🥥🥥🌺🌺🍌🍌

How do you even learn all of this dude. You don't sound like you're older than 30. Having you been putting in 40 hours a week learning excel since middle school??

@easy_sheets

10 ай бұрын

Haha, i used to be a Data Analyst, and spent every workday in Excel. Also took a bunch of training.

Sir give me practice file for your videos

Why don’t you just select the whole thing ? Then Ctrl G and ALT S : select blanks and then delete…

@easy_sheets

8 ай бұрын

Because that messes up the data when you have partially empty rows

@NikhilKumar89

8 ай бұрын

@@easy_sheets Yeah ! I realised that a while later. Thank you !!! Love your channel.