Checked

Location on ribbon: Tab DVD Addin → Group Text and Number → arrow on Numbering → section Bullets

Command ID: btnVCheckbox

What it does

Prepends a ticked checkbox ☑ plus a space to every line inside the selected cells. Because the command strips any existing symbol before inserting, its main use is changing state: select the rows that currently show ☐, click once, and they become ☑ with no stacked symbols.

That is the fastest way to keep a construction checklist current — the register of acceptance documents already submitted, the items inspected and passed, the tasks completed in the site diary.

How to use

1. Select the cells (or rows) for the items that are now complete.
2. Go to the DVD Addin tab → Text and Number group → arrow on Numbering → Bullets section → choose Checked.
3. The add-in strips the previous symbol, then handles each cell:
   • Text cell — each line is trimmed, then ☑ is added at the start.
   • Empty cell — just ☑ is written.
   • Formula cell — wrapped as =""&"☑ "&(original formula), so the tick shows while the formula stays live.
4. The status bar reports Processed N cells (checkbox ☑).

You can Ctrl-select scattered cells and tick them all in a single click.

Video tutorial

Narrated in Vietnamese, with Vietnamese subtitles. Dấu đầu dòng · 5 min 03 s · 9 cases · Download the video · Practice workbook for the video

Commands in this video: Filled circle · Asterisk · Filled diamond · Filled star · Checkbox · Minus · Remove bullets · Plus · Checked · Rejected

Chapters (14)

1. Giới thiệu
2. Mở lệnh
3. Chín ký hiệu
4. 1 · Ô nhiều dòng
5. 2 · Đổi ký hiệu, chọn rời
6. 3 · Danh mục kiểm tra đang lọc
7. 4 · Ô trống – mẫu in sẵn
8. 5 · Ô số, ngày tháng
9. 6 · Ô công thức
10. 7 · Ô gộp
11. 8 · Bỏ ký hiệu đầu dòng
12. 9 · Ghi đè và hoàn tác
13. Mẹo
14. Kết thúc

Illustrated walkthrough

Practice

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

Step 1. Select the lines that are done — here the three documents already submitted (1).

Step 2. On the ribbon, open the DVD Addin tab → Text and Number group → open Numbering → choose Checked.

Step 3. The Confirm data change box tells you how many cells will be overwritten. Keep Back up sheet ticked (1) so that Ctrl+Z right after the command restores the sheet, then click Continue (2).

Step 4. ☐ is replaced by ☑ (1) — the old symbol is removed first, so they never stack; unselected lines stay ☐. The status bar reports how many cells were processed (2).

Example

The document register for foundation completion, updated after the first submission:

Before	After (three submitted rows selected)
☐ Foundation rebar acceptance record	☑ Foundation rebar acceptance record
☐ 28-day cube compression test results	☑ 28-day cube compression test results
☐ Site diary for the foundation works	☑ Site diary for the foundation works
☐ As-built drawings for the foundations	☐ As-built drawings for the foundations

Notes

• Select only the completed rows — the command applies ☑ to every cell in the selection, unfinished ones included.
• The tick is a character in the cell text, not a clickable control, and it is not linked to any TRUE/FALSE cell.
• Each line is trimmed of surrounding whitespace before the symbol is added.
• Cells holding numbers, dates, or TRUE/FALSE are skipped entirely; Ctrl+Z right after the command puts the cells back.
• Hidden rows and columns are skipped, and each merged area is processed once, at its top-left cell.

Related

• Checkbox — create the empty boxes a checklist starts from.
• Rejected — the third state, for items that failed or were rejected.
• Remove bullets — strip every symbol and return the checklist to plain text.
• Filled star — flag items needing attention rather than items already done.