Document Editing Problems

Excel Keyboard Shortcut to Insert a Row on Mac and Windows

Anum MushtaqAnum Mushtaq Nov 2, 2026 873 views

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.

How to Use Excel Keyboard Shortcuts to Insert a Row on Mac and Windows
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the Target Row

Click on the row number indicator on the far-left side of your spreadsheet to highlight the entire row.

2
Press the Insertion Shortcut

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.

3
Verify the Row

Excel will immediately insert a new blank row directly above the row you initially selected.

Use the Windows Keyboard Shortcut to Insert a Row
Pro Tip: To insert multiple rows at once, simply highlight the desired number of rows (e.g., three rows) before pressing Ctrl+Shift+=.
Efficient Spreadsheet Alternative

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. 1. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing workbook.
  2. 2. Select the Row: Click on the row number on the left side of the screen to highlight the entire row.
  3. 3. Use the Keyboard Shortcut: Press Ctrl + Shift + = on Windows (or Command + Shift + = on Mac) to instantly insert a new row above your selection.
Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Supports the exact same standard keyboard shortcuts for row insertion and deletion.Lightweight, fast-loading, and runs smoothly on both Mac and Windows systems.Completely free for everyday spreadsheet editing and data management.
microsoft office alternative - wps office

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.