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

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)

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

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

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

Super Thanks

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..

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

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 😀