How to Insert a Row in Excel Above a Selected Cell

To insert a worksheet row above a cell in Excel for Microsoft 365 on Windows, select any cell in the row where the new row should appear, then choose Home > Insert > Insert Sheet Rows. Excel adds a blank row above it and moves the existing rows down. If you meant adding a new line inside the text of a cell, press Alt+Enter while editing that cell instead; that creates a line break, not a worksheet row.

What You’ll Need

An Excel workbook open in Microsoft Excel for Microsoft 365 on Windows. The same basic row-insertion options are available in current Excel for Mac and Excel for the web, though menus and shortcuts can differ slightly.
A clear idea of where the new row should go. Excel inserts a worksheet row above the row containing your selected cell, not directly inside that individual cell.
If you are editing important data, save the workbook first or make a copy. Inserting a row is usually reversible with Ctrl+Z, but a saved backup is useful if you continue making other changes afterward.

Step-by-Step

Open the worksheet and locate the intended position. Find the row above which you want the blank space. For example, if a new record needs to go between the current rows 7 and 8, select a cell in row 8. Excel inserts the new row above row 8, so the existing row 8 and everything below it move down by one. Do not select row 7 if you need the new row after it; selecting row 7 would put the blank row above row 7.
Select a cell in the target row. Click any cell in the row that should move down. The cell does not need to be at the left or right edge of your data. If the new row belongs above row 8, clicking B8, F8, or another cell in row 8 is enough. Check the row number at the left of the worksheet before continuing, especially when the sheet is zoomed out or contains hidden rows.
Insert the row with the ribbon. Go to Home > Insert > Insert Sheet Rows. Excel inserts one complete worksheet row above the active cell’s row. This is a good method when only one cell is selected because the command makes clear that you want a sheet row, rather than shifting only a few nearby cells. If the ribbon is collapsed, click Home to show its commands, then open the Insert menu.
Alternatively, use the row heading. Click the numbered row heading on the far left, such as the number 8, to select the entire row. Right-click that heading and choose Insert. The inserted row appears above the selected row. This approach is especially useful when you want to verify that the whole row, rather than a single cell or range, is selected. You can also select several adjacent row headings first; choosing Insert then adds the same number of rows above the first selected row.
Use the keyboard if that is faster. With a cell in the target row selected in Windows, press Ctrl+Shift+Plus. On keyboards where the plus sign requires Shift, this is commonly typed as Ctrl+Shift+=. If Excel opens an Insert dialog rather than inserting immediately, choose Entire row and confirm. If you have selected the row heading first, the shortcut inserts a row above it. On Mac, use Control+Shift+= where supported by your keyboard layout; if the shortcut does not work, use the ribbon or row-heading right-click method instead.
Check the result before entering data. The new row should be visible above the row you selected, and the original selected row should now have a row number one greater than before. Confirm that the intended data moved down together. Excel normally adjusts many formulas and cell references when rows are inserted, but inspect important totals, charts, and formulas before relying on the updated sheet.
Enter the new record or information. Click the appropriate cells in the new row and type your values. For a list with headings such as Date, Item, and Amount, enter each value in the matching column. If you are adding a record to a formatted Excel table, check that the new row is included in the table and inherits the expected formatting and formulas.
Undo if the row landed in the wrong place. Press Ctrl+Z on Windows immediately after the insertion, or use the Undo button on the Quick Access Toolbar. Then select a cell in the correct target row and insert again. If you have already made several changes, review them before undoing repeatedly so you do not remove edits you intended to keep.

When working in an Excel table: A table is a formatted data range with its own header and filtering controls. If the new record belongs inside a table, click a cell in the table row that should move down, then use Home > Insert and choose Insert Table Rows Above if that option is shown. You can also right-click a table cell and look for Insert, then Table Rows Above. The exact context-menu wording can vary with the selected cell and Excel version. If you choose Insert Sheet Rows instead, Excel inserts a full worksheet row; verify that the table expands as intended. For a new record at the bottom of a table, typing in the first blank row directly below it often expands the table automatically.

Common Mistakes

Expecting a row to appear inside one cell. Worksheet rows span the sheet from left to right; they cannot be placed inside a single cell. If you want two lines of text in one cell, edit the cell and press Alt+Enter on Windows. On Mac, the line-break shortcut is Control+Option+Return. Turn on Wrap Text if the second line is not fully visible.
Selecting the row below or above the intended location. Excel inserts above the selected row. If you need a row between rows 7 and 8, select row 8, not row 7. After inserting, use the row numbers as a quick check before typing information.
Choosing Insert Cells instead of inserting a sheet row. When a single cell is selected, a keyboard shortcut or context menu may show an Insert dialog with options to shift cells right, shift cells down, insert an entire row, or insert an entire column. Choosing Shift cells down affects only a selected area and can misalign the surrounding data. Choose Entire row when your goal is a full worksheet row.
Inserting into a structured table without checking the table boundary. Tables have their own row behavior, filters, calculated columns, and formatting. Use the table-specific Insert Table Rows Above command when available, and confirm the new record remains part of the table. A row inserted outside the table may not receive its filters, formulas, or table style.
Assuming formatting and formulas will always copy exactly as expected. Excel often carries formatting into an inserted row and adjusts references, but results depend on nearby content, table settings, and formula types. Review number formats, conditional formatting, formulas, and totals after insertion, particularly in a workbook used for reporting.
Inserting a row while a filter hides records. A filtered list may make it harder to tell which worksheet row is selected and where the new row will appear. Check the row heading and consider clearing or adjusting the filter first if the placement is unclear. Inserting a sheet row does not necessarily mean the row will be visible under the current filter criteria.

