To insert a row in Excel for Microsoft 365 on Windows, click the worksheet row number where the new row should go, right-click it, and choose Insert. Excel adds a blank row above the selected row. You can also use Home > Insert > Insert Sheet Rows or select a row and press Ctrl+Shift+=.
What inserting a row does
Excel worksheets are arranged in numbered rows and lettered columns. Inserting a worksheet row adds a horizontal space across the sheet and shifts existing rows below the insertion point downward. For example, if you insert a row at row 5, the old row 5 becomes row 6, the old row 6 becomes row 7, and so on. The new row is initially blank unless Excel carries formatting or formulas into it based on nearby cells.
This differs from entering information into an empty row that already exists. Inserting a row changes the positions of existing worksheet cells; typing into an unused row does not move anything. Choose insertion when you need to make room inside a list or between existing records, such as adding a new employee between two names. If an empty row is already where you want it, simply entering data there may be all you need.
Excel worksheets have a fixed row limit of 1,048,576 rows. Inserting rows near the bottom of a sheet can therefore fail if it would push populated cells past that limit. For most ordinary lists, the limit is unlikely to be an issue, but it matters in very large data sets.
Three ways to insert one worksheet row
Each method inserts a row above the selected position. Pick the row that should move down, not the row that should appear above the new blank space.
- Use the row-heading menu: Click the number at the left edge of the target row to select the entire row. Right-click the selected row heading, then choose Insert. This is often the easiest method because the selection makes the insertion point visible.
- Use the ribbon: Select a cell in the row that should move down. On the Home tab, open the Insert menu in the Cells group and choose Insert Sheet Rows. Selecting the whole row first also works.
- Use the keyboard: Click a cell in the target row and press Shift+Space to select its entire worksheet row. Then press Ctrl+Shift+= on Windows. On a keyboard where the plus sign shares the equals key, hold Shift to type the plus. If Excel displays an Insert dialog, choose Entire row and confirm.
Using the row heading is a good default when you are learning Excel or working with a complex sheet. It reduces the chance of inserting only a few cells and leaving the rest of the data misaligned.
Insert several rows at once
You do not have to repeat the insertion command separately for every blank row. Select as many existing worksheet rows as you want to add, then use right-click > Insert or Home > Insert > Insert Sheet Rows. Excel inserts the same number of rows above the first selected row.
For example, to add three rows above row 8, select the row headings 8, 9, and 10, then choose Insert. Excel creates three blank rows starting at row 8 and shifts the previous rows 8 and below downward. The original contents of rows 8, 9, and 10 are not overwritten; they move down together with the rest of the data.
To select adjacent rows, click the first row number and drag down to the last, or click the first and Shift-click the last. To select separate, nonadjacent rows, hold Ctrl while selecting row headings on Windows. Inserting nonadjacent selections can be less intuitive, so for a contiguous block it is usually simpler to select that block and insert once.
Worksheet rows and Excel table rows
A formatted Excel table is a structured data range with features such as filter buttons and table-specific formatting. A table row is part of that range; a worksheet row spans the entire sheet. If your cursor is inside a table, you can add a row within the table without treating the task exactly like an ordinary list.
To add a table row above a particular record, right-click a cell in that table row and choose Insert > Table Rows Above. You can also use Home > Insert and select Insert Table Rows Above when that table-specific command is available. The new row becomes part of the table, so its filters, structured references, and table styling can apply to it.
To add a record at the bottom of a table, click the last cell in the table and press Tab. Excel creates a new table row when you tab out of that final cell. If you type directly in the worksheet row immediately below a table, Excel will often expand the table to include the new data, but check that the table boundary actually expanded. A table row is usually preferable for new records because it keeps the record within the table’s sorting and filtering range.
What happens to formatting and formulas
When a row is inserted between populated rows, Excel may carry formatting into the new row from nearby cells. The exact result can depend on the surrounding formatting and how the row was inserted. A new row might inherit a border, number format, fill color, or table style. If the result is not what you want, use the Insert Options button that appears near the inserted area, where available, to choose a formatting option such as matching the formatting above or below, or clearing formatting.
Formulas and cell references often adjust when rows are inserted. For example, if a total formula refers to a range of cells and you insert a row within that range, Excel may extend the reference to include the new position. However, you should not assume every formula or outside connection will update exactly as intended. A formula that contains a hard-coded row number as text, a chart tied to a fixed range, or an import process may need separate review.
After inserting a row in a calculation-heavy workbook, inspect the formulas and totals near the insertion point. If the sheet has charts, named ranges, data validation, conditional formatting, or linked reports, check those as well. A quick visual scan can reveal a missing border or an unexpected blank, while reviewing totals can help catch a range that did not include the new data.
Choosing the right insertion point
Before inserting, identify the row that should move down and confirm that it is the intended location. This is especially useful in a sorted list: adding a record in the middle does not automatically put it in alphabetical or date order. You may need to sort the list again after entering the new information. If the range is an Excel table, use its sort controls or the Data tab’s sorting options rather than assuming a new row is automatically placed correctly.
- Adding a record between two records: Select the lower record’s row and insert above it.
- Adding space at the top of a list: Select the first data row and insert above it. If the top row contains column headings, select the first data row below the headings instead.
- Adding a record at the end: For an Excel table, use the last-cell Tab method. For a regular range, enter data in the next blank row if it is available; insertion is unnecessary unless you need to shift existing content.
- Adding a note or divider: Consider whether a blank row will interfere with filters, charts, or formulas. Tables generally work best when records remain in one continuous block.
Excel for Mac and Excel for the web
In Excel for Mac, the basic mouse method is similar: select the row heading, Control-click or right-click it, and choose Insert. The ribbon also provides row insertion from the Home tab through Insert. Keyboard behavior can vary with the Mac keyboard layout and Excel version, so use the row-heading menu or ribbon if a Windows shortcut does not work. On a Mac laptop, an external keyboard or system-level key settings can also affect which keys are available.
In Excel for the web, select a row heading and use its context menu to insert a row, or use the ribbon’s Home > Insert options. The browser and operating system may reserve some keyboard combinations, so the menu is a dependable alternative. In either Mac or web editions, confirm that the command says it will insert a worksheet row or a table row as intended, particularly when your selection is inside a table.
Common problems and how to fix them
- The new row appeared in the wrong place: Excel inserts above the selected row. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the correct row and insert again.
- Only a few cells moved: You probably selected cells rather than the row heading. Undo, select the numbered row heading, and use the row insertion command. Inserting cells can shift only part of a worksheet and misalign related data.
- The Insert command is unavailable: The worksheet may be protected, the workbook may be in a restricted editing state, or the selection may include a merged-cell layout that prevents the requested change. Check the Review tab for worksheet protection options, and review whether the sheet is meant to be edited before changing its protection.
- Rows seem to be missing: A filter or hidden rows may make the sheet’s visible sequence skip numbers. Clear or inspect filters and hidden rows before deciding where to insert. Row numbers that jump do not necessarily mean Excel deleted the intervening rows.
- The new row has unexpected formatting: Use the nearby Insert Options control if it appears, or adjust the new cells’ formatting after insertion. In a table, table style settings control much of the appearance.
If a workbook is shared or used as a template, consider whether other people, formulas, or connected reports depend on the existing layout. Inserting a row is a normal spreadsheet operation, but a sheet with protection, external links, or carefully defined print areas may have additional rules. If the command is blocked, check with the workbook owner rather than bypassing safeguards.
Undoing an insertion and checking the result
If the row was inserted accidentally and you have not made other changes since, use Ctrl+Z on Windows or Command+Z on Mac. Undo reverses the insertion and restores the shifted cells. If you have made several changes afterward, review the undo sequence before using it, because undoing multiple actions can also remove those later edits.
Once the row is in the right place, enter the new values and verify that each item is in the correct column. Check whether the row should be included in totals, charts, filters, and print layouts. If you inserted several rows, confirm the count and inspect the first and last rows of the new block. Saving after reviewing the change is sensible when editing an important workbook.
Frequently Asked Questions
Does Excel insert a new row above or below the selected row?
Excel inserts a worksheet row above the selected row. Select the row that should move down to place a blank row before it.
Can I insert more than one row at a time?
Yes. Select the same number of row headings as the number of rows you want to add, then choose Insert. Excel inserts that number above the first selected row.
What is the keyboard shortcut to insert a row in Excel?
On Windows, select a row and press Ctrl+Shift+= (the plus key). If Excel opens an Insert dialog, choose Entire row. Shortcuts can differ on Mac, so the row-heading context menu is a reliable option there.
Will inserting a row change my formulas?
Excel often adjusts cell references when rows are inserted, but formulas, charts, named ranges, or external links may not all behave alike. Review important calculations and ranges after the change.
How do I add a row to an Excel table?
To add one above a table record, right-click a cell in that record and choose Insert > Table Rows Above. To add one at the bottom, press Tab from the table’s last cell.
Related
- Goal Seek in Excel Browser: Limits and Workarounds
- Goal Seek Button in Excel: Where It Is and How to Use It
- Goal Seek in Excel: How to Find the Input You Need
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Conditional Formatting for Dates After TodayTo highlight dates after today in Excel for Microsoft 365 on Windows, select the date cells, choose Home…
- How to Insert a Table of Contents in Microsoft WordTo insert an automatic table of contents in Microsoft Word for Microsoft 365 on Windows, apply built-in heading…
- How to Make Serial Numbers in Excel: 4 Easy MethodsTo make serial numbers in Excel, enter 1 and 2 in the first two cells, select both, then…
- Where to Create Rules in OutlookCreate Outlook rules in the Rules settings for your version: in classic Outlook for Windows, go to Home…
- How to Close an Excel Sheet With a Keyboard ShortcutTo close the active Excel workbook in Microsoft 365 for Windows, press Ctrl+W. On a Mac, press Command+W.…
- Excel Conditional Formatting Icon Sets ExplainedConditional formatting icon sets are Excel rules that place symbols—such as arrows, traffic lights, or flags—beside cell values…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.