How to Remove Column1 and Column2 in Excel (4 Easy Methods)

This tutorial will demonstrate how to remove column1 and column2 in excel. When dealing with large numbers of data, it is necessary to remove unnecessary data from the sheet from time to time. Otherwise, this data can create confusion. So learning to remove columns in an excel file is essential.


Download Practice Workbook

You can download the practice workbook from here.


4 Easy Methods to Remove Column1 and Column2 in Excel

To understand easily, we’ll use a sample dataset as an example in Excel. For instance, we have Column1 (Names) in Column B, Column2 (Working Hours) in Column C, and Column3 (Daily Pay) in Column D. We will use this dataset to describe all the methods below.

Methods to Remove Column1 and Column2


1. Remove Column1 and Column2 in Excel with Context Menu

Our main goal is to remove Column1 and Column2 from Context Menu. Applying Context Menu is the easiest way as it can be done within clicks. The process is very efficient to use in every case. The steps of the methods are described below.

Steps:

  • At first, select the columns you want to delete in this case we have selected Column1 and Column2.

Column1 and Column2 in Excel with Context Menu

  • Then, press Right-Click and choose the Delete option.

Column1 and Column2 in Excel with Context Menu

  • After that, a Delete window will open on your screen.
  • Select the Entire Column option and press OK.

  • Finally, you will get the result like the below image.

Read More: How to Hide Row and Column Headings in Excel (2 Suitable Ways)


2. Using Keyboard Shortcut to Remove Column1 and Column2

If you are comfortable with the keyboard, then a keyboard shortcut is available for you to remove Column1 and Column2. This method is described below.

Steps:

  • Firstly, select the columns you want to delete.

Keyboard Shortcut to Remove Column1 and Column2

  • Secondly, press Ctrl + ’-’ both buttons at the same time to open the Delete option.
  • Thirdly, choose the Entire Column option and press OK.

  • Lastly, you will get the following result.

Keyboard Shortcut to Remove Column1 and Column2


Similar Readings


3. Remove Column1 and Column2 by Excel Ribbon

We can also remove Column1 and Column2 using the excel ribbon tab. Using Excel Ribbon to remove Column1 and Column2 is also a very useful way as it is just in the upper portion of the excel file. To remove columns using this method, you have to follow the below steps.

Steps:

  • At the very beginning, select the columns you want to delete and go to the Delete option in the Home tab.
  • Next, select the Delete Sheet Columns option.

Remove Column1 and Column2 By Excel Ribbon

  • After selecting the option, you will get the below result.

Remove Column1 and Column2 By Excel Ribbon


4. Apply VBA Code to Remove Column1 and Column2

If any person wants to know how the process is actually working in excel then the best way to learn is by using VBA code. In this case, we will show you the steps.

Steps:

  • Initially, press Alt+F11 to open the VBA code window.
  • Afterward, select Module from the Insert tab.

VBA Code to Remove Column1 and Column2

  • Then in the window insert the following code.
Sub delCol()
    Dim sourceSheet As Worksheet
    Set sourceSheet = Sheet5
    sourceSheet.Columns("B:C").EntireColumn.Delete
End Sub

VBA Code to Remove Column1 and Column2

  • Finally, you will get the desired result similar to the below image.

Read More: How to Change Column Header Name in Excel VBA (3 Examples)


Things to Remember

  • The VBA method is the toughest among all the methods. So, it is recommended to use methods from the first three.
  • In the case of the VBA code in the last method, the sheet number must be marked properly otherwise the code won’t work.

Conclusion

Henceforth, follow the above-described methods. Thus, you can learn how to remove column1 and column2 in excel. Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles 

Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo