Delete Column in Excel

In this blog post we will see how we can delete the columns in an excel sheet. There are various methods available in excel to delete the column. Let’s learn them one by one:

1. Using Mouse Right Click

2. Using Delete Command

3. Using Keyboard Shortcut

To learn these multiple methods to delete the column in excel we will the below dummy data which contains five columns A, B, C, D and E. There are random numbers listed in each column. We will learn how we can delete the “Column C” from this data by using each of the above mentioned methods.



Method 1: Using Mouse Right Click


This is the first method which we will learn to delete the column.

1. Select the entire column which we wish to delete (in our case we have selected “Column C”).



2. Press the Right Click button of your mouse which will show several options on screen. Please select “Delete” option from this.



3. Once we select Delete option, we can see that the data from "Column C" is now vanished, it means it is deleted.



Method 2: Using Delete Command


This is the second method which we will learn to delete the column.

1. Select the entire column which we wish to delete (in our case we have selected “Column C”).



2. Go to Home tab and select “Delete” command from cells group which will open 04 further options on screen. Out of these we have to click on option “Delete Sheet Columns” .



3. Once we select "Delete Sheet Columns" option, we can see that the data from "Column C" is now vanished, it means it is deleted.



Method 3: Using Keyboard Shortcut


This is the third method which we will learn to delete the column.

1. Select the entire column which we wish to delete (in our case we have selected “Column C”).



2. Press “Ctrl” key on your keyboard and hold this key and then press “-“ key.

3. With this we can see that the data from "Column C" is now vanished, it means it is deleted.


These are the various methods to delete the columns from excel sheet. Please mention your favorite method in comments section below.

Comments

Related Topics..

Fill Up, Down, Right & Left in Excel

Conditional Formatting:Highlighting Above Average and Below Average Values

Excel Shortcuts Ctrl A to Ctrl Z

How to Remove Duplicate Entries from Multiple Columns in Excel

Insert Object in Excel

Icon Sets in Conditional Formatting

Data Bars in Conditional Formatting

Conditional Formatting: Highlighting Top 10 Values in Excel

Insert Multiple Rows in Excel Based On Cell Value

Exploring Font Colors and Fill Colors in Excel