How to insert row in excel shortcut
Tutor 5 (40 Reviews)
Excel Tutor
Still stuck with a Excel question
Ask this expertAnswer
Yes, Excel supports a direct keyboard shortcut for inserting a row. Excel inserts a new row above the active row when the correct shortcut is pressed.
Windows Shortcut
The shortcut is Ctrl + Shift + "+".
Mac Shortcut
The shortcut is Cmd + Shift + "+".
How to insert a row using keyboard shortcuts
A row inserts quickly through a sequence of keys. The process maintains speed during data entry.
Windows
-
Select the entire row by pressing Shift + Spacebar.
-
Insert a new row by pressing Ctrl + Shift + "+".
Mac
-
Select the entire row by pressing Shift + Spacebar.
-
Insert a new row by pressing Cmd + Shift + "+".
How to insert multiple rows using shortcuts
Excel inserts multiple rows when multiple rows are selected.
Windows and Mac
-
Drag to highlight the number of rows you want to insert.
-
Press the insert-row shortcut (Ctrl + Shift + "+" on Windows or Cmd + Shift + "+" on Mac).
-
Excel adds the same number of new rows above the first selected row.
How to insert a row through the right-click menu
A right-click menu activates quickly without a ribbon search.
Windows and Mac
-
Right-click the row number on the left.
-
Select Insert.
-
Excel inserts a new row above the selected row.
How to insert a row through the ribbon
The ribbon contains the Insert command inside the Cells group.
Windows and Mac
-
Select the entire row.
-
Go to Home > Insert.
-
Choose Insert Sheet Rows.
When to use shortcuts, ribbon, or right-click
Shortcuts improve workflow during long edits. Right-click helps when working with precise row positions. The ribbon helps when commands must remain visible to new users in shared environments.
. Was this Helpful?Get Online Tutoring or Questions answered by Experts.
You can post a question for a tutor or set up a tutoring session
Answers · 1
Why are margins not working
Answers · 1
Why is page layout not working
Answers · 1
How to print repeated rows on top in excel
Answers · 1
How to print header on each page
Answers · 1