Course
AutoSum and fill shortcuts
Total a budget without typing a single formula: AutoSum, fill right, and copy and paste.
Exercise 1 of 5
AutoSum a column
B5 should add up January’s costs. Instead of typing the formula, press Alt + =: Excel writes =SUM(B2:B4) for you. Check the range and press Enter.
| Jan | Feb | Mar | Apr | |
| Rent | 950.00 | 950.00 | 950.00 | 950.00 |
| Groceries | 320.00 | 295.00 | 340.00 | 310.00 |
| Transport | 85.00 | 110.00 | 90.00 | 95.00 |
| Total |