To do Alt + I N A on Mac in Excel, install Accelerator Keys, then press Option, then I, then N, then A. It runs the Excel 2003 command Insert > Name > Apply.
If you are looking for the Alt + I N A shortcut on Mac Excel, you may know it from Excel 2003, where Alt + I opened the Insert menu. Windows Excel still accepts these menu keys. With Accelerator Keys, they work on your Mac too.
Alt + I + N + A is the legacy shortcut for Insert > Name > Apply. It changes the cell addresses in your formulas to the names that you defined. For example, =SUM(B2:B10) becomes =SUM(Sales). Use it after you add names to a sheet that already has formulas.
On your Mac, Accelerator Keys runs Insert > Name > Apply in the Excel menu bar. It works on any ribbon tab and at any window width.
No. Excel for Mac’s own KeyTips do not support the legacy Alt + E, Alt + I, Alt + O, and Alt + D menu keys. Accelerator Keys adds them. Press Option, then I, then N, then A.