• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Add Columns in Excel

April 26, 2021 by Andrew Childress
Add columns in Excel

If you're working with a set of data containing multiple columns, and additional columns are needed. Here's how to add columns in Excel.

You might find yourself working with a set of data containing multiple columns, and need to add additional columns. Fortunately, this is easy to do in a spreadsheet. Let’s learn how to add columns in Microsoft Excel.

How to Add a Single Column in Excel

In Excel, you can add one or more columns to any dataset. Let’s first look at how to add a single column. Imagine that you have two columns of data, columns D and E. You may want to place a third column between the two.

To do so, click on the column header for column E. In this case, it’s the letter E immediately above cell E1. This highlights and selects the entirety of column E. Then, on Excel’s Home tab, find the Insert button.

Add columns in Excel

Click on it. Watch as the data in column E shifts into column F, and Excel inserts a brand-new, empty column E. Excel automatically recognized that you had a column selected, and knew to insert another one.

Add a column in Excel

Hint: When you need to insert a column, always select the column or columns to the immediate right to ensure Excel places the column(s) where you want.

How to Add Multiple Columns in Excel

Now, imagine that you needed to add three columns instead of just one. The process is very similar. Repeat by selecting column E again by clicking on the header. Then, hold down Shift on your keyboard, and click on column G. The key is to select the same number columns that you want to add.

How to add columns in Excel

Finally, repeat the earlier step by clicking Insert on the Home tab. Watch as Excel inserts three new columns in the middle of your data. This trick works for as many columns as you want.

How to add multiple columns in Excel

As you can see, Excel makes it easy to add columns to any dataset.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Delete duplicates ExcelRemove Duplicates in Excel
Next Post:Compare Two Columns in ExcelCompare two columns in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top