In Excel for Microsoft 365 on Windows, select a cell in the table row and press Ctrl+Shift+= (the Ctrl+Plus shortcut). If Excel opens an Insert dialog, choose the option for inserting a table row above; for a dependable menu method, right-click the row and choose Insert > Table Rows Above.
The Excel shortcut and what it does
The shortcut commonly described as Ctrl++ means holding Ctrl and pressing the plus key. On a standard keyboard, plus shares the equals key, so the keystroke is usually written Ctrl+Shift+=. It invokes Excel’s insert command. What gets inserted depends on what you selected: a cell, a worksheet row, or a row inside an Excel table.
For a table, start by selecting a cell in the row where you want the new row to appear. The insert command may show a dialog or a contextual choice, depending on the selection and Excel build. If you see a choice specifically for a table row above, select it. If the dialog only offers worksheet-cell options, cancel and use the table-specific menu command instead. This distinction helps avoid shifting neighboring worksheet cells unintentionally.
To make the selection more explicit, click a cell in the table row and press Shift+Space to select the table row, then use Ctrl+Shift+=. Excel may insert a worksheet row when the whole worksheet row is selected; within the table’s boundaries, that row is incorporated into the table. If your layout includes other data beside the table, check the result so you know whether Excel inserted only a table row or a full worksheet row.
How to insert a row above or below
Excel’s table-specific insert command adds a row above the selected row. For example, if a sales table has headers in row 1 and the first product in row 2, select a cell in row 2 and choose Insert > Table Rows Above. The new blank row appears between the header and the first product. The existing data moves down, and the table’s range expands to include the new row.
To add a row at the bottom, you usually do not need the insert shortcut. Click the last cell in the table’s final row and press Tab. Excel creates a new table row when you tab forward from that last cell. This is useful when entering records one after another, because the new row inherits the table’s structure and can continue calculated-column formulas.
Another way to add a row at the bottom is to begin typing directly in the first blank row immediately below the table. Excel typically expands the table to include the entry. If it does not, use the table resize handle or a table-specific insert command. Avoid assuming that typing anywhere below the table will expand it: nearby content or blank rows can affect Excel’s decision.
Use the table-specific menu for a predictable result
If you want to be certain you are adding a table row rather than shifting a whole worksheet row, use the contextual command. Right-click a cell in the table row that should move down, choose Insert, then choose Table Rows Above. The wording matters: options such as inserting entire worksheet rows affect the sheet grid, while Table Rows Above targets the table.
You can also use the ribbon. Select a cell in the table, open Home > Insert, and choose the table-row insertion option if it is available in the menu. Menu choices can vary with selection and Excel version. If you do not see a table-specific option, the right-click menu on a table cell is a good place to check. Inserting from within the table also helps Excel carry over table formatting and calculated-column behavior.
- Insert above a particular record: select that record’s table row and use Table Rows Above.
- Add a record at the end: press Tab from the last cell of the last table row.
- Add several rows: select the same number of table rows first, then use the insert command; check that Excel added the intended count.
What happens to formulas, formatting, and filters
An Excel table is more than a range with colored cells. It has a defined boundary, header row, table styles, and features such as filter buttons and structured references. When you add a row as part of the table, Excel generally applies the table style to the new row and keeps the filter controls on the headers. If a calculated column is set up consistently, Excel can fill its formula into the new row.
For example, a table might have Product, Quantity, and Unit Price columns, plus a calculated Total column. Inserting a table row usually preserves the table layout and gives the new record the same column structure. It does not guarantee that every custom formula, manually applied format, or data-validation rule will behave exactly as intended, especially if the column contains inconsistent formulas. Review the new row before relying on it.
Adding a row inside a filtered table is still possible, but the visible position can be confusing. A filter may hide records, so a new row inserted above a visible record is not necessarily adjacent to that record in the underlying unfiltered order in the way you expect. If row order matters, clear or inspect the filter and sort settings after insertion. The new record may also be hidden by an active filter if its values do not meet the filter criteria.
Common problems and how to fix them
- The shortcut inserts cells or shifts worksheet data. The selection may not be a table row, or Excel may be presenting a general Insert dialog. Cancel if the choices do not clearly target the table, then right-click inside the table and choose Table Rows Above.
- The plus shortcut seems not to work. On many keyboards, plus requires Shift with the equals key. Try
Ctrl+Shift+=. Keyboard layouts differ, so the menu command is a useful fallback. - The new row appears outside the table. Check whether you selected a cell inside the table boundary. If you typed below the table, Excel may not have expanded it. Use the table’s insert command or resize the table to include the row.
- Formulas or formatting did not carry over. Check whether the column is a consistent calculated column and whether the new row is actually part of the table. Copy a correctly formatted table row or correct the formula and formatting as needed.
- The whole sheet seems to move. You may have selected a worksheet row rather than a table row. Undo immediately with
Ctrl+Zif the change is unwanted, then select a cell in the table and use the table-specific command.
Before inserting into a worksheet with data immediately below or beside the table, look at the surrounding cells. A table-only insertion preserves other worksheet content in place; a full worksheet-row insertion shifts cells across the sheet. Choosing the right operation avoids gaps or displaced data.
Excel for Mac and Excel for the web
In Excel for Mac, the insert shortcut is commonly Control+Shift+=, but the exact key combination can depend on the keyboard layout. It is not generally the Windows Ctrl key on a Mac keyboard: use the Control key as shown, rather than assuming Command is interchangeable. If the shortcut behaves differently on your setup, use the table’s right-click menu and select the table-row insertion option.
Excel for the web runs in a browser, where some key combinations can be affected by browser or operating-system shortcuts. The table’s contextual menu or the ribbon’s Home > Insert menu is often easier to verify there. If a keyboard shortcut is intercepted or opens an unrelated browser action, use the menu rather than repeatedly trying alternate combinations.
Across versions, keep the same distinction in mind: a table row is part of the structured table, while a worksheet row spans the sheet. The command’s wording and the current selection determine which kind of row Excel inserts.
Which method should you choose?
Choose the shortcut when you are comfortable checking Excel’s insert choices and want to work quickly. Use the table-specific right-click command when accuracy matters more than speed, particularly on a worksheet with other populated columns. Use Tab from the final table cell when you are entering the next record at the bottom.
For a batch of new records, decide whether they belong in the middle or at the end. Select several table rows before inserting if you need multiple blank rows above a particular record; verify the inserted count and the table boundary afterward. For records at the end, repeatedly tabbing from the final cell or pasting into the next blank table row may be more convenient. When pasting, confirm that the table expanded and that formulas and formatting are present.
Frequently Asked Questions
What is the shortcut to insert a row in an Excel table?
On Windows, use Ctrl+Shift+= (Ctrl+Plus) after selecting the relevant table row or cell. If Excel does not offer a table-row insertion choice, use the right-click menu and choose Insert > Table Rows Above.
How do I insert a row below the selected table row?
Excel’s table-specific command inserts above the selected row. To insert below a record, select the next table row and insert above it. For a new final row, press Tab from the last cell of the table.
Does Ctrl+Plus insert a table row or a worksheet row?
It depends on the selection and the insert option Excel applies. A worksheet row spans the sheet; a table row is confined to the table. Check the dialog or menu wording, and choose Table Rows Above when you want the table-only operation.
Will an inserted table row copy formulas automatically?
Excel often fills formulas in a consistent calculated column and applies the table style, but this is not guaranteed for every manually edited or inconsistent column. Review the new row’s formulas and formatting.
Can I add a table row without using the Insert command?
Yes. Press Tab from the last cell in the table’s last row to create a new row at the bottom. You can also type in the blank row directly below the table, then check that Excel expanded the table to include it.
Related
- Excel Ordinal Number Format: Show 1st, 2nd, and 3rd
- Excel or Word for a Checklist? Compare the Best Fit for You
- Excel Order List Template: How to Build and Use One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Import Multiple CSV Files: Methods and TipsTo import multiple CSV files into Excel for Microsoft 365 on Windows, put the files in one folder,…
- How to Add Chicago Style Footnotes in Microsoft WordTo add a Chicago-style footnote in Word, place the cursor after the passage you are citing, then choose…
- Google Sheets COUNTIF Range: Syntax, Examples, and FixesIn Google Sheets, COUNTIF counts cells in a range that meet one condition. The basic formula is =COUNTIF(A2:A20,"Open");…
- Excel Consolidate and Empty Cells: What Happens?Yes—Excel’s Data > Consolidate command can combine ranges that contain empty cells. With Sum, a blank contributes no…
- How to Make a Monthly Budget Plan in Google SheetsTo make a monthly budget plan in Google Sheets, create columns for spending categories, planned amounts, and actual…
- Excel Dependent Drop-Down Lists Based on Cell ValuesYes. In Microsoft Excel for Microsoft 365 on Windows, you can make a data validation list depend on…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.