Excel - How to Quickly Delete All Blank Columns in Excel - Episode 2171

[@64mustangfan]

Thanks! Even old time Excel users like myself miss some of the very useful shortcuts, especially if you never needed them before! 👍

[@scottwilkerson1208]

I've got about thousand columns to the right of my data. Anyway to get rid of those? Your methods above do not work.

[@alirezamogharabi8733]

Thanks a lot Bill, please make a video about custom table formatting or modifying existing formats. thanks.

[@excelisfun]

Love the Sort to Delete : )

[@lynnmichalski2729]

Saved me so much time!

[@Videokeys]

how to delete blank columns if its in table format? this only applies if the cells aren't formatted table; please help, thanks in advance!

[@MrXL]

Thanks for posting this comment.
Before this comment, I hated Tables almost as much as I hate merged cells.
I never realized that "Format as Table" turns off Left to Right sorting (from 2:13) in the video and also turns off Delete Columns.
In the lead-up to Office 2007, the Excel team realized that Tables could not be finished in time and wanted to rip them out of the product. But it was too late, there wasn't time to remove all the code. Office 2007 shipped with Tables in their broken state. Then a reorganization sent the Tables team to other departments and now, 16 years later, we are still left with this travesty of a feature.
My only advice is to select a cell in the Table. Go to Table Design tab in the Ribbon. The 3rd command in the second column of icons is "Convert to Range". Use this to convert to a regular range. Use one of the two methods in this video. Then, if you need to, make this into a table again.

[@anoopvasudevan509]

Wonderful, thank you.

[@DougHExcel]

Thanks for the sorting tips!

[@ismailismaili0071]

It's just OMG thank u Mr. Bill love u

[@kiranraika4540]

You talk a lot and but your work is excellent
It would be very nice if you finished your video in 1min instead of 5min ❤ see from the audience perspective as well

[@semperdiscendum7439]

Awesome! Thank you! 👍👍

[@palakodetibangarurayudu9686]

Thank you

[@ashaydwivedi420]

Omg 8th view 1st comment 1st like

[@krn14242]

WOW... Can't even call that a data set. Mike Girvin is cringing I'm sure. Great trick to delete all columns though.

[@vfran838]

This is great but goes too fast.

[@MrsDotWhit]

Way too fast. Sorry

[@solutionsaec9129]

Your speaking too fast for a real novice to follow

[@amirfadhly6608]

True, I dom't like that.