Excel Hack

Shortcut to sum in Excel

The SUM function is one of the most commonly used functions in Excel, but many people may have trouble remembering the formula for the SUM function or find it tedious to type it in manually. In such cases, it is convenient to use a shortcut to display the SUM function. Please keep this in mind as it will help you work more efficiently and increase your productivity.

Shortcut for performing sum

Windows
Access Key: Alt + H + U + S or Alt + M + U + S

Mac
None

Use shortcut to perform sum

See below for instructions on how to perform summation with shortcuts.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell for which you want to display the total value.

The SUM function is automatically populated

The SUM function is automatically populated

Press Alt + H + U + S. The SUM function will automatically populate. Cell ranges can be changed manually.

Calculation of the SUM function is complete

Calculation of the SUM function is complete

Press Ctrl + Enter. The sum calculated by the SUM function is reflected in the active cell.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments