How to Add Rows in Excel Using Keyboard Shortcuts

Adding rows in Excel is one of those tasks you do constantly — and if you're still right-clicking every time, you're leaving a lot of speed on the table. Excel's keyboard shortcuts for inserting rows are fast, reliable, and work across most versions of the software. But the exact shortcut that works best depends on your operating system, your keyboard layout, and how you prefer to work.

Here's a clear breakdown of how it all works.

The Core Shortcut for Inserting a Row in Excel

On Windows, the most widely used shortcut to insert a row is:

1. Select the row where you want the new row to appear above (click the row number on the left)
2. Press Ctrl + Shift + "+" (the plus key)

Excel inserts a blank row above the selected row and shifts everything down.

If you're on a Mac, the equivalent shortcut is:

• Command + Shift + "+"

On some Mac keyboards, you may need to press Control + I instead, depending on your Excel version and system configuration.

These shortcuts work because Excel interprets "insert" as adding cells, rows, or columns depending on what you've selected first. Selection is the critical first step — get that wrong and you'll insert cells instead of entire rows.

Selecting Rows: The Step That Changes Everything

Before hitting any shortcut, you need to select correctly.

• Click a row number (the numbered label on the far left) to select the entire row
• Click and drag across multiple row numbers to select multiple rows at once
• Press Shift + Spacebar to select the entire row of whatever cell is currently active — useful when you're already deep in a spreadsheet and don't want to reach for the mouse

If you select only a cell (not a full row) and then press Ctrl + Shift + "+", Excel will open a dialog box asking whether you want to shift cells down, shift cells right, insert a row, or insert a column. It's an extra step you can avoid by selecting the full row upfront.

Inserting Multiple Rows at Once ⚡

One of the more useful — and underused — tricks: you can insert multiple rows in a single action.

Select the same number of rows as you want to insert, then apply the shortcut. For example:

• Highlight rows 5, 6, and 7 by clicking row 5's number and dragging to row 7
• Press Ctrl + Shift + "+"
• Excel inserts three blank rows above row 5

This scales as far as you need. Selecting 10 rows inserts 10 rows. It saves significant time compared to repeating the shortcut one row at a time.

The F4 Repeat Trick

Excel has a built-in "repeat last action" shortcut: F4. After inserting one row with Ctrl + Shift + "+", you can press F4 repeatedly to keep inserting rows one at a time without re-invoking the full shortcut.

This is particularly handy when you need to scatter new rows throughout a large spreadsheet — insert one, navigate to the next spot, press F4, move on.

Using the Ribbon Shortcut Sequence (No Mouse Required)

If you prefer to keep your hands entirely on the keyboard, Excel's ribbon has a navigable sequence for inserting rows:

• Press Alt to activate the ribbon
• Press H to open the Home tab
• Press I to open the Insert menu
• Press R to select "Insert Sheet Rows"

It's a four-key sequence — Alt → H → I → R — and it works reliably in Excel for Windows without needing to know where anything is on screen. This approach is especially useful for users who rely on screen readers or accessibility tools.

Shortcut Comparison by Method 📋

Where Things Get Inconsistent

Not every setup behaves the same way:

• Laptop keyboards sometimes require pressing Fn alongside shortcuts involving "+" or function keys, depending on how function lock is configured
• Non-US keyboard layouts may place the "+" key in different positions, which can affect whether Ctrl + Shift + "+" registers correctly
• Older versions of Excel (pre-2013) handle some shortcut behaviors slightly differently, particularly around the insert dialog box
• Excel Online (the browser-based version) has more limited shortcut support — some desktop shortcuts don't work at all, and others behave differently than in the desktop app
• Excel on iPad or Android tablets relies on touch-first interfaces; keyboard shortcuts require a connected physical keyboard and may not fully replicate the desktop experience

How Your Workflow Shapes Which Method Fits

Power users working with large datasets tend to rely on Shift + Spacebar to select rows without breaking keyboard flow, then Ctrl + Shift + "+" to insert. Those who build reports row-by-row often prefer the F4 repeat approach. Occasional Excel users who aren't invested in memorizing shortcuts often find the right-click menu just as efficient for their pace.

The "best" shortcut isn't a universal answer — it's the one that fits how often you're inserting rows, whether you're on Windows or Mac, whether you're using the desktop app or the browser version, and how your physical keyboard is configured. 🖥️

Understanding those variables is what turns a generic shortcut tip into something you'll actually use consistently.