In Excel: select as many existing rows as you want to add, right-click the selection and choose Insert — Excel inserts that many blank rows above; the keyboard shortcut is Ctrl+Shift+Plus.
On this page7
Decide how many rows you need and select that many existing rows by their row numbers (three rows to insert three).
Right-click anywhere in the highlighted rows and choose Insert.
Excel inserts the blank rows above the selection and shifts the rest down; formulas and totals adjust automatically.
For speed, select the row(s) and press Ctrl+Shift+Plus instead of right-clicking.
What this does
Inserting rows pushes a blank row (or several) into the sheet at the point you choose, shifting everything below it down — totals and formulas re-point automatically. The count is the key trick: Excel inserts exactly as many rows as you select first, so to add three rows you select three existing rows before inserting. New rows always appear above the selection. Right-click ▸ Insert and the Ctrl+Shift+Plus shortcut both do it; selecting whole row numbers (not just cells) keeps the insert clean across the full width of the sheet. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “add another row in excel”. Start on a copy or a tiny sample, keep the affected rows visible, and compare the result with the outcome you expected before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
You need three blank rows above row 10. Click row number 10 and drag down to row 12 to select three whole rows, right-click anywhere in the selection and choose Insert: three empty rows appear above the old row 10, and everything from there down shifts to rows 13 onward. To add just one row above row 5, click row header 5 and press Ctrl+Shift+Plus — a single blank row opens up and the former row 5 becomes row 6. Inserting rows is how you open space for new records, a heading or a spacer in the middle of existing data without retyping or overwriting it. Because everything below shifts down and formulas re-point, the sheet stays correct while it grows. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “add another row in excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.
Common mistakes
- Selecting one row and expecting several — Excel inserts exactly as many rows as you select, so select three to get three.
- Selecting cells instead of whole row numbers, which triggers the Insert dialog asking how to shift cells.
- Forgetting that new rows go above the selection, then inserting one row too low.
- Assuming a referenced range auto-expands — a row inserted just outside
=SUM(A2:A9)may not be picked up; insert inside the range or check it.
Frequently asked questions
How do I insert multiple rows at once?
Select as many existing rows as you want to add — three rows to add three — then right-click and Insert. Excel always inserts a count equal to your selection, all in one step.
What is the shortcut to insert a row?
Select the row and press Ctrl+Shift+Plus (the + on the main keyboard). If you selected cells rather than a whole row, the same shortcut opens the Insert dialog so you can choose Entire row.
Where does the new row appear?
Always directly above the row you selected. To add a row below a given row, select the row beneath it first, or select the row itself and the new blank lands above it.