How to Add Columns in Excel - Compute Expert

How to Add Columns in Excel


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> How to Add Columns in Excel





In this tutorial, we will learn completely how to add columns in excel.

Knowing how to add one or more columns in excel is important because we often deal with data in tables. By understanding how to insert columns, we can add new data categories/entries in our data table whenever we need.

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more







How to Add a Column in Excel

In the column addition/insertion process in excel, we often only need to add one column. Want to know how to do that? Follow the steps below.

  1. Move your pointer to the lettering of the column where you want to insert a new column on its left. Move your pointer until it changes its form to a down arrow in the column lettering like this

    How to Add Columns in Excel - Screenshot of Step to Add a Column in Excel 1

  2. Click after your pointer becomes a down arrow in the column lettering. Excel will highlight that lettering’s column like this after you click it

    How to Add Columns in Excel - Screenshot of Step to Add a Column in Excel 2

  3. Click Insert in the Home tab or right-click on the column you highlight and choose Insert

    Insert button in the Home tab:

    How to Add Columns in Excel - Screenshot of Step to Add a Column in Excel 3-1

    Right-click and choose Insert:

    How to Add Columns in Excel - Screenshot of Step to Add a Column in Excel 3-2

  4. Done!

    How to Add Columns in Excel - Screenshot of Step to Add a Column in Excel 4




How to Add Multiple Columns in Excel

What if we want to add more than one column in our worksheet in excel, all at once?

Actually, the steps for that are almost the same as the steps to add a column individually. The difference is only in the number of columns we highlight before we add the columns.



To make things clearer, take a look at these following steps.

  1. Move your pointer to the lettering of the column where you want to place your new columns later on its left. Move the pointer until it changes its form to a down arrow

    How to Add Columns in Excel - Screenshot of Step to Add Multiple Columns in Excel 1

  2. Click and drag your click to the right, covering as many columns as you want to add. Excel will highlight all the columns which letterings are in your drag are

    How to Add Columns in Excel - Screenshot of Step to Add Multiple Columns in Excel 2

  3. Click Insert in the Home tab or right-click on the columns you highlight and choose Insert

    How to Add Columns in Excel - Screenshot of Step to Add Multiple Columns in Excel 3

  4. Done!

    How to Add Columns in Excel - Screenshot of Step to Add Multiple Columns in Excel 4




How to Insert Columns in Excel Using Shortcut

Want to add columns in excel faster? Maybe this shortcuts method is the best one for you to practice!

The way to use shortcuts to add columns in excel is actually quite easy. This, of course, only applies if you remember the shortcut buttons when you need them.

  1. Place your cell cursor in a cell of the column where you want to insert your new columns on its left

    How to Add Columns in Excel - Screenshot of Step to Add Columns in Excel Using Shortcut 1

  2. Press Ctrl + Space Bar (Control + Space Bar in Mac) buttons simultaneously. Pressing these shortcut buttons will make you highlight the whole column of where your cell cursor is now

    How to Add Columns in Excel - Screenshot of Step to Add Columns in Excel Using Shortcut 2

  3. Want to add more than one column? Press Shift + → until you highlight the number of columns you want to add

    How to Add Columns in Excel - Screenshot of Step to Add Columns in Excel Using Shortcut 3

  4. Press Ctrl + Shift + + (Command + Shift + + in Mac) buttons simultaneously
  5. Done!

    How to Add Columns in Excel - Screenshot of Step to Add Columns in Excel Using Shortcut 5




How to Insert Non-Adjacent Columns in Excel

What if we want to add our columns in several different places? Can we do it simultaneously or we need to add them one by one?



The answer is we can do it simultaneously, as long as we follow these steps below.

  1. Place your pointer on the column’s lettering where you want to add one of your new columns on its left. Place your pointer until it changes its form into a down arrow

    How to Add Columns in Excel - Screenshot of Step to Add Non-Adjacent Columns in Excel 1

  2. Click the lettering of the column with the pointer which has changed its form to a down arrow. Excel will highlight the column

    How to Add Columns in Excel - Screenshot of Step to Add Non-Adjacent Columns in Excel 2

  3. Press and hold the Ctrl button on your keyboard (Command in Mac). Then, click the other columns where you want to add the other new columns on the left of them. Excel will highlight all those columns and the column we first click the lettering of

    How to Add Columns in Excel - Screenshot of Step to Add Non-Adjacent Columns in Excel 3

  4. Click Insert in the Home tab or right-click on one of the columns we highlight and choose Insert

    How to Add Columns in Excel - Screenshot of Step to Add Non-Adjacent Columns in Excel 4

  5. Done!

    How to Add Columns in Excel - Screenshot of Step to Add Non-Adjacent Columns in Excel 5




Exercise

After learning completely how to add columns in excel, let’s practice your understanding by doing the following exercise. This is done so you can deepen your understanding of what you have just learned.

Open an excel file and try to add several new columns to your sheet. Do it by practicing each of the methods you learn earlier. What is the result? Can you do it?



Additional Note

What kind of cells format do the new columns that we add will have? It will follow the format of the cells from the column on the left of your new columns.



Related tutorials for you to learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Follow our tutorial content also on


Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert