To do Alt + A P 1 on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, P, 1.
Command: Properties
This is how to do Alt + A P 1 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 P 1 opens the Properties dialog for the selected data connection or query table. This allows you to configure connection settings, refresh options, and data formatting for external data sources. Note: This button is only active when a data connection is selected.