Select the column where you want the new column to appear (select the entire column).
Right-click the selected column header.
Click Insert.
Choose whether to insert a column to the left or right (Excel will typically insert to the left of the selected column).
Click the new blank column and enter your data.