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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920