Excel Insert Row Shortcut on macOS: Keys and Options

In Excel for Mac, select the row where the new row should go, then press Control+Shift+= (the plus key). Excel inserts a blank row above the selected row. On some keyboard layouts, the plus sign requires a different physical key; use the key combination that produces a plus sign, and use Control—not Command.

The Mac shortcut and what it does

The shortcut is often written as Control+Shift++ because the final character is a plus sign. On a standard US keyboard, plus is typed with Shift and the equals key, so the same shortcut is commonly shown as Control+Shift+=. The notation can look unusual, but it describes one key combination: hold Control and Shift, then press the equals/plus key.

Excel inserts the row above the selected row. For example, if row 8 is selected, the new blank row becomes row 8 and the previous contents of row 8 move down to row 9. Excel does not overwrite the selected row. If you select several whole rows first, the shortcut inserts the same number of blank rows above the selection.

On a Mac, do not substitute Command for Control. Command is used for many common Mac app shortcuts, but Excel’s insert-row shortcut uses Control. If the shortcut is hard to remember or your keyboard layout makes the plus key awkward, the ribbon and row-header menu provide dependable alternatives.

How to select the right row first

The result depends on what is selected when you use the shortcut. To insert a complete worksheet row, click its numbered header at the left edge of the grid. The whole row should highlight. Then press Control+Shift+=. This is the clearest method when you want cells across the sheet to move down together, not just a few cells in one column.

You can also place the active cell in the row and press Shift+Space to select that entire row, then use the insert shortcut. If you need more than one row, select a matching block of row headers: for example, select rows 8 and 9 to insert two blank rows above row 8. Check that the highlighted range covers the intended rows before inserting, especially in a worksheet with hidden or filtered rows.

Click the row number where the new row should appear.
Confirm the full row is highlighted rather than only one cell.
Press Control+Shift+=.
Enter data in the new row, or continue working; existing rows below have shifted down.

Rows are identified by their numbers, while columns are identified by letters. If you select a column header instead, the same insert command adds a column to the left of that selection. Selecting a cell rather than a row can bring up an Insert dialog, so row-header selection avoids ambiguity.

Insert a row using the ribbon or mouse

For a menu-based method in Excel for Mac, select the row header, then choose Home > Insert > Insert Sheet Rows. The wording can vary slightly between Excel releases, but the Home tab’s Insert menu contains the command for inserting worksheet rows. If the ribbon is collapsed, expand it or choose the Home tab first.

You can also Control-click or right-click the selected row number and choose Insert from the context menu. On a Mac, a two-finger click on a trackpad may open the same menu, depending on trackpad settings. Selecting the row header before opening the menu matters: right-clicking an ordinary cell may present commands for inserting cells rather than an entire row.

These options are useful when you are learning Excel, when the keyboard shortcut is unavailable, or when you want to verify the operation before making it. They also help on a keyboard whose layout makes the plus key combination inconvenient. The result is the same: a blank row is placed above the selected row.

Whole rows, cells, and columns are different

Excel distinguishes inserting a full worksheet row from inserting cells within a range. If only a single cell is active when you press the shortcut, Excel may open an Insert dialog with choices such as shifting cells down or shifting cells right. That changes part of the grid and may cause data in adjacent columns to become misaligned. Choose the entire row option only when you intend to add a complete worksheet row.

For example, suppose a list uses columns A through D for a person, date, category, and amount. Inserting a full row above a record moves all four fields together, preserving the relationship between them. Inserting only a cell in column B and shifting cells down can separate a date from its matching person and amount. When the goal is a new record in a normal worksheet list, select the row header first.

The same logic applies to columns. Select a column letter to insert a full column to the left. A selection of individual cells can instead trigger a choice about shifting cells, so make the intended scope clear before using Insert.

Adding rows inside an Excel table

An Excel table is a formatted, structured range with features such as filter buttons and automatic expansion. A table row is not always the same thing as an arbitrary worksheet row. To add a record within a table, right-click a cell in the table and use the table-specific Insert option, such as Table Rows Above, when it appears. This adds a row to the table and keeps the new record within its structure.

