In Excel for Mac, select the row where the new row should go, then press Control+Shift+= (the plus sign on most keyboards). Excel inserts a blank row above the selected row; to select a row first, click its number at the left of the sheet or press Shift+Space while a cell in it is active.
The shortcut and what it does
The key combination is sometimes written as Control+Shift++, because the plus sign is the character produced by holding Shift and pressing the equals key on many layouts. In practice, hold Control and Shift, then press the key that types plus. The exact physical key can vary with the keyboard layout, so the menu command is a dependable alternative if the shortcut does not work.
Excel inserts the new row above the selected row, not below it. For example, if you want a blank row between rows 8 and 9, select row 9 and use the shortcut. The existing row 9 and the rows beneath it move down. The cells in the new row are blank unless formatting or table behavior supplies a style.
The shortcut inserts a full worksheet row when an entire row is selected. If only one cell is selected, Excel may instead open an Insert dialog that lets you choose whether to shift cells, insert a row, or insert a column. Selecting the row first removes that ambiguity.
Select the correct row before inserting
To place a row at a precise location, identify the row immediately below where it should appear. Then select that row and insert. You can select it with the row-number header on the left edge of the worksheet, or use the keyboard:
- Click a cell in the row that should move down.
- Press
Shift+Spaceto select the entire worksheet row. - Press
Control+Shift+=.
Suppose a list has headings in row 1 and data in rows 2 through 20. To add a record before the current entry in row 7, select row 7 and insert. Excel places the empty row at 7, and the old row 7 becomes row 8. If you need the new record at the bottom, select the first empty row after the list and type into it; inserting a worksheet row is usually unnecessary unless you need to create space within a range or table.
You can insert several rows at once by selecting the same number of existing rows before invoking the command. For example, select rows 6 through 8 and insert to add three rows above row 6. The selected rows are not replaced: Excel adds three new rows, then shifts the selected rows and the content below them down.
Use the ribbon or a context menu
If you prefer not to use a keyboard shortcut, select the row and choose Home > Insert > Insert Sheet Rows on the ribbon. The command name matters: it inserts worksheet rows, rather than merely shifting a selected group of cells. In some Excel window sizes, ribbon commands may be condensed into smaller menus, but the Insert command remains on the Home tab.
You can also Control-click the selected row header, or right-click it if your mouse has a secondary button, and choose Insert from the context menu. Selecting the row header before opening the menu is important. If you right-click inside a cell instead, the available Insert command may open choices for shifting cells or adding a row or column.
The ribbon and context-menu methods are useful when the plus-key combination is awkward on a non-US keyboard, when you are using a compact keyboard, or when you want to confirm that Excel is inserting a sheet row. They have the same basic effect: a row is added above the selected row.
Insert rows inside an Excel table
An Excel table is a formatted, filterable data range, and adding a row within it can behave differently from adding a row to an ordinary worksheet range. When the selection is inside a table, inserting a worksheet row through the row header shifts the sheet and expands the table when appropriate. Table formatting and calculated-column formulas may carry into the added row, depending on the table structure and nearby entries.
For a quick addition at the end of a table, click the last cell in its final row and press Tab. Excel creates a new table row when the active cell is the last cell of the table row. This is often a cleaner way to append data because the table can extend its formatting and formulas automatically. It is not the same as inserting a row in the middle: to create space between existing records, select a table row and use the Insert command or the shortcut.
Be cautious when a table has totals, calculated columns, or formulas that refer to the table. Adding a row can extend the table and affect structured references, which is generally useful, but it may also change what a formula includes. Check totals and any dependent calculations after making structural changes.
How inserted rows affect formulas and formatting
Inserting a worksheet row changes the positions of cells below it. Excel normally adjusts many formulas that refer to shifted cells so they continue to point to the intended data. For instance, if a total refers to a range that includes the insertion point, Excel may expand the range to include the new row. The exact result depends on where the formula is located and what its references include, so review important formulas after inserting rows into a complex model.
Formatting for a new row is often inferred from nearby rows. Excel may carry borders, number formats, or other styles from the row above or below, and a table applies its own banding and table style. A row that looks blank may still contain formatting, validation rules, or copied formulas. If the appearance is unexpected, use the Insert Options control that can appear beside the inserted area to choose how formatting is applied, or adjust the row formatting afterward.
Rows are inserted across the worksheet, not just within the visible part of a column. If your data occupies columns A through F, inserting a sheet row shifts cells in every column at that row position, including content in columns beyond F. This can affect notes or unrelated data elsewhere on the same worksheet. Before inserting, check whether other content shares those rows.
Common shortcut problems on a Mac
If the shortcut appears to do nothing, first check whether the worksheet is protected. Protection can prevent row insertion unless the sheet settings allow it. Look for a protection command on the Review tab or ask the workbook owner to adjust permissions. A protected sheet is different from a keyboard problem: the menu command may also be unavailable or produce a warning.
- The wrong cells are selected: Click the row number or use
Shift+Spacebefore inserting. A single-cell selection can lead to the Insert dialog rather than an immediate full-row insertion. - The plus key is awkward: On many keyboards, plus requires
Shiftwith the equals key. Try the ribbon command if your keyboard layout maps those keys differently. - The selection is in a merged area: Merged cells can limit some insert operations or cause Excel to report that the action cannot be completed. Review the merged cells around the insertion point and, if suitable, unmerge them before trying again.
- You are in a filtered list: A filtered worksheet can make visible row numbers appear nonconsecutive. Inserting a sheet row is a structural change to the worksheet, not simply adding a record among the currently visible results. Consider adding data to the table itself or clearing the filter so you can see where the row will go.
- A different app responds to the keys: macOS shortcuts or keyboard utilities can sometimes use the same combination. Use Excel’s ribbon command to complete the task, then check for shortcut conflicts if you need the keys regularly.
Also make sure Excel has focus. If a cell is being edited, the shortcut may be interpreted as part of the cell entry rather than as a worksheet command. Press Return or Esc to finish or cancel editing, select the intended row again, and retry.
Mac shortcut compared with Windows and the web
The key difference to keep in mind is the modifier key. In Excel for Windows, the familiar insert command is commonly performed with Ctrl+Shift++ after selecting a row. On Mac, use Control+Shift+= on a typical keyboard, rather than assuming that the Windows Control combination has identical key labeling on every layout. In both cases, selecting the full row first makes the result predictable.
Excel for the web runs in a browser, where browser and operating-system shortcuts can affect key combinations. If a shortcut is intercepted or behaves differently, select the row and use the available Insert command in Excel’s ribbon or row context menu. These instructions are for Excel for Mac, not Google Sheets; Sheets has its own menus and keyboard behavior.
Shortcuts can also differ among keyboard layouts and Excel releases. If you need to verify the command in your installation, check Excel’s menu or keyboard-shortcut help and use the visible Insert Sheet Rows command as the reference. A menu command is often clearer than trying multiple combinations that differ only by whether the plus character is printed on a separate key.
Frequently Asked Questions
What is the Mac Excel shortcut to insert a row?
Select a row, then press Control+Shift+= on most Mac keyboards. This is the plus-sign shortcut; on a common US layout, Shift is needed to type plus using the equals key.
How do I insert a row above in Excel for Mac?
Select the row that should move down, then use the shortcut or choose Home > Insert > Insert Sheet Rows. Excel inserts the blank row above the selected row.
Can I insert multiple rows at once on a Mac?
Yes. Select as many existing row headers as the number of rows you want to add, then use the insert shortcut or ribbon command. Excel adds that number of rows above the first selected row.
Why does Excel show an Insert dialog instead of inserting a row?
You probably selected a cell rather than the entire row. Select the row header or press Shift+Space with a cell in that row active, then repeat the command.
How do I add a row at the bottom of an Excel table?
Click the last cell in the table’s final row and press Tab to create a new table row. To insert a row between existing table records, select the appropriate table row and use the Insert command.
Choose the method that fits the task
For a one-off insertion, selecting the row and using the ribbon is easy to verify. For repeated editing, the keyboard method is quicker once the key combination is familiar. When adding records to a table’s end, Tab often preserves table behavior with less effort. In every case, decide whether you need a whole worksheet row, a row inside a table, or merely a new record at the end; that distinction prevents accidental shifts elsewhere in the sheet.
Before inserting into a shared or formula-heavy workbook, check the surrounding rows and any content in other columns. Then select the row below the intended gap and insert. That simple selection rule is the key to getting the Mac Excel row shortcut to do exactly what you expect.
Related
- Unhide Rows in Excel: Shortcut Keys and Other Methods
- Unhide Columns in Excel Using the Keyboard
- Excel Unhide Shortcut: Reveal Hidden Rows and Columns
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Use Absolute References in Excel for MacTo make a cell reference stay fixed when you copy a formula in Excel for Mac, add dollar…
- How to Track Spending in Google Sheets Step by StepTo track spending in Google Sheets, create a transaction list with a date, description, category, and amount, then…
- SUMIF Negative Values in Google Sheets: What to CheckNegative numbers do not make Google Sheets’ SUMIF function fail: to add every value below zero, use a…
- Google Sheets Zoom: How to Zoom In or Out on Any DeviceTo zoom out in Google Sheets in a web browser, click the zoom percentage in the toolbar and…
- How to Find Duplicate Values in an Excel Column FastTo find duplicates quickly in Excel for Microsoft 365 on Windows, select the cells you want to check,…
- Remove Duplicates in Excel by Entire Row: A Safe GuideTo remove duplicate records in Excel, select the full data range, choose Data > Remove Duplicates, and check…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.