To do Alt + A D on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, D.
Command: Consolidate
This is how to do Alt + A D on Mac in Excel with Accelerator Keys, the native ribbon and alt key shortcut solution for Mac users who get more done with Excel.
Alt + A D opens the Consolidate dialog. This feature combines data from multiple ranges into a single range, using functions like SUM, AVERAGE, or COUNT. It’s useful for summarizing data from different worksheets or workbooks.