You can also type in the row immediately below a table; Excel commonly expands the table to include adjacent entered data. That can be convenient for adding a record at the bottom, but it is not the right approach if the new record belongs between existing ones. In that case, select a table row or use the table-specific insert command so the new row lands in the intended position.

If you select an entire worksheet row that intersects a table and insert a sheet row, Excel shifts worksheet cells and the table may expand to include the inserted space. Because table and sheet operations can affect neighboring content, use the table’s own row command when your purpose is specifically to add a table record. Confirm the filter buttons, formatting, and formulas still cover the expected range afterward.

Common shortcut problems and fixes

If nothing happens, first verify that Excel has focus and that the workbook is not in a state that prevents editing. A protected worksheet may block row insertion unless the sheet protection settings allow it. You may also be editing the contents of a cell; press Return or Escape to finish or cancel cell editing, then select the row and try again.

Wrong key used: use Control, not Command, and make sure the final key produces a plus sign on your keyboard layout.
Only one cell selected: click the row number so Excel knows you want a complete row.
Unexpected cells shift: undo immediately with Command+Z on Mac, then select the row header and repeat.
Cannot insert into a protected sheet: ask the workbook owner to change protection or allow row insertion.
Shortcut conflicts or feels unreliable: use Home > Insert > Insert Sheet Rows or the row-header context menu.

Undo is useful if the wrong range moves, but it is best to check the selection before confirming an operation in a large or shared workbook. In a filtered list, hidden rows can make the visible layout misleading. Review the row numbers and the inserted location rather than assuming the new row went between the two records currently visible on screen.

How the shortcut compares across platforms

On Windows, the equivalent Excel command is generally written Ctrl+Shift++. On a standard keyboard, that means holding Ctrl and Shift and pressing the plus key, often the same key as equals. On Mac, use Control rather than the Windows Ctrl-labeled key distinction; the Mac key is labeled Control, and Command is not the substitute. The ribbon command is a useful cross-platform fallback if the key notation is confusing.

Excel for the web runs in a browser, where browser and operating-system shortcuts can affect keyboard behavior. When a shortcut is intercepted or differs on that platform, select the row and use the available Insert command in Excel’s ribbon or context menu. The exact shortcut guidance here is for the Excel desktop app on macOS, not Google Sheets or another spreadsheet program.

Keyboard layouts also vary by language and hardware. If the plus sign is not printed on the key you expect, look up how to type plus on that layout and use that key along with Control and Shift. Avoid changing system keyboard settings just for this task: selecting the row and using the ribbon works without memorizing a layout-specific combination.

Frequently Asked Questions

What is the Excel shortcut to insert a row on Mac?
In Excel for Mac, select the row and press Control+Shift+=, also written as Control+Shift+Plus. This inserts a blank row above the selected row.

Do I press Command or Control to insert a row in Excel for Mac?
Use Control. Command is not the key in this shortcut. On a standard Mac keyboard, hold Control and Shift and press the equals/plus key.

How do I insert multiple rows at once on a Mac?
Select the same number of whole rows as the number you want to add, using the row headers, then press Control+Shift+=. Excel inserts that number of blank rows above the selected block.

Can I insert a row without using a keyboard shortcut?
Yes. Select the row number and choose Home > Insert > Insert Sheet Rows, or Control-click or right-click the row header and choose Insert.

Why does Excel show an Insert dialog instead of adding a row?
You probably selected a cell or cell range rather than a complete row. Select the row number first to insert a whole worksheet row; otherwise, Excel may ask whether to shift cells down or right.

Choosing the quickest method

For frequent editing, the shortcut is fastest once the selection and key notation are familiar: select the row header, then press Control+Shift+=. For occasional edits, the ribbon or context menu is easier to recognize and helps make the operation explicit. For a structured table, use its table-row insertion command rather than assuming every worksheet-row operation is the best choice.

Whichever method you choose, decide first whether you need an entire worksheet row, a table row, or only shifted cells. That distinction prevents the most common insertion mistake and keeps related values together. When in doubt, select the row number and use the ribbon command; Excel will add the blank row above it without replacing existing data.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.