Sometimes, you want to add a new column to just part of a spreadsheet. That's easy to do as well. Step 1: Select the cells to the right of where you want to add the new column.

How to add a column in Excel using the "Home" tab. 1. Open Microsoft Excel on your PC or Mac computer. 2. Instead of right-clicking, you can also use a feature in the "Home" tab.

If you prefer keyboard shortcuts, use the following steps to insert rows and columns: Press [Shift]+[Spacebar] to select an entire row. Press [Ctrl]+[Spacebar] to select an entire column.