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 rows / columns to insert".
5. Click OK (or press Enter). Blank rows are inserted and existing data shifts down.

Video tutorial

Narrated in Vietnamese, with Vietnamese subtitles. Chèn dòng, Chèn cột, Chèn và Sao chép · 6 min 12 s · 10 cases · Download the video · Practice workbook for the video

Commands in this video: Insert Rows · Insert and Copy · Insert Columns

Chapters (15)

1. Giới thiệu
2. Mở lệnh
3. Cửa sổ Chèn dòng / cột
4. 1 · Chèn nhiều dòng
5. 2 · Chèn nhiều cột
6. 3 · Chọn nhiều dòng, nhiều vùng
7. 4 · Dòng tổng cộng
8. 5 · Bảng có ô gộp
9. 6 · Chèn và Sao chép
10. 7 · Chọn lệch cột – hoàn tác
11. 8 · Mẫu ở sheet riêng
12. 9 · Danh sách đang lọc
13. 10 · Khi lệnh không chạy
14. Mẹo
15. Kết thúc

Illustrated walkthrough

Practice

Download this command's sample workbook — the data matches the pictures below (sheet Quantities), so you can follow each step right away.

Step 1. Click a cell in the row where the new rows should go — they are inserted above that row. For example, to add 3 items before row 6, select any cell in row 6, such as B6 (1).

Step 2. On the ribbon, open the DVD Addin tab → Cells and Rows group → click Insert Rows.

Step 3. The Insert rows / columns window opens on the Insert rows tab. Type how many rows to insert (1–1000) (1), then click OK (2) or press Enter.

Step 4. Three blank rows appear at rows 6–8 (1) and the existing data moves down. Fill in the new items there.

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.
• The add-in inserts the rows itself, so Ctrl+Z does not undo it (Excel clears its undo history when an add-in writes to the sheet) — if you inserted too many, select the extra rows and delete them by hand. 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.