2. Select the column to the right of where you want a new column. (Excel will insert the new column directly in front of it.) Select an entire column by clicking on its letter name at the top. 3.