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

[@uignireddngfiurdsgfiurdse]

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

[@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)

[@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 😂😂😂