To do Alt + E D R on Mac in Excel, install Accelerator Keys, then press Option, then E, then D, then R. It runs the Excel 2003 command Edit > Delete > Delete Sheet Rows. The modern ribbon shortcut is Alt + H + D + R.
If you are looking for the Alt + E D R 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 + D + R is the legacy shortcut for Edit > Delete > Delete Sheet Rows. It deletes each row that has a selected cell. The rows below move up. You do not have to select the full row first.
| Shortcut | Era | Menu Path |
|---|---|---|
| Alt + E + D + R | Legacy (Excel 2003) | Edit > Delete > Delete Sheet Rows |
| Alt + H + D + R | Modern (Ribbon) | Home > Delete > Delete Rows |
Both shortcuts work with Accelerator Keys.
On your Mac, Alt + E selects the Home tab. Then Alt + E + D opens the Home > Delete menu on the ribbon, and R runs Delete Rows. It works on any ribbon tab.
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 D, then R.
The modern ribbon shortcut is Alt + H + D + R (Home > Delete > Delete Rows). Both work on Mac with Accelerator Keys.