I see a reference showing the shortcut to be Ctl-Shift-I : but it is not working on Excel for Mac 2015
https://exceljet.net/keyboard-shortcuts/insert-rows
Is there any working shortcut for this?
Excel Shortcut – How to Insert Row
ms office
Related Question
- MacOS – How to delete empty rows in excel but not empty cells in rows with information in them
- MacOS – How to insert up arrow in microsoft word for mac using keyboard shortcut
- PowerPoint – How to Add Shortcut for Insert Equation in PowerPoint 2016?
- Word 2016 Shortcut – How to Add Insert Equation Keyboard Shortcut
- Custom keyboard shortcuts not working for Excel contextual menu item
- IOS – Excel iOS app: Keyboard shortcut for Edit cell
Best Answer
Just tested command shift + and control shift + on excel 2016 on a mac - both add a row as long as the row is selected.
If the row is not selected then it will shift the cells down in that row.
For Excel 2011, then control i works to add a row if the row is selected, if only a cell is selected then it brings up the insert cell dialogue. In excel 2011 command i does italic.
For command-shift-i this does italic on the selected row - the version using control does not work (excel 2106).
That website has information that appears out of date.