Insert Rows

Location on ribbon: Tab DVD Addin → Group Cells and Rows

Command ID: btnInsertMultipleRows

What it does

Inserts many blank rows above the active cell in one go, instead of right-click → Insert over and over. Handy when you need to open up space in the middle of a quantity take-off or schedule table to add a batch of new work items.

How to use

1. Click the cell where you want to insert (new rows go in above this cell).
2. Click Insert Rows on the ribbon.
3. The DVD Addin — Insert rows / columns window opens with two tabs: Insert rows and Insert columns — the rows tab is pre-selected.
4. Type the number of rows (digits only, 1–1000). The default value comes from Preferences ▸ "Default insert row/column count".
5. Click OK (or press Enter). Blank rows are inserted and existing data shifts down.

Example

A bill of quantities has 50 items and you need 20 finishing-work items inserted after row 30: click cell A31, run Insert Rows, type 20, press OK — 20 blank rows appear from row 31 and the data below moves down, with Excel adjusting formulas as usual.

Notes

• Rows are always inserted above the active cell (shifting data down) — to append inside a table, click the row just below the insert point.
• The count is limited to 1–1000; anything outside shows a red validation message in the dialog.
• You can switch to the Insert columns tab in the same window — OK acts on whichever tab is active.
• Undo (Ctrl+Z) works as with Excel's normal row insert, but double-check absolute ($) range references afterwards.

Related

• Insert Columns — same window, column direction.
• Insert and Copy — insert rows and replicate a template row into them.
• Delete blanks — the opposite clean-up: remove leftover empty rows.