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.