How to Insert Multiple Blank Rows in the Middle of an Excel Worksheet
Question details
The user needs to insert a massive block of blank rows (e.g., 820 rows) in the middle of an existing worksheet efficiently without adding them one by one.

- Product
- Spreadsheets
- Device & OS
- not provided
- Scenario
- Formatting or expanding a data table where a large chunk of new data needs to be pasted into the middle of existing records.
- Observed behavior
- The user wants to avoid adding rows individually to save time and avoid overwriting existing data below the insertion point.
Determine the exact starting row number and the total number of blank rows you need to insert before proceeding.
Use the Go To Feature (F5) to Insert Rows
This is the fastest and most accurate method to insert hundreds or thousands of rows by selecting a specific row range mathematically.
Instead of scrolling endlessly to highlight hundreds of rows, you can use the built-in Go To dialog box to instantly select the exact number of rows you need to insert.
Determine your ending row by taking your starting row number, adding the number of rows you want to insert, and subtracting 1. For example, if you need 820 rows starting at row 612, the calculation is 612 + 820 - 1 = 1431.
Press the F5 key on your keyboard to immediately bring up the 'Go To' window.
In the Reference box, type your row range using a colon, such as 612:1431, and press Enter. This will perfectly select exactly 820 rows.
Right-click anywhere on the highlighted row numbers on the far-left side of the screen and choose 'Insert' from the context menu. The new blank rows will be added instantly.

Easily Insert Bulk Rows in WPS Spreadsheet
WPS Spreadsheet offers a highly intuitive and familiar interface for managing large datasets. You can effortlessly insert hundreds of rows using the exact same shortcut methods, entirely for free.
- 1. Open your document: Launch WPS Spreadsheet and open your workbook.
- 2. Open the Go To window: Press the F5 key to open the Go To dialog.
- 3. Select the rows: Type your exact row range (e.g., 612:1431) into the reference box and press OK to highlight the rows.
- 4. Insert: Right-click the highlighted row headers on the left and select 'Insert'.

Frequently Asked Questions
Can I use the drag-and-drop method to insert multiple rows?
Yes. You can select a few rows, hold down the Shift key, and drag the fill handle downwards to insert additional rows. However, for a massive number like 820 rows, the F5 (Go To) method is significantly faster and more accurate.
What happens to my formulas when I insert rows in the middle?
Spreadsheet software automatically updates relative cell references in your existing formulas to accommodate the newly inserted rows, ensuring your calculations remain accurate.
Is there a keyboard shortcut to insert rows after selecting them?
Yes. After highlighting the rows using the F5 method, you can press Ctrl + + (the Plus key) on the numeric keypad, or Ctrl + Shift + + on the main keyboard, to instantly insert the rows without right-clicking.
How do I quickly delete hundreds of blank rows?
The process is nearly identical to inserting. Press F5, type the row range of the blank rows you wish to remove, press Enter to select them, right-click the highlighted row numbers, and choose 'Delete'.




