To do Alt + A R on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, R.
Command: Refresh Menu
This is how to do Alt + A R 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 r opens the Refresh dropdown menu in Excel’s Data tab. This menu provides options to refresh data connections, including Refresh All, Refresh single queries, check Refresh Status, Cancel Refresh, Access connection Properties.