Select all the data by selecting the required rows and columns and press f5 from the keyboard. Open the required excel where you want to delete the blank columns. Web here are the steps to add the macro to your excel: Press ctrl + f to open the find and replace dialog box. The simplest way to delete blank columns in excel. Select all the cells in the helper row. Press f5 to run the. Deleting blank columns in excel after selecting manually using ctrl key. In the find and replace dialog box that opens, do. On the menu bar, click insert > module.
Select all the cells in the helper row. Select all the cells in the helper row. Press alt + f11 to open the visual basic editor. At first, we select the first blank column >> press the ctrl key >> select another blank column. Select all the data by selecting the required rows and columns and press f5 from the keyboard. Press ctrl + f to open the find and replace dialog box. Deleting blank columns in excel after selecting manually using ctrl key. Open the required excel where you want to delete the blank columns. Remove blank columns by using a formula with find and replace. On the menu bar, click insert > module. If there are a few blank columns that are in the working range, we.
