Excel will insert the same number of columns as you've selected. How to add a column in Excel using the "Home" tab. 1. Open Microsoft Excel on your PC or Mac computer. 2.