EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Excel Add a Column
 

Excel Add a Column

Arun Gupta
Article byArun Gupta
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 21, 2023

Add a Column in Excel

 

 

Add Column in Excel

Of course, there is more than one way to accomplish a task, as in all Microsoft programs. Excel allows a user to add columns, whether left or right, of the column in the worksheet called Add Column in Excel. These instructions cover how rows and columns can be added and modified in an Excel worksheet using a keyboard shortcut and the context menu with a right-click.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Add Column in Excel?

Adding a column in Excel is very easy and convenient whenever we want to add data to the table. There are different Methods to Insert or add Column, which is as follows:

  • Manually we can do this by just right-clicking on the selected column> and then clicking the insert button.
  • Use the Shift + Ctrl + + shortcut to add a new column in Excel.
  • Home tab >> click on Insert >> Select Insert Sheet Columns.
  • We can add N number of columns in the Excel sheet; a user needs to select that many columns which the number of columns he wants to insert.

Let’s understand How to Add Columns in Excel with a few examples.

Example #1

A user has a standalone book data of sales, income, PBDIT, and Profit details of each Maruti Suzuki India Pvt Ltd quarter in sheet1.

You can download this Add a Column Excel Template here – Add a Column Excel Template

Step 1: Select the column where a user wants to add the column in the Excel worksheet (The new column will insert to the left of the selected column, so select accordingly)

Step 2: A user has selected the D column where he wants to insert the new column.

insert the new column

Step 3: Now Right-click and select the Insert button or use the shortcut Shift + Ctrl + +

Example 1-2

Or

Shortcut Key

As we can see, as it was required to insert a new column between C and D columns, we have added a new column in the above example. So, as a result, it will move the D column data to the next column, which is E, and it will take the place of D.

Example 1-4 

Example #2

Let’s take the same data to analyze this example. A user wants to insert three columns left of the B column.

Step 1: Select B, C, and D columns where a user wants to insert new 3 columns in the worksheet (The new column is inserted to the left of the selected column, so select accordingly)

Step 2: A user has selected the B, C, and D columns where he wants to insert a new column

Example 2-1

Step 3: Now Right-click and select the Insert button or use the shortcut Shift + Ctrl + +

Insert Button

Or

Shortcut Key

As we can see, as it was required to insert a new column left of the B, C, and D column, we added a new column in the above example. As a result, it will move B, C, and D column data to the next column, E, F, and G; it will replace the B, C, and D columns.

Added New Column

Example #3

Step 1: Go to Worksheet >> Select the column’s heading where a user wants to insert a new column.

Step 2: Click on the Insert button.

Step 3: One drop-down will open; click the Insert Sheet Columns.

Insert Sheet Column

As the user wants to use the Insert toolbar to insert a new column, as, in the above example, it is added.

New Column

Example #4

The user can insert a new column in any version of Excel; in the above examples, we can see that we had selected one or more columns in the worksheet then >Right click on the selected column> and then click on the Insert button.

Add a new column in the Excel worksheet.

Click on Table Columns to the Left from the Insert option. Click in a cell to the left or right where you want to add a column. If the user wants to add a column to the left of the cell, then follow the below process:

Table Column to the Left

And if a user wants to insert the column to the right of the cell, then follow the below process:

  • Click on Table Columns to the Right from the Insert option.

Table Columns to the Right

How to Modify a Column Width?

A user can modify the width of any column. Let’s take an example, as some of the content in column A cannot be displayed. We can make all this content visible by changing the width of column A.

Step 1: Position the mouse over the column line in the column heading to the Black Cross. (As shown below)

Step 2: Click, hold, and drag the mouse to increase or decrease the column width.

Step 3: Release the mouse. The column width will be changed.

Column Width 1

A user can auto-fit the width of the column. The AutoFit feature will allow you to automatically set a column’s width to fit its content.

Step 1: Position the mouse over the column line in the column heading to the Black Cross.

Step 2: Double-click the mouse. The column width will be changed automatically to fit the content.

Column Width 2

Things to Remember About Add a Column in Excel

  • The user needs to select the column where the user wants to insert the new column.
  • By default, every row and column has the same height and width, but a user can modify the column’s width and the row’s height.
  • The user can insert multiple columns at a time.
  • You can also AutoFit the width for several columns at the same time. Simply select the columns you want to AutoFit, and then select the AutoFit Column Width command from the Format drop-down menu on the Home. This method can also use for row height.
  • All the rules will also be applied for rows, as applied to column insertion.
  • Excel allows the user to wrap text and merge cells.
  • For deleting also, we can go to Home Tab >> Delete >> Delete Sheet Columns; either we can select the column which we want to delete or >> Right Click >> click on Delete.
  • After adding the insert column, all the data will be shifted to the right side after that column.

Recommended Articles

This is a guide to adding a column in Excel. Here we have discussed How to Add a column in Excel using different methods and How to modify a column in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. COLUMNS Formula in Excel
  2. Switching Columns in Excel
  3. Excel COLUMN to Number
  4. Freeze Columns in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Add a Column Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Add a Column Excel Template

EDUCBA

डाउनलोड Add a Column Excel Template

🚀 Limited Time Offer! - ENROLL NOW