Excel Keyboard Shortcut to Insert a Row on Mac and Windows
Question details
The user needs the correct keyboard shortcut to insert a new row in Excel on Mac and Windows, as the previously used shortcut now mistakenly applies italic text formatting.

- Product
- Excel
- Device & OS
- Mac and Windows
- Scenario
- Editing a spreadsheet and attempting to quickly add new rows using keyboard commands.
- Observed behavior
- Pressing the shortcut applies italic formatting to the cell contents rather than inserting a new blank row.
Ensure that your cursor is active within the worksheet and that you select the entire row immediately below where you want the new blank row to appear.
Use the Windows Keyboard Shortcut to Insert a Row
Using the standard keyboard combination is the most efficient way to insert rows in Excel on Windows without triggering formatting commands.
In modern versions of Excel for Windows, shortcuts like Ctrl+I are strictly reserved for italic formatting. To insert rows, you must use the plus/equals key combination.
Click on the row number indicator on the far-left side of your spreadsheet to highlight the entire row.
Press and hold the Ctrl and Shift keys, then press the = (equals) key on your keyboard. Alternatively, if you have a numeric keypad, you can press Ctrl and the + (plus) key.
Excel will immediately insert a new blank row directly above the row you initially selected.

Use the Mac Keyboard Shortcut to Insert a Row
Mac users have a specific shortcut combination to ensure rows are inserted properly based on standard Apple keyboard layouts.
Insert Rows Instantly with WPS Spreadsheet
WPS Office provides a highly compatible spreadsheet application where standard keyboard shortcuts, including those for inserting rows and columns, work exactly as you expect.
- 1. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing workbook.
- 2. Select the Row: Click on the row number on the left side of the screen to highlight the entire row.
- 3. Use the Keyboard Shortcut: Press Ctrl + Shift + = on Windows (or Command + Shift + = on Mac) to instantly insert a new row above your selection.

Frequently Asked Questions
Why does my shortcut apply italic formatting instead of inserting a row?
You are likely pressing Ctrl+I (or Command+I on Mac), which is the universal shortcut for applying italic text formatting. To insert a row, you must switch to using the Ctrl+Shift+= shortcut combination.
Can I insert multiple rows simultaneously using this shortcut?
Yes. Highlight the exact number of rows you want to insert (for example, select rows 4, 5, and 6 to insert three rows) and press the Ctrl+Shift+= shortcut. Excel will insert that same number of new blank rows.
What is the keyboard shortcut to delete a row in Excel?
Once you have selected the entire row by clicking its number, press Ctrl+- (the minus key) on Windows, or Command+- on a Mac, to instantly delete the selected row.




