3 Right Ways to Delete Blank Columns in Excel

In this video, I will show you 3 different methods you can use to quickly delete blank columns in Excel.

I am also going to cover one additional method that works well but needs to be used cautiously, as it can lead to issues

00:00 Intro
00:25 Delete Blank Columns using SORT method
03:12 Delete Blank Columns using Find & Replace method
05:55 Delete Blank Columns using VBA
10:07 Delete Blank Columns using Go To Special (NOT recommended)

------------------------------------------------------------------------------------------------

Below is the VBA code I used in the video:

Sub DeleteBlankColumns()
Dim EntireColumn As Range
On Error Resume Next
Application.ScreenUpdating = True
For i = Selection.Columns.Count To 1 Step -1
Set EntireColumn = Selection.Cells(1, i).EntireColumn
If Application.WorksheetFunction.CountA(EntireColumn) = 0 Then
EntireColumn.Delete
End If
Next
Application.ScreenUpdating = True
End Sub

------------------------------------------------------------------------------------------------

#Excel #ExcelTips #ExcelTutorial

[GJK]

Your videos and mails are always soooo helpful. Thanks, Sumit!

[timmyvawwter]

You're an excellent Excel master!

[redhaal-obaidy]

Thanks for posting these useful information
I actually do them manually depending on different datasets that I need to keep the blank columns…
But thanks, there are some keyboard shortcuts that I can certainly use in my work.

[bhaumikder]

I have watched so many videos which were repeating the same go to method but this one gave me the ultimate solution.
Can you please provide the VBA code to delete the blank rows?

[sydneychidambaram]

Thank you for these excellent videos, you explain the functions simply and we can understand it very easily. simply Awesome

[ShpinTwin]

This video is so helpful! Thank you! Any tips for removing columns where there is a heading but the rest of the column is empty?

[canirmalchoudhary]

Very very detailed and lovely explanation

[deepanshuwadhwa]

Very informative. Thank you so much for helping.

[BenDieselBasicAutomotive]

Thank you very much for the knowledge gained..

[patwaripiyush]

Thank you sumit you dont know you have made my life so much simpler i need your help in devoloping an if condition in power query if you can help please

[zamarshaikh]

Hey Thankyou So much, That was really helpful appreciate your Good work!

[vivekjoshi]

Could you please guide me on what tool you use for recording while speaking and zooming in for tutorials?
I am looking to create some content and looking for ideas. Thanks & lots of love!

[nadermounir]

Thank you very much for your hard work. Great video 📹 👍

[tinboy]

Hi, could you please share the code to add sensitivity label to bulk emails triggered from excel file. Would appreciate your help, thank you in advance 😊

[tarique]

Sir I'm binge watching your Excel dashboard course nowadays but the download files you given in description is not able to download please make it available

[nitishgoyal]

Sir there is a Playlist for add. Topic Covered by You that's not showing up now please Help

[payaljain]

Hello Sumit, when are you going to upload office 365 most important excel formulas? Pleaseee make a long video with examples....i am looking forward for the same desperately... Thank u....

[azeezsid]

Thanks 👍 Sir.... Pls Share your Bio .on YouTube

[NaveenKumar-trxo]

You are clicking on entire colum, and saying entire row in vedio

[scottwilkerson]

Why would I need a 13 minute video to delete a single blank column between six columns? I could just highlight the column, right-click, delete. I'm trying to get rid of the thousands, literally INFINITE columns to the right of my data. Why can I not find a single video on how to do this, and why does Excel make it nearly impossible to do unless you are an Excel MASTER???