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.