Swiccom Finance

To sum a column in Microsoft Excel, you can use the following shortcuts:

1. Alt + = (Windows) or Command + Shift + T (Mac):
   • Select the cell below the column you want to sum. This will be the cell where the sum will appear.
   • Press the shortcut key combination.
   • Excel will automatically detect the range of cells to sum based on the adjacent column.
2. Status Bar Method:
   • If you only want to see the sum without displaying it anywhere in your spreadsheet, use this method.
   • Select the column of numbers.
   • Look at the status bar at the bottom of the Excel window. It will display the sum of the selected cells.
3. AutoSum:
   • This Excel feature automatically adds the SUM function with its required arguments to your selected cell.
   • Select the cell where you want the sum to appear.
   • Click on the AutoSum button in the Home tab.
   • Excel will automatically select the range of cells above the selected cell and calculate the sum.
4. Manual Entry:
   • Enter =SUM( in the cell where you want the sum to appear.
   • Select the range with the numbers you want to total.
   • Press Enter on your keyboard.

Remember that the data to be summed should be in a continuous range for these shortcuts to work effectively. Happy Excel-ing! 📊👩‍💻