You can sum a series of numbers in Excel manually or automatically ... AutoSum works best when you have a column or row of numbers you want to add. 1. Click the cell under a column of numbers ...

Where <prefix> is the prefix to be added and <cell number of first cell> is the location of the first cell in the column to which to add the prefix. Eg. We are creating the list in column C.

However, adding that sum is not the only function Excel can perform when you have a column filled with inputted data. You may have a large column containing many different words or numbers in each ...