• 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 a Column in Excel

June 21, 2021 by Andrew Childress
Add a column in Excel

When you’re working with spreadsheets, your data will be organized into rows and columns. Let’s learn how to add a column in Microsoft Excel.

When you’re working with spreadsheets, your data will be organized into rows and columns. As you begin making changes, it’s often useful to add new columns to your file. That’s easy to do, and helps you insert additional data quickly. Let’s learn how to add a column in Microsoft Excel.

How to Add a Column in Microsoft Excel

Imagine that you’re working in Microsoft Excel with a set of data spread over several columns.  You may find yourself wanting an additional column within the dataset. In it, you can place additional details, formulas, references, and more. Fortunately, Excel makes the process of adding a column effortless. Let’s look at how.

Consider a dataset featuring four columns of data. You want to place a new column in the middle. The current columns A and B will be on one side, and columns C and D will be on the other.

Before you get started, it helps to understand how Excel analyzes columns like this. Excel’s Insert Column commands always look to the left. In other words, if you want to split columns A and B from columns C and D, you’ll need to select column C. Excel will insert columns on the left, not the right, side.

Click on the column C row header to select the row. You’ll see it highlight in green. Then, go to the Home tab on Excel’s ribbon.

Add a column in Excel

There, click on the Insert button on the right side. Excel will automatically insert a new column, to the immediate left of the one you have selected.

Add columns in Excel

This works for multiple columns as well. If you need to insert two new columns, simply select two columns by holding down Shift on your keyboard. When you click Insert, two new columns will appear to the left of your selection.

how to add columns in Excel

As you can see, Excel makes adding a column quick and easy.

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

About Andrew Childress

Previous Post:Write if statements in ExcelIF Statements in Excel
Next Post:Group Sheets in ExcelGroup sheets 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