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.


Related Posts

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.

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