Adding a new column to an entire spreadsheet Sometimes you want to add a new column that extends from the top to the bottom of your spreadsheet. This can be done in a couple of easy steps. Step 1 ...

Click the first cell in the column that you want to multiply by the percentage. Press "Shift," "End" and the Down arrow simultaneously to highlight the entire column. Click the "Home" tab.