In Excel for Microsoft 365 on Windows, select a row or rows and press Ctrl+Shift++ to insert the same number of blank rows above them. To repeat that insertion, press F4 or Ctrl+Y when the new row remains selected; if you mean copying an existing row’s contents, copy and paste it instead.
The Excel shortcut and what it does
The insert shortcut works on the current selection. If you select an entire worksheet row first, Excel inserts a blank row above it. If you select several adjacent row headers, Excel inserts that many blank rows above the first selected row. This is useful when you need to make room in a list without opening a menu each time.
On a typical Windows keyboard, the shortcut is written as Ctrl+Shift++. Since the plus sign is usually the shifted character on the equals key, press Ctrl+Shift+= on many US keyboards. In other words, hold Ctrl and Shift, then press the key that produces +. Some keyboard layouts or compact keyboards make the plus key combination less obvious.
To select a whole row using the keyboard, click a cell in it and press Shift+Space. Then use the insert shortcut. You can also click the row number at the left edge of the worksheet to select the entire row. Excel inserts the new row above the selected row, not below it.
Insert and repeat a row step by step
- Click a cell in the row where you want the new blank row to appear above.
- Press
Shift+Spaceto select that worksheet row, or click its row number. - Press
Ctrl+Shift++(often typed asCtrl+Shift+=on a US keyboard). - To insert another row in the same place, press
F4orCtrl+Yif Excel can repeat the previous insertion.
After an insertion, Excel generally keeps the new row selected, so repeating the command inserts another row in that location. The neighboring data moves down to make room. If the repeat key does not insert a row in your setup, simply use the insert shortcut again. The repeat feature depends on the previous action still being available as a repeatable command; it is not a special command that creates a permanently repeating pattern.
You can also use the ribbon: select a row, then choose Home > Insert > Insert Sheet Rows. This is a clear alternative when you do not remember the shortcut or when your keyboard layout makes the plus sign awkward.
Insert several blank rows at once
You do not have to insert rows one at a time. Select as many adjacent row headers as the number of blank rows you need, then run the insert command once. For example, to add four rows above row 12, select row headers 12 through 15 and press Ctrl+Shift++. Excel inserts four rows above the selected block, and the existing rows shift down.
This is often more predictable than repeating the shortcut rapidly. It also helps preserve a clear insertion point when a worksheet has formulas, formatting, or data validation nearby. The rows you select determine the quantity; they do not need to be empty. Excel inserts new rows and moves the selected rows and their contents down.
If row headers are difficult to select precisely, use the Name Box to select a range of rows. For instance, enter 12:15 in the Name Box and press Enter, then use the insertion shortcut. The Name Box is to the left of the formula bar. Check the selected range before inserting, because selecting a larger range than intended will add more rows than you need.
Insert a blank row or duplicate an existing row?
“Repeat a row” can mean two different things. Inserting a row creates a new blank worksheet row and shifts existing cells downward. It does not automatically copy the values, formulas, formatting, or validation from the row above. Duplicating a row means copying its contents into another row, which is a different operation.
To duplicate a row, select its row number, press Ctrl+C, select the destination row number, and press Ctrl+V. This copies the row’s cells, including their formulas and formatting. If you want to keep the existing destination data, do not paste over it; choose an appropriate empty destination instead. When copying formulas, Excel may adjust relative references based on where the copied cells are pasted.
If you want a new row with the same formatting but not the same values, insert a row and use the formatting options that appear, or copy the source row and clear the copied contents afterward. Be deliberate about formulas and data validation: a visually similar row may not behave the same way unless those elements are also present.
How repeat last action works
F4 repeats the last action when that action is repeatable. In Excel, Ctrl+Y can redo an action and can also repeat certain commands. These shortcuts are related in some situations, but they are not identical in every context: Ctrl+Y may redo an undone action, while F4 is commonly used to repeat a previous operation. If the last operation cannot be repeated, either key may do something else or have no effect.
For this reason, use the insert shortcut itself when you need a guaranteed insertion and repeat does not behave as expected. Also, do not confuse repeating an insertion with redoing it after an undo. Ctrl+Z undoes the latest action; Ctrl+Y may restore an action you just undid. Check the worksheet after using either key, especially if you have made other edits since inserting the row.
F4 also has another well-known Excel use: while editing a formula, it cycles through reference styles such as A1, $A$1, and A$1. If you are typing or editing a formula, F4 may change a cell reference instead of repeating a row insertion. Press Escape to leave formula editing if you intended to use it as a repeat key.
Windows, Mac, and Excel for the web
The instructions above are for Excel for Microsoft 365 on Windows. On a Mac, the exact key combination can depend on the keyboard and Excel settings. A common Mac combination for inserting rows is Control+Shift+=, but if it does not work on your layout, use the ribbon command Home > Insert > Insert Sheet Rows. Select the row or rows first so Excel knows how many rows to add.
For repeating an action on a Mac, Command+Y is commonly used for redo; function-key behavior can vary with the Mac keyboard settings. The ribbon command is the dependable alternative if the shortcut behaves differently. On a MacBook, you may also need to use the Fn key with a function key, depending on how the keyboard is configured.
In Excel for the web, use the row headers and the ribbon command if a keyboard shortcut is intercepted by your browser or does not match your layout. Select the row or rows, then choose Home > Insert > Insert Sheet Rows. The web version and desktop version can differ in shortcut behavior, but the selection rule remains the same: selecting multiple rows inserts the same number of new rows above them.
Common problems and how to fix them
- The shortcut opens an Insert dialog: You likely selected a cell rather than a full row. Choose Entire row in the dialog, or select the row header before using the shortcut.
- The plus key combination does not work: Try
Ctrl+Shift+=on a US keyboard, or use Home > Insert > Insert Sheet Rows. Keyboard layouts differ in where the plus sign is located. - The row appears in the wrong place: Excel inserts above the selected row. Select the row immediately below the intended location.
- F4 changes a formula reference: You are probably editing a formula. Finish or cancel formula editing before using F4 to repeat an action.
- Excel refuses to insert rows: The sheet may be protected, or inserting rows may be restricted. Check Review > Unprotect Sheet if you have permission to unprotect it. A worksheet can also run out of available rows at its bottom edge.
- Cells do not look like the rows around them: A newly inserted row may not carry over every desired format or validation rule. Inspect the row and use the available insert-formatting options or copy the needed formatting from a nearby row.
In a formatted Excel table, the table may expand when you type in the row directly below it, but that is not the same as inserting a worksheet row with the keyboard shortcut. If you need a row inside the table, select a table row and use the table’s insert-row option or the worksheet row command. This distinction matters because table formulas and formatting can auto-fill differently from ordinary worksheet cells.
Frequently Asked Questions
What is the shortcut to insert a row in Excel?
Select the row, then press Ctrl+Shift++ on Windows. On many US keyboards, this is entered as Ctrl+Shift+=. You can also select the row and choose Home > Insert > Insert Sheet Rows.
How do I insert multiple rows at once?
Select the same number of adjacent row headers as the number of rows you want to add, then use the insert shortcut once. Selecting three row headers inserts three blank rows above the selected block.
How do I repeat the row insertion shortcut?
After inserting a row, press F4 or Ctrl+Y if the insertion is still the last repeatable action. If that does not work, run the insert shortcut again.
Does inserting a row copy the row above?
No. Inserting a worksheet row makes space and shifts cells down. To copy an existing row’s data and formatting, select its row header, copy it, and paste it into the destination row.
How do I insert a row below the current row?
Select the row immediately below the position where the new row should go, then insert. Excel places new rows above the selection, so choosing the next row down creates the practical effect of adding one below the current row.
Related
- Unhide Rows in Excel: Shortcut Keys and Other Methods
- Unhide Columns in Excel Using the Keyboard
- Excel Unhide Shortcut: Reveal Hidden Rows and Columns
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: Calculate the Length of Time Between Two DatesTo find the elapsed number of days between two dates in Excel, subtract the earlier date from the…
- How to Set Up Out of Office Automatic Replies in OutlookTo set up an out-of-office reply in Outlook, open Automatic Replies, turn them on, choose when they should…
- Excel Inventory List: How to Build and Manage StockTo create an Excel inventory list, make columns for each item’s SKU, description, location, quantity, reorder point, and…
- Google Sheets Filter Shortcut: Turn Filters On and OffIn Google Sheets in a web browser, press Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on a Mac,…
- How to Make a Bifold Brochure in Word, Step by StepTo make a bifold brochure in Microsoft Word, create a two-page landscape document, divide each page into two…
- Google Sheets IF Statements: Syntax and Examples ExplainedIn Google Sheets, an IF statement uses the IF function to test a condition and return one result…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.