Excel Hack

Shortcut for subtotal in Excel

If you want to get a subtotal of the values of an item, the method described below is effective: once you learn how to get a subtotal in Excel, you can get the sum of values belonging to the same group at once. This section explains how to use shortcuts to produce subtotals of values belonging to the same group and how to display the Subtotal dialog box to easily produce subtotals. This will greatly speed up the process of performing calculations.

Subtotal shortcut

Windows
Access Key: Alt + A + B or Alt + D + B

Mac
None

Subtotal with the Subtotal dialog box

This is a method of using shortcut keys to display a subtotal dialog box and produce a subtotal of values belonging to the same group.

Total Time: 1 minute

Select any cell

Select a cell

Select any cell in the range of data.

Displays the Subtotal dialog box

Displays the Subtotal dialog box

Press Alt + A + B to display the Subtotal dialog box. This time, as an example, to get a subtotal of the wages for each serial number, press Alt + A to select the Serial No.

Complete each item's settings

Complete the settings for subtotals

Make sure sum is selected in use function. Place a check mark in the value to be subtotaled. As an example here, place a check mark in Wage.

We could give a subtotal

We could give a subtotal

Press Enter to calculate the wage subtotal for each serial number.

AutoSum shortcut to subtotal rows or columns

AutoSum is useful when you want to calculate subtotals of column or row values. The following article provides shortcut keys that allow you to perform AutoSum in a single keystroke. If you want to get subtotals of columns and rows with fewer operations, you should definitely try using AutoSum.

Shortcut for AutoSum in Excel