If you work with numbers in Microsoft Excel, you know how important it is to be able to quickly and easily calculate sums. The Auto Sum shortcut is a great way to do just that. Here's how to use it.
First, select the cell where you want the sum to appear. Then, press Alt + = (equal sign). Excel will automatically select the cells that it thinks you want to sum, based on the cells that are adjacent to the cell you selected. If the cells that are selected are the ones you want to sum, just press Enter and the sum will appear in the cell.
If the cells that are selected are not the ones you want to sum, you can press Esc to cancel the Auto Sum shortcut. Then, select the cells you want to sum manually, and press Alt + = again. This time, when you press Enter, the sum will appear in the cell.
You can also use the Auto Sum shortcut to sum a range of cells that are not adjacent to each other. To do this, select the first cell in the range, press and hold the Shift key, and then select the last cell in the range. Then, press Alt + = and the sum will appear in the cell.
The Auto Sum shortcut is a great way to quickly and easily calculate sums in Excel. Give it a try the next time you need to sum a range of cells.