To do Alt + E I A on Mac in Excel, install Accelerator Keys, then press Option, then E, then I, then A. It runs the Excel 2003 command Edit > Fill > Across Worksheets. The modern ribbon shortcut is Alt + H + F + I + A.
If you are looking for the Alt + E I A shortcut on Mac Excel, you may know it from Excel 2003, where Alt + E opened the Edit menu. Windows Excel still accepts these menu keys. With Accelerator Keys, they work on your Mac too.
Alt + E + I + A is the legacy shortcut for Edit > Fill > Across Worksheets. It copies the selected cells to the same cells on other worksheets. Excel asks if you want to copy all, contents only, or formats only. Use it to build a set of sheets with the same headers or layout.
| Shortcut | Era | Menu Path |
|---|---|---|
| Alt + E + I + A | Legacy (Excel 2003) | Edit > Fill > Across Worksheets |
| Alt + H + F + I + A | Modern (Ribbon) | Home > Fill > Across Worksheets |
Both shortcuts work with Accelerator Keys.
On your Mac, Alt + E selects the Home tab. Then Accelerator Keys opens the Home > Fill menu on the ribbon and runs Across Worksheets. 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 E, then I, then A.
Excel enables Fill Across Worksheets only when you select two or more sheets. Hold Cmd and click the other sheet tabs, then press Option, then E, then I, then A.
The modern ribbon shortcut is Alt + H + F + I + A (Home > Fill > Across Worksheets). Both work on Mac with Accelerator Keys.