Excel How To Quickly Delete All Blank Columns In Excel 3 Ways - Episode 2641

Microsoft Excel Tutorial: Three ways to delete hundreds of tiny blank columns in Excel.
Welcome back to another MrExcel tutorial! In this video, we tackle a common Excel dilemma: deleting 365 blank columns swiftly. Hailing from Green Bay, Wisconsin, our viewer shared their data download challenge, and we're here to provide not one, not two, but three lightning-fast solutions.
First up is the Ctrl+Y or F4 trick, a nifty shortcut that repeats the last command. Watch as we demonstrate how to breeze through column deletion with just a few keystrokes, saving you valuable time.
Next, we delve into the power of Excel's Go To Special feature. Learn how to select all blank cells in a flash, followed by a quick deletion process. Despite a brief wait, this method proves significantly faster than manual deletion.
But wait, there's more! Our third method involves a clever sorting technique, perfect for datasets with chronological data. Witness how a simple left-to-right sort eliminates blank columns efficiently, leaving your spreadsheet tidy and optimized.
Which method is your favorite? Do you have an even faster solution? Share your thoughts and techniques in the comments below! Let's exchange Excel wisdom and explore the possibilities, whether it's VBA magic or Power Query prowess.
Don't forget to Like, Subscribe, and Ring the Bell to stay updated on more Excel tips and tricks. Have questions or suggestions for future tutorials? Drop them in the comments section-we love hearing from you!
Thank you for tuning in, and until next time, happy Excel-ing from MrExcel! 📊✨
To download the workbook from today: www.mrexcel.com/youtube/DnLUr...
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-...
#excelhacks #excelshortcut #excelchallenge #shortcutkey #excelsort #excelgotospecial #excelsequence #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
Table of Contents
(0:00) Problem Statement: How to delete 365 blank columns
(0:24) Deleting columns one at a time would be tedious
(0:34) Using F4 key in Excel to repeat last command
(0:53) Go To Special Blanks and then Delete Column
(1:46) Excel Sort Left to Right
(2:30) Repeating the Sort method and adjusting column width
(3:10) Would not work with text dates
(3:20) Have something faster?
(3:32) Like, Subscribe, and Ring the Bell
This video answers these common search terms:
how to quickly delete blank columns in excel
excel tips for removing empty columns fast
mrexcel tutorial: delete 365 blank columns in seconds
fast excel tricks: removing empty columns effortlessly
efficient ways to delete blank columns in excel
excel column deletion hacks: save time with mrexcel
quick methods to remove blank columns in excel
excel tutorial: deleting empty columns made easy
speed up your workflow: delete blank columns in excel
excel column cleanup: fast solutions with mrexcel

[@antique-bs8bb]

I did once do something very similar to delete rows, maybe 20 years ago. I set up a macro to delete current row and then one row down (columns and across for you)
That meant the 700 keystrokes your first method involved fell to around 350. I was pretty proud of myself then.
Power Query - Transpose, - sort or remove blank rows - Transpose back again - load would be reasonably quick & simple and (Sledgehammer got there a couple of weeks ago I see)

[@uignireddngfiurdsgfiurdse]

I remember seeing your video on the topic of revenue bridges from 14 years ago. It gladdens me that you're still uploading.

[@Omarnfm]

Super Thanks

[@jegane]

Instead of selecting whole row, we can select Ctrl + Shift + End then Go To Special > Blanks > Delete Columns

[@alfonsorodriguezsandias8142]

Hello, maybe you would prefer made it with formulas. You could use this one: TRANSPOSE(FILTER(TRANSPOSE(rangeofdata);CHOOSECOLS(TRANSPOSE(rangeofdata);1)""))

[@GeertDelmulle]

Here's even one better:
FILTER(range,TAKE(range,1)"")

[@alfonsorodriguezsandias8142]

@@GeertDelmulle , Of Course!!!

[@MrXL]

These are both great ways! Thanks!

[@ranjithkyatham1918]

Hi Mr.Excel, Thank you for making great videos,
I have one challenging and unresolved task, help me, I have large data in one column which includes negative and positive amounts also decimals, So i want to eliminate all the cells combinations which are equal to zero (0) and i would like remain only the cells which are relevant to actual net SUM total value. used Solver and other VBA coded =FindAllCombination formula from the internet, but taking lot of time to respond please help me..

[@sledgehammer-productions]

Powerquery:
0. import
1. transpose table,
2. select first column, filter out 'empty',
3. transpose again.
Kind of quick and especially dirty, but if it's a one off, no problem 😀

[@MrXL]

Love this!

[@Your-L0ver]

Nice.. but superfast technique will be ctrl+A and press del 😂😂😂