Delete Column in Excel

By
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.
Microsoft Certified Excel Expert, Enthusiastic to teach excel tricks and basic excel concepts which will help to save time and efforts in our daily office work.

Comments

Post a Comment

Related Topics..

Fill Up, Down, Right & Left in Excel

By
Image
Excel has many great tricks which can help us to save our time while working on big data. In this blog post we are going to see one of those tricks where we can fill the data to the upwards of the selected cells, to the downwards of the selected cells, to the right of the selected cells and to the left of the selected cells. There are many situations where we may need to copy the data from selected cell to the upward, downward, left and right cells. But how can we do so?? In excel we can do so with the help of “Fill” command. This command we can found in: Home Tab --> Editing Group --> Fill Command. Let’s take an example. We have inserted a text “Tejraj” in a cell “D5”. Now we will see how to fill this text from cell D5 to Up, Down, Right & Left. Fill Down: 1. Let’s assume that we have to fill the data from cells D5 to D10. For this, select the Cell Range D5:D10. Keep in mind that the data from 1st cell of the selected Cell Range will fill down in entire selection. 2. Select ...
Read more

Conditional Formatting:Highlighting Above Average and Below Average Values

By
Image
This blog post is continuation to our series of posts on “Conditional Formatting”. In this blog post, we will learn about highlighting values which are “Above Average” and “Below Average” of the selected values. To learn this post in an easy way, I have randomly listed few numbers as shown in below image. We will learn how to highlight the numbers which are above the average of all the selected numbers and which are below the average of all the selected numbers. For your easy understanding I have already calculated average value of all these numbers numbers (Which is 65). This will help us to easily cross check our output. Highlighting Above Average Values: Select all the values from which we wish to highlight the “Above Average Values”. Go to Conditional Formatting (which is available in Home Tab under Styles group) and select “Above Average” option as shown in below image. “Above Average” dialog box will appear on screen. Select the Formatting style from available list and hit OK but...
Read more

Excel Shortcuts Ctrl A to Ctrl Z

By
Image
Use of keyboard shortcuts while working in excel will be a great help for us. It will save a lot of time. In this post we are going to see Excel Keyboard Shortcuts for alphabets A to Z while using Ctrl key. Below table will give you a brief idea for each shortcut and its functionality: Now, we will see in detail how each of above listed shortcut combinations will work: Ctrl + A :  It will select all content present on the worksheet. If active cell is in the table then it will select entire table. Ctrl + B :  It will convert selected text into Bold . Ctrl + C : It will copy the selected content. The content which is copied can be seen in the Clipboard. Ctrl + D :  It will fill down the content from upper cell. For example we have inserted a number “1” in the cell A1. If we select the cell range from A1:A5 and press Ctrl + D, then this number “1” will automatically fill down in the entire cell range . ...
Read more

How to Remove Duplicate Entries from Multiple Columns in Excel

By
Image
In our last blog post, we have learned to remove duplicates entries in excel . In this blog post, we will go little advanced to remove the duplicate entries from multiple columns. Removing Duplicates Entries from 02 Columns: We will learn to remove duplicate entries from the data as shown in below image. The entries which are duplicate in both the “Fruits” column and “Price/Kg” column are highlighted with different colors. To remove duplicate entries in these 02 columns, follow the steps provided below: 1. Select the data from which we want to remove the duplicates. 2. Go to “Data” tab and under “Data Tools” we can find command named as “Remove Duplicates” as highlighted in below image. 3. Once we click on “Remove Duplicate” command, one dialog box with same name “Remove Duplicate” will appear on our excel screen. 4. If we check the checkbox for “My Data has headers” then the header row from our selection will be excluded automatically and under “Columns” section we will see the name o...
Read more

Insert Object in Excel

By
Image
Many time we may need to insert word file, pdf file or presentation in excel. But many people don’t know how to add these pdf files, word files or PPT files in excel. For those people we will learn to insert objects in excel through this blog post. 1. For this we have to go to “Insert” tab and under “Text” group and click on the command “Object” 2. Once we click on the “Object” command, one dialog box names as “Object” will appear on excel screen. 3. Click on the “Create from File” tab as highlighted in below image. 4. Click on “Browse” button, which will provide the option to select the file which we want to insert in excel. 5. Once we select the file, we can see the file name along with its path will reflect in dialog box as shown in below image. 6. Also we have to check the checkbox for “Display as icon” as shown in below image. 7. Once we click on “OK” button, selected file is now inserted as an object in our excel file. To Change the Caption of Inserted Object: We can now insert o...
Read more

