Sometimes working with Excel an extra one or multiple columns are needed between two columns. Are you searching for the easiest methods to insert a column (or columns) in Excel? Then you are in the right place.
In this article I will discuss the five various ways to insert columns in Excel and the ways will serve various purposes of inserting columns in Excel. Let’s get into the main discussion.
Download Excel Workbook
5 ways to insert column in Excel
Let’s get introduced to the data table first. Here four columns are taken named as Product, Product Code, Color, Price and total thirteen rows have been taken as shown below :
Now, we will discuss various ways of inserting columns in Excel.
Method-1: Insert a Column to the Left of a Column using the Insert command
Step-1: At first we have to select the column from which on the left side a new column is required.
Here ,suppose I want to add a column named Size between Color and Price column.
So, I have selected column Price. Now I will select the Insert Sheet Columns option under the Insert command under Cells group under Home tab.
Step-2: Here is the result below, a new column named Size has been created .
Method-2: Insert a Column to the Left of a Column (shortcut method)
Step-1: As like Method 1 the same process can be done in an easier way.
You have to just select the whole column from which on the left side you want a new column and then right click on your mouse and select the Insert option .
Step-2: Now, a new column named Size will be inserted as shown below.
However, you can do the same by selecting the column and then press SHIFT + CTRL + +.
In this way also the same result as below will occur.
Method-3: Insert Multiple Columns Simultaneously
Step-1: If you need more than one column before any column then you have to select the following columns as the same number to the required columns.
As an example here, I needed 2 columns named Material and Size before the Color column, so I selected the following 2 columns named Color and Price.
Then You have to right click on your mouse and click on the Insert option.
Step-2: After that the new 2 columns named Material and Size will be formed as below.
Method-4: Insert New Columns Simultaneously for Non-Contiguous Columns
Step-1: Non-contiguous columns represent the columns which are not adjacent to each other which means separated column.
Suppose I need a column named ID No. before Product Code and Size before Price.
So, I will select first the Product Code named column and then press CTRL and select the
In this way various numbers of non-adjacent columns can be selected.
Now You will just have to follow Method-1.
Step-2: By following this way two new columns named ID No. and Size will be added as below.
Method-5: Insert a Column to a Formatted Table (Power Query)
Step-1: Sometimes a new column is needed for a formatted table. For this You just have to select the column from which on the left side You want a new column.
Then select Insert Table Columns to the Left under Insert option under Cells group under Home tab.
Here, I wanted a column named Size before Color column and so I have selected Color column.
Step-2: After that a new column named Size will be formed before the Color.
In this article I have tried to cover the possible easiest ways to insert columns in excel. Hope this article will help you a lot. If you have any further ideas related to this topic then you can share with us. You can ask any question here. Thank you.