Tips

Insert several rows in one action. Select the same number of row headings as the number of blank rows you need. For example, select headings 8, 9, and 10, then right-click and choose Insert. Excel adds three rows above the first selected row. This is quicker and usually less error-prone than repeating a single-row insertion three times.
Use the row heading when precision matters. Clicking the numbered heading makes the entire worksheet row selection visible. It reduces the chance of choosing an option that shifts only part of the data, particularly in sheets with blank columns or separate blocks of information.
Keep related information together. When a record spans multiple columns, insert a complete row rather than creating space in just one column. This preserves the alignment between values such as a customer name, order date, and status. After insertion, enter information in the correct columns and check that formulas or validation rules are present.
Know the difference between a row and a line break. Use Insert Sheet Rows to add horizontal space across the worksheet. Use Alt+Enter inside a cell to put text on another line, such as an address with a street on one line and a city on the next. Increasing the row height or applying Wrap Text may be needed to display multiple lines clearly.
Inspect dependent items in complex workbooks. Inserting rows can affect formula references, named ranges, charts, print areas, and summaries. Excel updates many direct references automatically, but verify the workbook sections that matter to your task. If the sheet is shared or part of a controlled report, communicate the structural change to others who use it.
Save after confirming the layout. Once the new row is in the right place and the data looks correct, save the workbook. If you are experimenting in a template or shared file, consider using Save As to keep an untouched original.

Troubleshooting

The Insert command is unavailable or greyed out. The worksheet may be protected, the workbook may be in a restricted editing state, or the selection may not be suitable. Check Review > Unprotect Sheet if you have permission and the sheet is protected; a password may be required. If the workbook is read-only, save an editable copy or ask the owner for access. In a shared workbook, check whether you have permission to make structural changes.

Excel shifts only a few cells instead of inserting a full row. Undo the change with Ctrl+Z. Select the row number at the left edge and choose Insert, or return to Home > Insert > Insert Sheet Rows. If you use the Insert dialog from a cell selection, select Entire row rather than Shift cells down or Shift cells right.

The new row appears in an unexpected place. Look at the active cell and its row number before inserting again. Excel places the new row above that cell’s worksheet row. If filters, hidden rows, or frozen panes make the position difficult to judge, temporarily clear filters or unhide the nearby rows. Insert only after confirming which visible record corresponds to the worksheet row number.

The inserted row has missing formulas or formatting. First check whether the range is an Excel table. Table formulas and styles generally extend when a table row is inserted inside the table, but ordinary ranges may not copy every rule in the way you expect. Compare the new row with the row above or below it, then copy the appropriate formula or formatting if necessary. Use Paste Special carefully so you do not replace values or formulas that should remain different.

The row is inserted but not visible in a filtered list. A filter may hide rows that do not meet its criteria, and a newly inserted blank row may not appear among the visible results. Clear the filter temporarily, check the row in the worksheet, and then enter values that meet the filter criteria. If the row is inside a table, confirm that the table range includes it.

The keyboard shortcut types a symbol or does nothing. Keyboard layouts differ, and the plus sign may require Shift or a separate numeric keypad key. Select the row heading and use the ribbon or right-click method as a dependable alternative. On Mac, try the supported Control+Shift+= shortcut for your keyboard, or use the Insert menu if the shortcut is intercepted by the system.

Frequently Asked Questions

Can I insert a row directly into one Excel cell?
No. A worksheet row extends across the worksheet, so it cannot exist inside an individual cell. To add another line within a cell, edit the cell and use Alt+Enter on Windows, or Control+Option+Return on Mac. For a new horizontal record across columns, insert a worksheet row.

Does Excel insert a row above or below the selected cell?
It inserts the row above the selected cell’s worksheet row. To place a blank row between rows 12 and 13, select a cell in row 13 and insert. The existing row 13 moves down to row 14.

How do I insert more than one row at a time?
Select the same number of row headings as the number of rows you want to add, then right-click the selection and choose Insert. Selecting four row headings inserts four blank rows above the first selected heading. Check the selection before confirming so the number of inserted rows is correct.

Will formulas update when I add a row?
Excel adjusts many formula references when a worksheet row is inserted, but the outcome depends on how the formulas and data are structured. Check totals, ranges, charts, and named ranges after inserting, especially if the workbook uses complex formulas or references to other sheets.

How do I add a row to an Excel table rather than the whole sheet?
Select a table cell in the row that should move down and choose Insert Table Rows Above from the Insert options when available. You can also add a new record in the first blank row below the table; Excel commonly expands the table automatically. Confirm the table boundary and calculated columns afterward.

Can I undo an inserted row?
Yes. Immediately press Ctrl+Z on Windows or use Undo on the Quick Access Toolbar. On Mac, use Command+Z. Undo works best before making unrelated changes; if you have already edited other cells, check the undo history so you do not remove work you want to keep.

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.