Inserting a row in Excel is one of the most basic operations and one of the most-asked questions by new users. The simplest method is to right-click the row number on the left side of the worksheet and choose Insert from the context menu — Excel pushes existing rows down by one and gives you a new empty row above the one you clicked. Several keyboard shortcuts produce the same result faster, and the ribbon path through Home > Insert > Insert Sheet Rows works in every Excel version on every platform.

Despite the simplicity of the operation, four common scenarios trip up users. Inserting a single row above a selected row is straightforward; inserting multiple rows at once requires selecting multiple rows first. Inserting rows that automatically inherit formulas from above takes a slightly different approach. Inserting rows that fail with an unhelpful error message usually points to a filter, a merged cell or a protected sheet — each fixable but not obvious to a new user. This guide covers all four scenarios.

The keyboard shortcut on Windows is Ctrl + Shift + = (which produces the + character on US keyboards). Some sources list Ctrl + + as the shortcut, which is the same thing on most keyboards. On Mac the shortcut is Command + Shift + = or Command + +. The shortcut works whether you have a row selected (inserts a row above the selection) or an individual cell selected (Excel asks whether to shift cells down, shift cells right, insert entire row or insert entire column).

This guide covers every method for inserting rows — right-click menu, ribbon path, keyboard shortcuts on Windows and Mac — plus the variations needed for inserting multiple rows at once, copying formulas down to the new row, working with Excel Tables that auto-extend, common error messages and their fixes, and the slight differences when working in Excel for the web. The goal is to make row insertion as natural as breathing so it never gets in the way of your actual work.

The right-click method is the most discoverable for new users. Move the mouse to the leftmost edge of the worksheet where the row numbers (1, 2, 3...) appear. Right-click the row number where you want the new row to appear above. The context menu shows Insert, Delete, Cut, Copy and other row operations. Click Insert. Excel pushes the existing row down and gives you an empty row above it. The newly inserted row inherits no formatting; it starts with default cell formatting and no contents.

The ribbon path is more visible but slower. Click any cell in the row above which you want to insert. Click the Home tab on the ribbon. In the Cells group on the right side of the ribbon, click the small arrow next to Insert and choose Insert Sheet Rows. Or, click Insert without the arrow, which inserts based on what is selected — selecting a row inserts a row above; selecting a cell inserts and shifts cells down by default.

Keyboard shortcuts are the fastest method once memorized. Click the row number to select the entire row, then press Ctrl + Shift + = (Windows) or Cmd + Shift + = (Mac). The new row appears above the selection. If you have only a cell selected (not the entire row), the Ctrl+Shift+= shortcut opens the Insert dialog asking whether you want to shift cells down, shift cells right, insert an entire row or insert an entire column — choose the appropriate option and click OK.

For inserting multiple rows at once, the trick is to select multiple rows first. Click the row number of the first row, then Shift+click the row number of the last row to select a contiguous block. Or click the first row number and drag down to extend the selection. Once you have N rows selected, any of the three insert methods (right-click, ribbon, keyboard) inserts N new rows above the selection. Five rows selected produces five new rows above; one selected produces one.

Inserting a row that copies the formulas from the row above is a separate question. By default, the newly inserted row is empty — no formulas, no formatting. To get formulas to copy down, the simplest approach is to insert the row first using any of the three methods, then select the row above the new one, copy it (Ctrl+C), select the new empty row, and paste (Ctrl+V). Or use Paste Special > Formulas to bring only the formulas without the values or formatting.

For workbooks where you regularly need to insert rows that inherit formulas, converting the data range to an Excel Table (Ctrl+T) is the right answer. Tables automatically copy formulas down to new rows as you type new data into the row below the Table. There is no need to manually copy formulas; the Table handles it. New rows added at the bottom of a Table also automatically inherit number formatting, conditional formatting and data validation rules — features that make Tables much more pleasant for ongoing data entry than plain ranges.

For inserting rows above a Table (between the Table and the rows above it), right-click any cell in the Table's first row and choose Insert > Table Rows Above. This adds a new row to the Table at the top and pushes existing Table data down. Inserting rows in the middle of a Table works the same way — right-click any row inside the Table and choose Insert > Table Rows Above. The Table maintains its formulas, formatting and structure across the insert.

For wholesale data entry where new rows need to inherit a complex set of formulas and formatting, consider creating a template row at the bottom of your data with all formulas and formatting set up correctly, then duplicate that row each time you add a new entry. Right-click the template row and choose Copy, then right-click the destination row and choose Insert Copied Cells. This is faster than the type-then-copy-formulas approach for repeated data entry.

For the keyboard shortcut on Mac specifically, Cmd + Shift + = is the standard. Cmd + + works on most Mac keyboards as a synonym. Some Mac users with non-US keyboards or with custom shortcuts may find that the shortcut behaves differently — in those cases, check System Preferences > Keyboard > Shortcuts to verify nothing else has claimed the keystroke. The right-click and ribbon methods always work as a fallback.

For Excel for the web, the right-click method works the same as on the desktop. The keyboard shortcut Ctrl + Shift + = also works on the web in most browsers. Some browser-level shortcuts (zoom in, for example, on certain browsers) can intercept the keystroke; if the shortcut does not work in your browser, fall back to the right-click method. The ribbon Home > Insert > Insert Sheet Rows is also available on the web with the same behavior as on desktop.

