Sum Data in Excel Using Shortcut Keys
This tip covers how to quickly enter Excel's SUM function to add up data using shortcut keys on the keyboard.
The key combination to enter the SUM function is:
" Alt " + " = "
Example: Entering the SUM Function using Shortcut Keys
- Enter the following data into cells D1 to D3 of an Excel worksheet: 5, 6, 7
- If necessary, click on cell D4 to make it the active cell
- Press and hold down the Alt key on the keyboard
- Press and release the equal sign ( = ) on the keyboard without releasing the Alt key
- Release the Alt key
- The SUM function should be entered into cell D4 with the range D1:D3 highlighted as the function's argument
- Press the Enter key on the keyboard to complete the function
- The answer 18 should appear in cell D4
- When you click on cell D4 the complete function =SUM( D1 : D3 ) appears in the formula bar above the worksheet.
This shortcut can be used to sum data in rows as well as columns.
Note: The SUM is designed to be entered at the bottom of a column of data or at the right end of a row of data .
If the SUM function is entered into a location other than these two, the range of cells selected as the function's argument may be incorrect.
To change the selected range, use the mouse pointer to highlight the correct range before pressing the Enter key to complete the function