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.
How to Remove Column1 and Column2 in Excel: 4 Methods
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.
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.
- At first, select the columns you want to delete in this case we have selected Column1 and Column2.
- Then, press Right-Click and choose the Delete option.
- 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
- How to Remove Column Headers in Excel
- How to Keep Row Headings in Excel When Scrolling
- How to Change Excel Column Name from Number to Alphabet
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.
- Firstly, select the columns you want to delete.
- 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.
Read More: How to Rename Column in Excel
- How to Create a Double Row Header in Excel
- How to Promote a Row to a Column Header in Excel
- How to Make Multiple Sortable Headings in Excel
- Keep Row Headings in Excel When Scrolling Without Freeze
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.
- 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.
- After selecting the option, you will get the below result.
Read More: How to Change Column Headings in Excel
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.
- Initially, press Alt+F11 to open the VBA code window.
- Afterward, select Module from the Insert tab.
- 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
- Finally, you will get the desired result similar to the below image.
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.
Download Practice Workbook
You can download the practice workbook from here.
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. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.