By |10 Oct 2022 at 7:08 PM
How to apply vlookup in excel: Alternatives to using vlookup

Deleting blank columns in Microsoft Excel can be a time-consuming task, especially if there are hundreds or even thousands of columns. Fortunately, there is a way to delete all blank columns in just a few clicks. In this blog post, we will show you how to delete all blank columns in Microsoft Excel.

Deleting blank columns manually

To delete blank columns manually, first select the entire column by clicking on the column header. Then, right-click on the selected column and choose “Delete” from the menu. This will delete the selected column and shift all other columns to the left.

Deleting blank columns using a macro

Microsoft Excel provides a built-in macro that can be used to delete all blank columns in a worksheet. This macro will loop through all the columns in the worksheet and delete any column that is entirely empty.

To use this macro, simply press Alt+F8 to open the Macro dialog box. Then, select the “DeleteBlankColumns” macro and click Run. Excel will then delete all blank columns from the active worksheet.

How to delete all blank columns in Microsoft Excel: Check Steps

  1. Select the data range first, then press F5.
  2. Next, select ‘Special’.
  3. Next, choose ‘Blanks’ from the menu.
  4. Press ‘OK’ (This selection will ensure that all blank cells are selected in the targeted range).
  5. Select the ‘Home’ tab.
  6. Pick ‘Delete’ from the drop-down option in the ‘Cells’ tools section.
  7. Click ‘Delete’ Cells.
  8. To remove and rearrange columns, choose Shift cells left.
  9. Press ‘OK’.

How to get Barbaric Rider Bundle (Garena) and Skater Gadget Backpack in new Free Fire MAX

How to Use Google Password Manager on Android

How to Change Facebook username on mobile, or PC

How to change Display and Audio Language on Netflix? Check Steps

How to Make Your Android device as Private as Possible

How to make a WhatsApp Pay transaction?


Microsoft Excel is a powerful tool for managing data, but sometimes you can end up with blank columns that you don’t need. In this article, we showed you how to delete all blank columns in Microsoft Excel in just a few simple steps. If you have any questions or comments, please leave them below.