A admin Administrator Staff member Feb 7, 2021 #1 Open Microsoft Excel on your PC or Mac computer. Select the column to the right of where you want a new column. ... Right-click anywhere in the column. Click "Insert" from the menu. You will now have an empty column of cells directly before the one you clicked on.