Insert Subtotals Dialog

In a sorted list you can have Excel automatically insert subtotals based on the sorted column.

With a cell selected in the table, the keyboard shortcut for the Subtotals Dialog is

Alt a b

Pressed in sequence, not held down.


Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.