For Excel on iOS and Android, tap the row number to select the row, then look for the Insert option in the action menu that appears. The mobile interface is touch-optimized so the workflow is slightly different — there is no right-click — but the underlying behavior matches the desktop. Mobile Excel is good enough for occasional row inserts but slower for sustained editing; the desktop and web versions are better for any work involving more than a few rows.

For users coming from Google Sheets, the row insertion process is similar but the keyboard shortcuts differ. In Google Sheets, Ctrl + Alt + = (Windows) or Cmd + Option + = (Mac) inserts a row above. The right-click menu option is also Insert. Google Sheets and Excel are interoperable — files convert between them — but the shortcuts are independent. If you switch frequently between the two applications, accept that you will need to remember both shortcut sets.

The merged-cell issue is particularly common in formal reports with title rows that span multiple columns. A merged cell across columns A through E in row 1 prevents inserting a row above it cleanly because Excel cannot determine how to handle the merge during the shift. Unmerge the cell (select it, click Home > Merge & Center to toggle off), insert the row, then re-merge if needed. Or use Center Across Selection (Format Cells > Alignment > Horizontal > Center Across Selection) instead of Merge & Center, which avoids the merge-cell complications.

Filter complications arise when rows are hidden by an active filter. Excel sometimes refuses to insert into a filtered area, particularly when the insertion would split visible and hidden rows in unexpected ways. The cleanest fix is to clear the filter (Data > Clear), perform the insert, and re-apply the filter. For workflows where the filter must remain active, unhide all rows first, insert, then re-filter — but this is more error-prone.

Worksheet protection is the most explicit blocker. When a sheet is protected (Review > Protect Sheet), the protector decides what users can do. Inserting rows is unchecked in the default protection settings, meaning protected sheets refuse row inserts. Two paths: unprotect the sheet (Review > Unprotect Sheet, with the password if one is set), insert the row, then re-protect; or modify the protection options to allow row insertion as one of the permitted actions.

Workbook-level protection is a third blocker, less commonly encountered. Review > Protect Workbook restricts changes to the workbook structure, including adding or deleting sheets and sometimes rows in certain configurations. Unlock the workbook with the password if one was set, perform the changes and re-protect. Most users encounter sheet protection more often than workbook protection because the former is the typical control for restricting user edits in shared spreadsheets.

For power users, the keyboard shortcut sequence Alt + I + R works on Windows as a chord-style alternative to Ctrl + Shift + =. Press and release Alt to enter ribbon-shortcut mode (Excel shows letter overlays on each ribbon command), then I to open the Insert menu, then R to choose Insert Sheet Rows. The full Alt+I+R sequence is slightly slower than Ctrl+Shift+= but useful for users who already know Alt-key navigation from other Office work. Both shortcuts produce identical results.

For inserting rows in long lists where you need to add data at multiple positions, the row-then-copy approach saves time. Insert all the empty rows you need first (multiple selections, then Ctrl+Shift+=), then fill the data and formulas. Alternatively, type the data into the first empty position, copy it, then use Insert Copied Cells on subsequent positions to push existing rows down while adding the copied data. This avoids the cycle of insert-then-edit-then-insert-then-edit.

For VBA scripting, the row insertion equivalent is Rows("5:5").Insert (inserts a single row above row 5) or Rows("5:7").Insert (inserts three rows above row 5). The Insert method takes optional Shift and CopyOrigin parameters. Recording a macro while inserting rows manually shows the exact code needed for any specific scenario. Users who need to script row insertion across many sheets or workbooks usually pull out VBA after experiencing the limits of manual row insertion at scale.

For developers using the Office JS API in custom Excel add-ins, the equivalent operation is range.getEntireRow().insert("down") on a Range object. The Office JS API exposes the same row insertion capability as VBA but in a JavaScript-based interface that runs in modern Excel including the web version. Most users will never need this; for developers building Excel-integrated tools, the API is the way to perform row inserts programmatically.

The conceptual model for row insertion is simple but worth stating: Excel always inserts above the selected row, pushing existing rows down. There is no insert below option in the standard interface; if you want to insert below row 5, select row 6 and insert there — Excel adds a new row at position 6, and what was previously row 6 becomes row 7. Internalize this above-the-selection behavior and the right-click, ribbon and keyboard methods all behave predictably.

For users adapting to Excel from other spreadsheet tools, the row insertion behavior is essentially universal. Google Sheets, LibreOffice Calc, Numbers, OnlyOffice and other competitors all use the same insert-above conceptual model with similar keyboard shortcuts. The specific keystroke combinations vary slightly — Google Sheets uses Ctrl + Alt + = where Excel uses Ctrl + Shift + = — but the conceptual operation is identical. Knowing one tool's row insertion makes learning the others' trivial.

For collaborative workbooks shared through OneDrive, SharePoint or Microsoft Teams, row inserts work normally and propagate to other users in real time. Multiple users editing the same workbook simultaneously will see each other's row inserts as they happen. The co-authoring system handles concurrent edits gracefully in nearly all cases; the rare conflicts (two users inserting in the same area at the same instant) are resolved with simple last-write-wins logic with explicit notification.

For workbooks shared as email attachments or downloaded copies, each user gets a separate file. Each user can insert rows independently in their copy without affecting other recipients. The drawback is the well-known versioning chaos when multiple recipients edit independently; the cloud-shared OneDrive approach avoids this by maintaining a single canonical version. For teams working together regularly, OneDrive sharing produces dramatically better collaboration than email attachments.