Pictures

Location on ribbon: Tab DVD Addin → Group Graphics

Command ID: btnInsertPictures

What it does

This command bulk-inserts images into the worksheet, one picture per cell, fitted to the cell (merged cells included) with a padding you choose. You pick many image files at once instead of running Insert → Picture and dragging each one into place.

It is the backbone command for site photo records: daily diaries, work inspection sheets, weekly progress reports — any table where each row is a work item with an evidence photo.

How to use

1. Prepare the table with cells (or merged cells) large enough to hold the pictures.
2. Go to tab DVD Addin → group Graphics → Pictures.
3. The Select image files dialog opens — select several files with Ctrl or Shift (PNG, JPG, JPEG, BMP, GIF, WEBP are supported) and press Open.
4. A range picker appears — "Select target range". Drag over the destination cells and press OK.
5. An input box asks for the padding between image and cell border (2-5 recommended), pre-filled with 2. Enter a value and press OK.
6. Pictures are placed in the selection's reading order (left → right, top → bottom), each merged area counting as one slot — so a two-photos-per-row appendix grid works. With a single cell selected, pictures go downwards, each step jumping a whole merged area. The status bar reports how many of the selected images were inserted.

Video tutorial

Narrated in Vietnamese, with Vietnamese subtitles. Chèn ảnh, Chèn theo tên, Chỉnh ảnh · 4 min 28 s · 12 cases · Download the video · Practice workbook for the video

Commands in this video: Pictures · Insert by Name · Move/Resize

Chapters (20)

1. Giới thiệu
2. Mở lệnh
3. Ba hộp hỏi
4. 1 · Nhật ký ảnh – ô gộp
5. 2 · Lưới ảnh có dòng chú thích
6. 3 · Chọn một ô hay cả cột
7. 4 · Bốn chế độ vừa ảnh
8. 5 · Bẫy: bảng lọc, dòng ẩn
9. Lệnh Chèn theo tên
10. Bốn hộp hỏi
11. 6 · Chèn theo tên – cấu kiện
12. 7 · Cách khớp tên tệp
13. 8 · Cập nhật – thay ảnh cũ
14. Lệnh Chỉnh ảnh
15. 9 · Chỉnh ảnh trôi khỏi ô
16. 10 · Ảnh dọc, vùng nhiều ô
17. 11 · Khi chọn sai
18. 12 · Hoàn tác
19. Mẹo
20. Kết thúc

Illustrated walkthrough

Practice

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

Step 1. On the ribbon, open the DVD Addin tab → Graphics group → click Pictures.

Step 2. The Select image files box opens: pick the site photos 01.jpg … 04.jpg together (hold Ctrl or Shift; PNG, JPG, JPEG, BMP, GIF and WEBP are accepted) and click Open. Pictures are ordered by natural file name (2 before 10), not by the order you clicked them.

Step 3. The Select target range box appears: drag over the picture cells C4:C15 (1) — each merged area counts as one slot — and click OK. In the next box, Enter padding between image and cell border, keep 2 (points) and click OK.

Step 4. The four pictures sit inside the four merged cells in file-name order (1). By default a picture keeps its ratio and is centred in the cell — change this under Fit mode for Insert Pictures in Preferences ▸ Graphics. The status bar reports how many pictures were inserted (2).

Example

A rebar inspection record for the level-3 slab has six merged photo cells in column D (D5:D28), each four rows tall.

You select six site photos named 01.jpg … 06.jpg, pick the range D5:D28, and enter a padding of 3. The result: six photos sitting neatly inside the six merged cells with a 3-point margin, none of them spilling outside the record's border.

Notes

• Pictures are sorted by file name, naturally (2 before 10), whatever order you clicked them in the file dialog.
• When the selection has fewer slots than pictures, the add-in asks first and inserts only as many as fit.
• Merged cells are detected automatically and the picture is fitted to the whole merged area, not just the top-left cell.
• How the picture fills the cell follows the Fit mode for Insert Pictures setting under Preferences ▸ Graphics. The default is Fit inside cell — keep ratio, centered — site photos are never squashed; choose "Fit to cell" to get the old stretch-to-fill behaviour.
• Ctrl+Z will not undo this — remove unwanted pictures by selecting and deleting them. Hold ESC to stop early; images already inserted are kept.
• Images are embedded into the workbook, so the Excel file grows quickly if the source photos are high-resolution.
• The range picker does not lock Excel: while it is open you can scroll, switch sheets or switch workbooks to pick the range there. Click OK or press Enter on the sheet when done; Cancel or Esc to stop.

Related

• Insert by Name — match images by the file name written in a cell instead of by selection order.
• Move/Resize — realign a single picture that ended up off-position.
• Pic Comment — attach photos to comments for hover preview instead of placing them in the cells.
• Resize Images — shrink embedded photos to keep the record file manageable.