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.

Likewise, if you place your cursor in the cell below a column of numbers, click AutoSum, and hit Enter, Excel totals up the numbers in the column. AutoSum is a shortcut for adding a row or column ...

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.

When you add or subtract currency-formatted numbers, Excel 2013 automatically adopts the currency format for the results. Adding and subtracting figures follows similar procedures, but you must be ...

To add a zero after a number in Excel, you can use the CONCATENATE function. For that, you need to choose a cell and enter this formula: =CONCATENATE(A1, “000”).