Icon Sets in Conditional Formatting

By
Image
In this blog post we will learn how to apply Icon Sets from Conditional Formatting to our data in excel. This Icon Sets will help us to improve visual presentation of our data.  Conditional Formatting option we can find in Home Tab under Styles group as shown in below image. If we click on Conditional Formatting then we can see multiple options available under this. Icon Sets is one of them. Click on this “Icon Sets” option to explore all the icons from this category.  All these icons are divided into 04 categories. 1. Directional 2. Shapes 3. Indicators 4. Ratings Then names of all the Icons from respective category are provided in below image. The sequence of the icons from image on the Left Hand Side is equal to the sequence of the names from the image from Right Hand Side. This will help you to select the proper icon sets when you are working in your daily tasks. We will now apply one-one icon set from each category on the below data. We have listed few numbers specificall...
Read more

Data Bars in Conditional Formatting

By
Image
In continuation to series of posts on Conditional Formatting, we will learn how to use Data Bars in Conditional Formatting through this post. Conditional Formatting command can be found in Styles group under Home tab as shown in below image. Click on the Conditional Formatting option and select “Data Bars” option from the list of appeared options. We can now see all the “Data Bar” options available in excel. These “Data Bar” options are categorized into two groups.  1. Solid Fill 2. Gradient Fill: There are six different “Data Bar” colors available in each group. These colors are listed below: 1. Blue Data Bar 2. Green Data Bar 3. Red Data Bar 4. Orange Data Bar 5. Light Blue Data Bar 6. Purple Data Bar Each group with their respective colors are shown in below image: Solid Fill: Gradient Fill: Now we will see how we can apply these “Data Bars” on our data. For this we have created dummy data of few employees and Incentive received by them. Example with Gradient Fill: 1. Select all...
Read more

Conditional Formatting: Highlighting Top 10 Values in Excel

By
Image
This blog post is in continuation to our series of posts on “Conditional Formatting”. In this blog post we will see how to highlight Top 10 Items in Excel?  But, before proceeding on this topic, first we should know where we can find “Conditional Formatting” option in Excel. We can find “Conditional Formatting” in “Home” tab and under Home Tab go to “Styles” group. We can find many sub categories under “Conditional Formatting”. But the one which we will focus in this blog post is to highlight “Top 10 Items ” . Below image will help you to find the exact option to highlight “Top 10 Items ” . Now you are familiar with the option where we can find the option to highlight “Top 10 Items ” . To explain this topic in very simple way, I have created a dummy data of 20 students and marks obtained by them in subjects Maths, English & Science. Also we have used SUM function to calculate the total marks obtained by each student. Now we will see how we can highlight “Top 10 Items ”  i...
Read more

Insert Multiple Rows in Excel Based On Cell Value

By
Image
In this blog post we will learn to Insert Multiple Rows in excel based on cell value with the help of VBA Code. For this we have prepared dummy data as shown in below image. In this data we have listed few “Products”, their “Quantities” and their “Unit Price”. Now we want to insert multiple rows based on their “Quantities”. For example, “Product 1” has 04 quantities so we have to add 04 rows below the Product 1, “Product 2” has 02 quantities so we have to add 02 rows below the Product 2 and so on. To avoid wasting our time by manually inserting rows one by one, we can use VBA code which will do our work within seconds. To do this, just follow the below steps: 1. Add “Developer Tab” on the Ribbon if it is not already added. If you are not aware about how to add Developer Tab on the Ribbon then click here . Once added on the Ribbon, “Developer Tab” will looks like as highlighted with red in below image. 2. Now, click on the “Visual Basic” command as highlighted in below image. 3. Once ...
Read more

Exploring Font Colors and Fill Colors in Excel

By
Image
Many times we use colors in our excel files to make our work attractive. We can apply colors to the texts as well as to the cells.  If we want to change the color of text available in cells then we use the various color options available from “font color” command. Similarly, if we want to change the color of cells itself then we use the various color options available in “fill color” command. But have you ever wondered that what are names of different colors available which we can apply to texts and cells?? YouTube Video In this post we will see details about this.  The color options which are available in “font color” and “fill color” commands are as below: Fill Color: Font Color: If we compare above two images, we can see these color options are categorized into two categories. 1. Theme Colors 2. Standard Colors Theme Colors: There are total 60 different colors available in (06 rows x 10 columns) in Theme Colors category  (These colors w...
Read more