In Excel for Microsoft 365 on Windows, select the row header where you want a row inserted and press Ctrl+Shift+= (the plus sign). To add a blank row between every record in a list, Excel has no single shortcut that repeats this pattern automatically; use a helper column and sort the records with blank rows, or insert rows individually with the shortcut.
The shortcut for inserting one row
Click the numbered row header at the left edge of the worksheet to select the entire row. Press Ctrl+Shift+=, which is Ctrl plus the Shift key and the equals key (Shift makes that key type a plus sign on a typical keyboard). Excel inserts a new, empty worksheet row above the selected row. If you select several adjacent row headers first, the same shortcut inserts the same number of rows above the selection.
For example, select row 4 and use the shortcut to place a blank row above row 4. To put a blank row after the last record, select the row immediately below that record instead. You can also right-click a selected row header and choose Insert, or use Home > Insert > Insert Sheet Rows. Selecting a row header matters: if you select an ordinary cell, Excel may open the Insert dialog, where you must choose whether to shift cells down or insert an entire row.
A dependable way to add a row between every record
For a list with many records, a helper-column sort is more dependable than trying to select every other row and insert rows in one operation. It gives each original record and each empty row a sort key, then sorts the range so the empty rows fall between records. This creates actual blank worksheet rows, not just blank-looking cells.
- Keep the header outside the sort range. If your records are in A2:D6, for example, the header is in row 1 and there are five records.
- Make room for four empty rows immediately after the list. If those worksheet rows already contain other information, insert four full sheet rows below the list first, or work on a copy or a separate sheet. Do not overwrite unrelated cells.
- Choose an unused helper column, such as E. Give the original records ascending odd-numbered keys: 1, 3, 5, 7, and 9 in E2:E6. Give the four empty rows the even-numbered keys 2, 4, 6, and 8 in E7:E10. The helper values belong beside the records and in the otherwise empty rows.
- Select the full rectangular range A2:E10, including all data columns, the helper column, and the empty rows. Choose Data > Sort, sort by column E, and use smallest to largest order. If Excel asks whether to expand the selection, expand it so each row stays together.
- Check the result: the first record should be followed by an empty row, then the second record, and so on. Clear the helper values or remove the helper column after confirming the sort.
With this example, sorting places the record keyed 1 first, the blank row keyed 2 next, and the record keyed 3 after it. The pattern continues through the record keyed 9, leaving a blank row between each pair of records. If you also want an empty row after the final record, add one more blank row and give it key 10. The header remains in row 1 because it was not included in the sorted range.
Why the helper column method works
Sorting moves complete rows according to their helper values. Odd keys preserve the order of the original records, while even keys put the blank rows between them. The helper column is temporary bookkeeping: it tells Excel where each row belongs, then can be removed when the ordering is correct.
This is often safer than selecting nonadjacent row headers with Ctrl and trying to insert all those rows at once. Commands that work on a single continuous selection may not work on multiple separate selections, and behavior can depend on exactly what is selected. The helper-column approach avoids relying on a noncontiguous selection and makes the intended order visible before you sort.
Before sorting, make sure the range includes every column belonging to a record. If a name is in A, a date in B, and a status in C, sorting only A and the helper column could separate names from their dates and statuses. Include the full record width, and avoid including unrelated notes or another table below the data.
When to use the shortcut repeatedly
If the list contains only a few records, inserting rows one by one may be quicker than preparing a helper column. Select the row header above the desired insertion point and press Ctrl+Shift+=. Repeat at the next intended location, adjusting for the newly inserted rows. For a sequence of adjacent blank rows, select that many row headers together before using the shortcut.
For example, to make space between three records in a short list, select the row where the first gap should go and insert one row. Then find the row header where the next gap belongs in the updated sheet and repeat. This is simple for occasional edits, but it is easy to lose track of row numbers in a long list. Use the helper sort for a larger list, or when you need a repeatable procedure.
Important checks before sorting
- Keep a header out of the sort. Select only the records, helper keys, and blank rows. If the header is included accidentally, it may be sorted into the body of the list.
- Include all related columns. Sort complete records as one range so each field remains attached to the right record.
- Protect content below the list. The blank rows used in the example must be genuinely available. Insert new sheet rows or use a safe copy if another range begins immediately underneath.
- Review formulas and references. Sorting moves rows, which can affect how a workbook is organized and how references appear. Save a copy first if the sheet has complex formulas, linked reports, or carefully arranged sections.
- Check tables and filters. If the data is an Excel table, blank rows inside it may be treated as part of the table rather than as separators between independent records. Consider whether you want to keep it as a filterable table before adding gaps.
Windows, Mac, and Excel for the web
This article uses Excel for Microsoft 365 on Windows. On Windows, the row-insertion shortcut is Ctrl+Shift+=. On a Mac, select the row header and use Control+Shift+= to insert a row; keyboard layouts can differ, so the menu route is a useful fallback. The ribbon command is Home > Insert > Insert Sheet Rows. In Excel for the web, select the row header and use the available Insert command from the Home tab or the row-header context menu; keyboard shortcuts can vary with the browser and system.
The helper-column sort follows the same general idea across desktop versions: include the complete range, sort by the helper values, and keep the heading row out of the selection. If the Sort dialog offers a setting indicating that the data has headers, check that it reflects your selection. A mistaken header setting or an incomplete selection can put rows in the wrong order.
Common mistakes and how to fix them
A frequent problem is pressing Ctrl+Shift+= while a cell is selected and getting an Insert dialog instead of a full row. Cancel the dialog, click the numbered row header, and try again. Another source of confusion is the plus key: on many keyboards, plus is typed with Shift and the equals key, so the shortcut is described as Ctrl+Shift+= rather than a separate plus key.
If sorting does not interleave the blank rows, check that every helper value is unique and that the selected range includes both the records and the blank rows. Also confirm that the helper column is the sort column and that the order is smallest to largest. If some records have no key, Excel may group them unexpectedly. If the rows move but fields no longer match, undo immediately with Ctrl+Z and repeat with the complete range selected.
A blank line is not the same as a blank cell. Applying extra row height, changing borders, or leaving an empty cell between values does not insert a worksheet row; other columns may still contain data on that line. Use the row-insertion shortcut or the sorting procedure when you need a true gap across the entire sheet.
Frequently Asked Questions
Is there a shortcut to insert a row every other row in Excel?
There is a shortcut to insert a row at a selected location: select its row header and press Ctrl+Shift+= on Windows. There is no built-in one-key shortcut that automatically inserts a row between every record in a selected list. Use the helper-column sort for a batch, or repeat the insertion shortcut manually.
Does Ctrl+Shift+= insert a row above or below?
It inserts above the selected row when you have selected a full row using its row header. Select the row below a record if you want the new blank row to appear after that record.
Can I insert several rows at once?
Yes. Select the same number of adjacent row headers as the number of rows you need, then use Ctrl+Shift+=. Excel inserts that number of rows above the selected rows.
Will the helper-column method preserve my data order?
Yes, if the original records receive ascending odd-numbered keys and the blank rows receive the even-numbered keys between them. Include every column in each record when sorting, and exclude the header so it stays at the top.
How do I insert a blank row after every record, including the last one?
Use the helper-column sort and create one blank row per record. Give the original records odd keys and the blank rows the following even keys, including the final even key after the last record. Sorting then leaves a blank after the final record as well as between records.
Related
- Excel Rank Ties Without Skipping Numbers
- Excel Randomize List of Names: 10 Reliable Methods
- Excel Quote Template With Drop-Down Lists That Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Export Google Contacts to Outlook Without Losing DetailsTo export Google Contacts to Outlook, open Google Contacts, choose Export, and select the Outlook CSV format; then…
- Google Sheets Text Dropdown: How to Add OneTo add a text dropdown in Google Sheets, select the cell or range, choose Insert > Dropdown, enter…
- Excel Go To Referenced Cell: Shortcuts and NavigationIn Excel for Microsoft 365 on Windows, press Ctrl+[ to select the cell or cells directly referenced by…
- Can You Make One Page Landscape in Word?Yes. In Microsoft Word for Microsoft 365 on Windows, insert a Next Page section break before and after…
- Google Sheets: How to Generate Unique IDsYes. Google Sheets can generate unique IDs with a row-based formula for simple lists, or with Google Apps…
- Excel Mac Data Analysis: Tools, Steps, and LimitsYes—Excel for Mac can analyze data with formulas, PivotTables, charts, and, in supported desktop versions, the Analysis ToolPak…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.