Excel - Quickly Deleting Every Other Column - Episode 2153

3,029 views · Published 5 October 2017 · 1:53 · Indexed 4 November 2026

Channel: MrExcel.com · 2017 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Quickbooks loves to insert tiny column between the columns. 
To speed up the process, delete first column, then use F4 for Fast Re-Do
Better: Select a row. Go to Special, Blanks, Ctrl+-, Entire Column, OK
Thanks to Carmella in Green Bay

Welcome to another episode of MrExcel's podcast, where we share tips and tricks to help you become an Excel pro. In today's episode, we will be discussing a common issue that many Excel users face - deleting blank columns. 

During one of my seminars in Green Bay, Wisconsin, a participant asked if there was a quick way to get rid of those tiny blank columns that often appear between columns. And the answer is yes, there is! 

My go-to method for deleting blank columns is to delete the first one using the ALT+E, D, C, OK shortcut. But thanks to a clever tip from Carmella in the audience, I have discovered an even faster way to do this. 

Instead of manually deleting each blank column, simply select the entire row and use the FIND & SELECT, GO TO SPECIAL function. You can access this using the keyboard shortcut CONTROL+G for GO TO, ALT+S for Special, and then K for BLANKS. This will select all the blank cells in that row, making it easy for you to delete them in one go. 

But here's a pro tip from Carmella - make sure to choose a row where all the cells are filled in. If there is any data missing, this method won't work. For more tips like this, check out my book "Power Excel With MrExcel" by clicking the "i" on the top right-hand corner. 

So there you have it - a quick and efficient way to delete those pesky blank columns in Excel. I hope this tip saves you time and frustration in your future Excel projects. Thank you for tuning in, and don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you next time for another netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

#excel
#microsoft
#microsoftexcel
#exceltutorial
#exceltips
#exceltricks
#excelchallenge
#evergreen
#excelgotospecial

This video answers these common search terms:
how to delete multiple blank columns in excel
how to delete columns in excel quickly
how to delete blank columns excel
how to delete blank columns in excel
how to delete blank columns in excel sheet
how to delete blank columns in excel shortcut
how do you delete blank columns in excel
how to delete all blank columns in excel
excel how to delete blank columns
how to delete extra blank columns in excel

Table of Contents:
(00:00) Deleting Blank Columns in Excel
(00:10) Fast way to delete blank columns
(00:20) Using F4 to repeat last command
(00:30) Alternate tip for selecting and deleting blank columns
(01:00) Using FIND & SELECT, GO TO SPECIAL to delete blank cells
(01:30) Clicking Like really helps the algorithm

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153978/

More from this channel