How to Delete Empty Columns with Header in Excel (4 Easy Ways)

The article will provide you some quick tricks to delete empty columns with header in Excel. While working on an Excel worksheet, you may need to deal with many things. One of them may be deleting empty columns with headers. I have added four suitable methods here. You will find the necessary images attached with every step. Hopefully, you will find the processes interesting.


Download Practice Workbook

Please download the workbook to practice yourself.


4 Effective Ways to Delete Empty Columns With Header in Excel

Here is the dataset I am going to use here. The dataset has three columns and one empty column. The columns are B, C, D, and E called ID, Products, Price, and Delivery Date. Here, the column named Price is an empty column. I need to remove this column from the data table. I will show four methods here to Excel delete columns with header. Follow the procedures step by step.

dataset of excel delete empty columns with header


1. Deleting Empty Columns With Header by Excel Editing Tools

This is the first method of this article. I will show you here the process of Excel delete empty columns with header. Here, in the dataset, you will find the Price column is empty. Follow the procedure step by step. Hopefully, this will increase your Excel skill.

Using Excel Editing Tools to excel delete empty columns with header

Steps:

  • Select the D column first by clicking where the arrow sign is placed.

Using Excel Editing Tools to excel delete empty columns with header

  • Then, rightclick on the column D.
  • Consequently, a pop-up window will be seen.
  • After that, select the Delete option.

Using Excel Editing Tools to excel delete empty columns with header

  • Hence this command will delete the entire D column.

Using Excel Editing Tools to excel delete empty columns with header

This is how you can delete empty columns with header in excel. This method is the most common and easiest way of deleting columns.

Read More: How to Delete Columns Based on Header Using VBA in Excel


2. Implementing Find & Search Option

This is the second method of this article. I will use the search and find option here to delete empty columns with header in Excel. This is also a short process. You can see the Price column is empty here. I will delete this column. I hope you will enjoy the whole process. Follow the procedures step by step.

Using Find and Search option to excel delete empty columns with header

Steps:

  • First, go to your Home tab in your Toolbar.
  • Then select the editing option.
  • After that, select the Find and Select
  • Meanwhile, a window will pop up. You will find the Go to special option there. Click on it.

Using Find and Search option to excel delete empty columns with header

  • Then, in the Go to special option, select the Blanks option. The blank columns of the data table will be selected.

Using Find and Search option to excel delete empty columns with header

  • Right click on the selected cell.
  • Then, select the Delete option.

Using Find and Search option to excel delete empty columns with header

  • Meanwhile another window will pop-up. Select the Entire Column option from there.

Using Find and Search option to excel delete empty columns with header

  • As a result, by this command, excel will delete the entire D column.

Using Find and Search option to excel delete empty columns with header

This is how you can delete empty columns from the data table manually.

Read More: Can’t Delete Blank Columns in Excel (3 Problems & Solutions)


Similar Readings


3. Using Keyboard Shortcut

This is the third method of this article. However, I will use a keyboard shortcut here to delete the empty cell with header in Excel. Follow the following steps.

Steps:

  • First, select the whole D column as it has the empty cells.

Using Using Keyboard shortcut to excel delete empty columns with header

  • Then press the Ctrl and buttons one after another.
  • As a result, you will see the whole column D entirely deleted and the column E replaces the position.

Using Find and Search option to excel delete empty columns with header

This is how you can delete empty column with header by using keyboard shortcut.

Read More: How to Delete Extra Columns in Excel (7 Methods)


4. Applying Excel VBA to Delete Empty Columns with Header

This is the fourth method of this article. You can delete a empty column by inserting a VBA code. However, this is a smart process. This method can increase your Excel skill hopefully. Follow the following steps to be familiar with the procedures. You can also see the images attached with the steps for better understanding.

Steps:

  • First, press the Alt+F11 to open the Microsoft Visual basic for Applications

  • Open a new module and write down the following code.

Sub MacroToDeleteEmptyColumns()
Dim sS_xEnd As Long
Dim sS_K As Long
Dim sS_xD As Boolean
On Error Resume Next
sS_xEnd = Cells.Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
If sS_xEnd = 0 Then
MsgBox "No data is found on """ & ActiveSheet.Name & """ .", vbExclamation, "Deleting columns with headers"
Exit Sub
End If
Application.ScreenUpdating = False
For sS_K = sS_xEnd To 1 Step -1
If Application.WorksheetFunction.CountA(Columns(sS_K)) <= 1 Then
Columns(sS_K).Delete
sS_xD = True
End If
Next
If sS_xD Then
MsgBox "Blank and columns with headers are deleted.", vbInformation, _
"Deleting columns with headers"
Else
MsgBox "There is no Columns to delete.", _
vbExclamation, ""
End If
Application.ScreenUpdating = True
End Sub

Here, we declared some variables in the VBA code to identify the columns with empty cells and used the If Statement to apply some condition to detect those empty columns.

  • Then, after running the code, you will find the following result.

This is how you can use a VBA code to delete empty columns with header.

Read More: VBA Macro to Delete Columns Based on Criteria in Excel (8 Examples)


What to Do If Deleting Empty Columns Does Not Function in Excel

Sometimes deleting empty columns does not work as the column is not empty actually. May be the column looks like empty. Because sometimes, some characters cannot be visible in Excel cells. To detect the culprit cell, you need to follow the procedures given below.

Steps:

  • Select the first cell of the column first.

  • Then, press Ctrl and the Down arrow button simultaneously.
  • If you see this command does not select all the empty cells below the first one, you will know that there is one cell which has invisible data and it’s blocking the command to select other empty cells. Here, the D6 cell is not empty as the cells below it cannot be selected.

This is how you will detect the empty-looking cell but not empty.

Read More: [Solved!] Can’t Delete Extra Columns in Excel (3 Solutions)


Things to Remember

  • You should bear in mind that every empty looking columns must be empty for deleting the cells.

Conclusion

In this article, I have tried to explain the procedures of Excel delete empty columns with header. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. Additionally, you will find such interesting blogs on our website Exceldemy.com. Moreover, I hope you have enjoyed the whole tutorial. However, if you have any queries, feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo