How to Do Alt + A B on Mac in Excel (Easiest Way)

💡
Quick Answer

To do Alt + A B on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, B.

Download Accelerator Keys for Free Now

Command: Subtotal

Step-by-Step Guide

  1. Download and install Accelerator Keys (14-day free trial, no credit card required).
  2. Follow the simple on-screen setup instructions (just a few clicks).
  3. Press the Option key (works like Alt on Windows).
  4. Press A, B to complete the shortcut.

This is how to do Alt + A B on Mac in Excel with Accelerator Keys, the native ribbon and alt key shortcut solution for Mac users who get more done with Excel.

What Does Alt + A B Do in Excel?

Alt + A B opens the Subtotal dialog. This feature automatically inserts subtotal rows into your sorted data, calculating sums, averages, counts, or other aggregations for each group. It also creates an outline for easy expanding and collapsing of detail rows.

Related Links