To insert a row in Excel for Mac, select the worksheet row header where the new row should go, then choose Home > Insert > Insert Sheet Rows; Excel places the new row above the selected row. You can also Control-click the row number and choose Insert, or use Control+Shift+plus (+) with a row selected.
What happens when you insert a worksheet row?
Excel inserts a complete row across the worksheet, not just a blank strip in the cells you can currently see. The selected row and the rows beneath it move down by one, and the new row takes the selected row’s position. For example, selecting row 8 and inserting a row puts the blank row at row 8; the former row 8 becomes row 9.
This is different from typing into an empty cell. A row insertion changes the worksheet’s structure, so references and many formulas adjust to account for the shifted cells. Formatting and formulas may also carry into the new row based on nearby rows and Excel’s settings. In a plain range, check the result if the new row needs a particular number format, border, or formula.
It is also different from inserting cells. Inserting only cells can move a portion of a worksheet down or to the right, while inserting a sheet row shifts the entire row. If your records span several columns, inserting a full row is generally the safer choice: it keeps the data in each record aligned.
Insert one row with the ribbon or row header
The row-header method is easy to verify because the row number makes the insertion point clear. In Excel for Microsoft 365 on Mac:
- Find the row number on the left edge of the worksheet where the new row should appear.
- Click that row header to select the entire row. The row number and the row cells should be highlighted.
- Open the Home tab on the ribbon.
- Choose Insert, then choose Insert Sheet Rows. Excel inserts one blank worksheet row above the selection.
You can also Control-click the selected row header and choose Insert from the context menu. On a Mac with a trackpad, a two-finger click may open the same menu if secondary click is enabled. The exact gesture depends on your macOS trackpad or mouse settings, so the ribbon command is a reliable alternative.
To insert a row below a particular record, select the row immediately below that record and insert above it. For instance, to add a row beneath row 12, select row 13 first. If row 12 is the last populated row, select the next worksheet row and insert; the blank row will appear there.
Use the Mac keyboard shortcut
With a worksheet row selected, press Control+Shift+plus (+) to insert a row above it. On many Mac keyboards, producing the plus sign means pressing Shift with the equals key, so the physical key combination may appear as Control+Shift+=. Keyboard layouts can differ, and compact keyboards may handle keys differently; if the shortcut does not work as expected, use Home > Insert > Insert Sheet Rows.
The selection matters. Selecting a row by clicking its row header tells Excel to insert a complete worksheet row. If you select one or more cells instead, the shortcut can open an Insert dialog so you can choose whether to shift cells down or right, or insert a whole row or column. This dialog is useful when only part of a range should move, but it is not the simplest route for adding a record line across the sheet.
Excel for Mac also supports keyboard shortcuts for deleting rows, but take care not to confuse deletion with insertion. If a shortcut opens a dialog or appears to do nothing, cancel rather than guessing; use the ribbon command and confirm the selected row before proceeding.
Insert several rows at once
You can add multiple worksheet rows in one operation. Select the same number of existing row headers as the number of rows you want to add, then choose Home > Insert > Insert Sheet Rows. Excel inserts that many blank rows above the first selected row.
For example, to add three rows above row 10, select row headers 10, 11, and 12, then insert sheet rows. Three new rows appear starting at row 10, and the original rows move down. Selecting just row 10 and repeating the command three times also works, but selecting three headers is faster and reduces the chance of inserting in the wrong location.
To select adjacent rows, click the first row number and drag across the next row headers, or click the first header and Shift-click the last. For nonadjacent rows, insertion behavior may be less intuitive and is not a good way to create a single consecutive block of new rows. Select a continuous block at the insertion point instead. If the new rows must have a precise layout, insert them first and then review the borders, formulas, and data validation in the added area.
Add a row inside an Excel table
An Excel table is a formatted, structured data range with its own header row, filters, and table behavior. Adding a row within the table can extend the table automatically, which is useful because formulas, formatting, and table references may then include the new record. This differs from inserting a worksheet row somewhere else on the sheet.
To add a row within the table, right-click or Control-click a cell in the table at the position where the new record belongs. Use the Insert option and choose the table-row command, such as Table Rows Above, if it appears in the context menu. The wording can vary with the selected cell and Excel build. Check that the new row is inside the table boundaries; a blank worksheet row immediately beneath a table is not always treated as part of the table until Excel expands it.
Another convenient method is to click the last cell in the table’s bottom row and press Tab. Excel creates a new table row when you press Tab from that final cell. This is useful when entering records sequentially, but pressing Tab from another cell simply moves the selection, so make sure you are in the table’s bottom-right cell.
If you want a row between existing table records, add a table row at the intended position rather than creating a blank row outside the table. Keeping records within the table helps filters, calculated columns, and structured references behave consistently. After inserting, verify that the new record has the expected table formatting and that any automatically filled formula is correct.
Choosing between a sheet row and inserted cells
Choose Insert Sheet Rows when the new line represents a complete record and data in the columns should remain together. Suppose a list has a date in column A, a product in column B, and a quantity in column C. Inserting a whole row above a record shifts all three columns together. Inserting cells only in column B could misalign the product from its date and quantity.
Choose an inserted-cell operation only when you deliberately need to make room in part of a worksheet without shifting every column. When selected cells are inserted, Excel asks how to move the existing cells. The choice to shift cells down affects only the selected area, while a full sheet-row insertion affects the entire worksheet. That distinction is especially important on sheets where separate tables sit side by side.
Also consider whether the range is a table, a plain range, or part of a layout with merged cells. Tables have structured boundaries and their own row commands. Merged cells can constrain what Excel can shift, and inserting across a sheet with multiple separate blocks can move or disrupt content you did not mean to change. Save first if the worksheet has a complex layout, then inspect nearby sections after the insertion.
Common problems and how to fix them
- The row appeared in the wrong place: Excel inserts above the selected row. Undo immediately with Command+Z if the result is wrong, then select the row below the intended position and insert again.
- The Insert command is unavailable: The worksheet may be protected, or the workbook may restrict structural changes. Check the Review tab for sheet protection options. If the sheet is protected, you may need permission or the password from the workbook owner before changing it.
- The shortcut opens a dialog: You probably selected cells rather than the row header. Select the row number first, then try the shortcut, or use the ribbon to insert sheet rows.
- The new row is not included in a table: Insert through the table’s row command or add the row at the bottom using Tab in the table’s last cell. Confirm that table filters and formatting extend to the new row.
- Formulas or formatting look unexpected: Excel may copy patterns from nearby rows, but you should not assume every formula or style is correct. Compare the inserted row with adjacent records and adjust it as needed.
If you inserted a row and then made other edits, undo may reverse those edits one at a time before reaching the insertion. You can also delete the unwanted blank row by selecting its row header and using Home > Delete > Delete Sheet Rows, but first confirm it is truly empty and not holding data that shifted into it.
Excel for Mac versus Windows and the web
The row-header approach works similarly across recent desktop versions: select the row, then use the Insert command to place a row above it. In Excel for Mac, the Home ribbon path is Home > Insert > Insert Sheet Rows. Windows uses a similar Home > Insert menu, while the shortcut’s modifier keys differ by platform. Do not substitute a Windows shortcut such as Ctrl+Shift+= for a Mac shortcut without checking which version you are using.
Excel for the web also has row-insertion commands, but its menus and keyboard shortcuts can differ from the Mac desktop app and can be affected by the browser. If you are following Mac desktop instructions, make sure the workbook is open in the Excel app rather than a browser tab. In all versions, selecting the row header before inserting is the clearest way to request a full worksheet row.
Excel updates cell references in many formulas when rows are inserted, but an insertion does not guarantee that every external link, text-based reference, chart, or manually designed layout will behave exactly as intended. For a workbook used for reporting or shared with others, review formulas and downstream reports after changing the structure, especially if the sheet contains separate ranges or references to fixed positions.
Frequently Asked Questions
How do I insert a row above the current row in Excel for Mac?
Select the row number, then choose Home > Insert > Insert Sheet Rows. Excel inserts the new row above the selected row.
What is the shortcut to insert a row in Excel on a Mac?
Select the row header and press Control+Shift+plus (+). Depending on the keyboard layout, the plus may require the equals key with Shift. The ribbon command is the dependable fallback.
How do I insert a row below instead of above?
Select the row immediately below the place you want the new row, then insert. Excel places the new row above the selected row.
Can I insert more than one row at a time?
Yes. Select as many row headers as the number of rows you want to add, then use Insert Sheet Rows. Excel inserts that number of rows above the first selected row.
How do I add a row to an Excel table on Mac?
Use the table’s Insert row command at the desired position, or press Tab from the table’s bottom-right cell to create a new bottom row. Confirm the new row is part of the table.
Why can’t I insert a row in my worksheet?
The sheet may be protected, the workbook may limit editing, or the selected range may contain merged cells that prevent the operation. Check protection settings and selection, and ask the workbook owner for access if needed.
Related
- Excel Data Validation Icon: What It Looks Like and Does
- Data Validation Multiple Selection in Excel: What Works
- Data Validation Interview Questions and Strong Answers
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Filtering in Google Sheets: How to Narrow and Sort DataTo filter data in Google Sheets, select a cell in your table and choose Data > Create a…
- Excel Keyboard Shortcut to Jump to the End of a ColumnIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the bottom edge of the…
- Excel Geographical Heat Map: Create and Troubleshoot OneIn Excel for Microsoft 365 on Windows, select a column of named geographic regions and a column of…
- Page Break in Excel Shortcut: Insert and Adjust BreaksIn Excel for Microsoft 365 on Windows, select the row, column, or cell where the printed page should…
- How to Insert a Checkbox in Microsoft Word: Two WaysTo insert a checkbox in Microsoft Word, use Developer > Check Box Content Control for a box readers…
- Apply Conditional Formatting to an Entire Column in ExcelYes. In Excel for Microsoft 365 on Windows, select the column or the range you want to format,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.