As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Insert a Column in Excel: Step-by-Step Guide

Columns in Excel play a vital role in organizing data. There are two primary methods for inserting a column: using the insert function and manually adding a column.

Inserting a Column Using the Insert Function:

  1. Open Your Excel Document:
  2. Launch the Excel document where you want to insert a column.
  3. Select the Cell:
  4. Click on the cell where you want the new column to be inserted.
  5. Navigate to the Insert Tab:
  6. Go to the "Insert" tab at the top of the Excel window.
  7. Click on "Insert Column":
  8. Within the "Insert" tab, find and click on the "Insert Column" option.
  9. Column Insertion:
  10. The new column will be inserted at the selected cell's location.

Inserting a Column Manually:

  1. Open Your Excel Document:
  2. Open the Excel document in which you want to add a column.
  3. Right-Click on Column Header:
  4. Locate the column header of the column to the right of where you want the new column.
  5. Right-click on the column header.
  6. Select "Insert":
  7. From the right-click menu, choose the "Insert" option.
  8. New Column:
  9. A new column will be inserted to the left of the selected column.


This guide has demonstrated two methods for inserting a column in Excel. The insert function is recommended, as it provides a straightforward and organized way to add columns to your spreadsheet. However, you can also manually insert a column by right-clicking on the column header. Choose the method that suits your preference and workflow.