The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Then all selected columns are deleted at once.ģ0-day) of this utility, please click to download it, and then go to apply the operation according above steps. Right click the column header of selected column, and then click Delete from the right-clicking menu. Click the OK button in another popping up dialog box, then the columns which contain specified header value are selected immediately.Ĥ. In the Select Specific Cells dialog box, select the Entire column option in the Selection type section, and in the Specific type drop-down list, select Equals option, then type the header value in the following box. Select the range which contains the columns you need to delete, and then click Kutools > Select > Select Specific Cells.

Please do as follows.īefore applying Kutools for Excel, please download and install it firstly.ġ. With Kutools for Excel’s Select Specific Cells utility, you can easily select all columns which contains the certain header value first, and then delete these selected columns at once. Press the F5 key to run the code, the entire column with a header equals to the specified text will be deleted immediately. VBA code: delete entire columns based on header value Sub DeleteSpecifcColumn() And then copy and paste below code into the Module window. In the Microsoft Visual Basic Application window, click Insert > Module. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic Application window.Ģ. You can delete entire columns based on header value with VBA code.

In this tutorial, we will show you methods of deleting entire columns based on header value in details.ĭelete entire columns based on header value with VBA codeĭelete entire columns based on header value with Kutools for Excel For example, you need to delete all columns which contain value “old” in the header. In many cases, you may need to delete the entire columns based on header value in Excel. How to delete entire columns based on header value in Excel?

Base de datos metatogger