To do Alt + I B on Mac in Excel, install Accelerator Keys, then press Option, then I, then B. It runs the Excel 2003 command Insert > Page Break. The modern ribbon shortcut is Alt + P + B + I.
If you are looking for the Alt + I B 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 + B is the legacy shortcut for Insert > Page Break. It adds a manual page break. If you select a row, the break goes above that row. If you select a column, the break goes to the left of that column. If you select one cell, Excel adds breaks above it and to its left.
| Shortcut | Era | Menu Path |
|---|---|---|
| Alt + I + B | Legacy (Excel 2003) | Insert > Page Break |
| Alt + P + B + I | Modern (Ribbon) | Page Layout > Breaks > Insert Page Break |
Both shortcuts work with Accelerator Keys.
On your Mac, Accelerator Keys runs Insert > Page Break 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 B.
The modern ribbon shortcut is Alt + P + B + I (Page Layout > Breaks > Insert Page Break). Both work on Mac with Accelerator Keys.