To insert a blank row in Excel on a laptop, select the row number where you want the new row, right-click it, and choose Insert. Excel places a blank row above the selected one and moves existing rows down. You can also use Home > Insert > Insert Sheet Rows or a keyboard shortcut. These steps are for Microsoft Excel for Microsoft 365 on Windows; the same ribbon and right-click options are available in most recent Excel versions.
What You’ll Need
- A laptop with Excel open and the workbook you want to edit.
- Permission to make changes to the workbook. If it is read-only or protected, you may need to enable editing or ask the owner to allow row insertion.
- A saved copy of important data, especially if you are working in a shared or business-critical workbook. Inserting a row is normally reversible with Undo, but a backup is useful protection against other edits.
Step-by-Step
- Open the worksheet and choose where the row belongs. Find the rows around the location where you want to add space. Excel inserts a new worksheet row above the row you select. For example, to add a row between rows 8 and 9, select row 9. If the new row should go at the top of your data, select the first data row, not the column-heading row, unless you intend to push the headings down too.
- Select the row using its number. On the far left of the worksheet, click the gray row heading containing the row number. The entire row should become highlighted. Selecting the heading is the clearest way to ensure Excel inserts a whole worksheet row rather than opening a dialog for inserting individual cells. On a laptop trackpad, a two-finger click usually opens the context menu; a mouse right-click works too.
- Insert the row from the context menu. With the row heading selected, right-click the heading and choose Insert. Excel adds one blank row directly above the selected row. The row numbers below it increase by one, and existing content moves down rather than being overwritten. If you do not see Insert, check that you right-clicked the row heading and not a cell or a selected object.
- Use the ribbon if you prefer not to right-click. Select the row heading, open the Home tab, and in the Cells group choose Insert > Insert Sheet Rows. The wording may appear as Insert Sheet Rows in the menu. This inserts an entire worksheet row above the selected row. If the Excel window is narrow, the Cells controls may be compact or grouped; maximize the window or look for the Insert dropdown on the Home tab.
- Try the keyboard shortcut on Windows. Click a cell in the row where the new row should go, then press Shift+Space to select the whole row. Press Ctrl+Shift+= (the plus sign on many laptop keyboards is typed with Shift and the equals key). If Excel opens an Insert dialog, choose Entire row and confirm. Depending on the keyboard layout, the shortcut may be described as Ctrl+Shift+Plus; if the key combination is awkward or does not work, use the row-heading or ribbon method instead. A browser or another application can sometimes intercept shortcuts in Excel for the web.
- Enter information in the new row. Click the first cell in the new row and type your first value, then press Tab to move across the row. For a list with headings in row 1 and records below, add the new record in the appropriate position without replacing the headings. If the row is part of a formatted range or Excel table, check whether formatting and formulas have carried into the inserted row.
- Check the result before continuing. Verify that the blank row is in the right place, that no existing values were replaced, and that formulas or totals still refer to the intended data. Press Ctrl+Z once if you inserted it in the wrong position, then repeat the steps using the correct row heading. Avoid making several unrelated edits before checking, because Undo reverses the most recent actions one at a time.
To insert more than one row: Select the same number of adjacent row headings as the number of rows you need, then choose Insert. For example, select row headings 9, 10, and 11 to insert three rows above row 9. Excel inserts the same count of blank rows as the number of headings selected. Selecting nonadjacent rows is not the dependable way to add a continuous block; select adjacent headings together.
To insert a row in an Excel table: A table is the formatted data area with filter arrows in its headers. Right-click a cell in the table row that should move down and choose Insert > Table Rows Above, if that option is shown. This adds a row within the table so its formatting and calculated-column formulas can extend. If you use the worksheet row heading instead, Excel inserts a full sheet row, which may also affect other content elsewhere on that row.
Common Mistakes
- Clicking a cell and typing instead of inserting. Typing into a selected cell replaces its contents. First select the row heading and use Insert; do not type into the row you mean to move.
- Selecting the wrong row. Excel inserts above the selection, not below it. To place a row after row 12, select row 13. If row 13 is hidden, unhide it or use a visible row heading at the correct location before inserting.
- Choosing Insert Cells instead of Insert Sheet Rows. Selecting just one or more cells can bring up an Insert dialog with options to shift cells right, shift cells down, insert an entire row, or insert an entire column. Shifting a few cells can misalign a dataset. Select the row heading or choose Insert Sheet Rows when you need a complete worksheet row.
- Inserting a worksheet row when you only need a table row. If your data is an Excel table, use the table-specific row option to keep the new record inside the table. A worksheet row affects the whole sheet and can disturb notes or separate data placed in other columns on the same row.
- Assuming a blank-looking row is empty. A row may contain hidden values, formulas, or formatting even if it appears blank. Inserting a row moves that content too. Check the surrounding area and consider whether hidden rows or columns affect where the new row should go.
Tips
- Save before making structural edits. Press Ctrl+S on Windows. In a workbook stored in OneDrive or SharePoint, AutoSave may be on, but you should still confirm the change is in the intended file and has synced.
- Use row headings for the least ambiguous method. Selecting the gray number area makes the whole row selection visible and avoids accidentally shifting only part of a table.
- Insert several rows at once when you know the number needed. Selecting three row headings and inserting once is quicker than inserting a row repeatedly. Confirm the selected headings are adjacent and start at the right position.
- Check totals and references after adding a row. Excel often adjusts formulas when rows are inserted, but workbook structure matters. Review nearby totals, charts, named ranges, and formulas, particularly if the sheet uses manually selected ranges or data from multiple sections.
- Use Undo immediately if the result is wrong. Ctrl+Z reverses the insertion on Windows. On Mac, use Command+Z. Undo is most reliable before you make additional edits or close the workbook.
- For Mac users, use the menus if a shortcut differs. The row-heading right-click menu and Home tab insertion options are practical alternatives across keyboard layouts. On a Mac trackpad, use a two-finger click or Control-click to open the context menu. Shortcut behavior can vary with Excel version and keyboard settings.
Troubleshooting
Insert is unavailable or grayed out: The worksheet may be protected, the workbook may be opened read-only, or the file may have restrictions. Check the title bar for a read-only notice and look on the Review tab for sheet protection controls. If you own the file, use Review > Unprotect Sheet when available and enter the password if prompted. If you do not know the password or lack editing permission, ask the workbook owner rather than trying to work around the restriction.
The new row appears in the wrong place: Remember that Excel inserts above the selected row. If it is safe to undo, press Ctrl+Z, select the row heading below the intended position, and insert again. If you have already made important edits, do not undo blindly; inspect the sheet and move or restore data carefully.
The keyboard shortcut does nothing: Confirm that Excel has focus and that the entire row is selected. On many Windows laptop keyboards, the plus sign requires Shift+=, so the full shortcut is Ctrl+Shift+=. Keyboard layouts vary, and browser shortcuts can interfere in Excel for the web. Use the context menu or ribbon path instead; these do not depend on the plus-key layout.
Only some cells moved or the row looks misaligned: You may have chosen to shift cells rather than insert an entire row. Undo if appropriate, select the row number, and choose Insert, or use Home > Insert > Insert Sheet Rows. Check whether merged cells in the affected area are preventing the operation or producing an unexpected layout; merged cells can limit how Excel shifts cells, so unmerge only if you understand how that will affect the worksheet.
The row is inserted but formulas or formatting look different: Excel may copy formatting from a neighboring row or extend table formulas automatically. Inspect the cells and compare them with the rows above and below. If the new row is in a table, confirm it is included in the table boundaries. Use the small insertion options button that may appear near the inserted row to choose a suitable formatting option, or apply the desired formatting from a neighboring row.
You cannot see the new row: A filter may be hiding rows that do not meet its criteria, or the inserted row may itself be hidden. Clear or adjust filters from the Data tab, or inspect the row numbers for a jump that indicates hidden rows. You can also select the surrounding row headings, right-click, and choose Unhide if that command is available.
Frequently Asked Questions
Does Excel insert the new row above or below the selected row?
Excel inserts it above the selected row. To add a row between rows 5 and 6, select row 6 and insert. To add one after the last record, select the worksheet row immediately below that record, unless you are adding a row inside an Excel table.
Can I insert a row without a mouse?
Yes. On Windows, select a cell in the target row, press Shift+Space to select the entire row, then press Ctrl+Shift+=. If an Insert dialog appears, choose Entire row. If your laptop keyboard or Excel setup does not recognize that combination, use the ribbon with keyboard navigation or a mouse/trackpad context menu.
How do I insert two or more blank rows?
Select two or more adjacent row headings, matching the number of blank rows you want, then right-click and choose Insert. Excel inserts that many rows above the first selected heading. For example, selecting rows 20 and 21 inserts two rows above row 20.
Will inserting a row change my formulas?
Excel usually adjusts cell references when rows are inserted, but the outcome depends on the formula and workbook layout. Check totals, charts, and references to manually defined ranges after insertion. If a formula is important, confirm that its referenced cells still cover the intended records.
What is the difference between a worksheet row and a table row?
A worksheet row spans the sheet and can affect content in every column. A table row is part of a specific Excel table and is intended for that table’s records. Use Table Rows Above when adding a record within a table; use Insert Sheet Rows when you need a new full row across the worksheet.
Do these steps work in Excel for the web and on Mac?
The row-heading context menu and ribbon insertion options are available in recent Excel versions on Mac and in Excel for the web, though labels or placement may vary slightly. Mac keyboard shortcuts differ from Windows and depend on the keyboard, so use the menus if a shortcut fails. In a web browser, the browser may capture some key combinations before Excel can use them.
Related
- PV in Excel: How to Calculate Present Value and Payments
- Excel Payment Calendar: Build One That Updates
- Excel Payment Log: How to Track Payments and Balances
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 Add a Checkbox in an Excel ColumnTo add checkboxes to an Excel column in Microsoft 365 for Windows, select the blank cells where you…
- Conditional Formatting Strikethrough in ExcelYes. In Excel for Microsoft 365 on Windows, you can use conditional formatting to strike through an entire…
- Google Sheets Column Running Total: Formulas That WorkTo calculate a running total in a Google Sheets column, enter =SUM($A$2:A2) in B2 when your numbers are…
- Import a CSV File into Excel: Steps, Settings, and FixesTo import a CSV file into Excel for Microsoft 365 on Windows, open a workbook, select Data >…
- How to Merge Cells in Jupyter Notebook: A Practical GuideTo merge cells in Jupyter Notebook, select the adjacent cells you want to combine, then choose the merge…
- Freeze Panes in Excel: How to Keep Rows and Columns VisibleIn Excel for Microsoft 365 on Windows, use View > Freeze Panes to keep rows or columns visible…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.