How To Insert A Column In Excel?

Select the column header next to where you want the new column

Right-click the selected column header

Click Insert

Or go to the Home tab

Click Insert in the Cells group

Select Insert Sheet Columns

The new column will appear to the left of the selected column

To insert multiple columns, select the same number of column headers first

Then use the same Insert option