You can also insert a new column on a worksheet with existing data. Inserting a column moves the existing data to the right of the new column.
Click the Home tab.
Click the column heading letter where you want to insert the new column. Excel selects the entire column.
Click the Insert button.
Excel moves the existing column to the right and inserts a new column.
Tip
Enter Multiple Columns To enter more than one column, select the number of columns you want to enter with your mouse, and click the Insert button. For example, if you select columns A through C, Excel moves the existing columns to the right and inserts three blank columns, labeled A through C.