3 Simple Ways To Insert Rows In Excel Using A Shortcut On Pc Or Mac

Highlight the same number of rows as you want to add. So to add one row, highlight just one row, to add 2, highlight 2 rows, etc.

If you have no rows selected and press Control+⇧ Shift++ then it will not work.

Highlight the same number of rows as you want to add. So to add one row, highlight just one row, to add 2, highlight 2 rows, etc.

This shortcut only works if you have a row selected.

Right-click on Insert Row to open up an additional drop-down menu. Select Add to Quick Access Toolbar. If you have nothing added to your toolbar then the next key will be assigned to F4. Press F4 whenever you want to add a new row.