Bullets

The Bullets menu inserts a Unicode symbol plus one space at the start of every line inside the selected cells — six bullet styles for lists and three checkbox states for inspection sheets.

The symbol is a character inside the cell content, not an ActiveX or Form control: it prints exactly as it looks on screen, travels with the cell when you copy, sort or filter, and adds nothing to the file size. On site it is used most for method-statement text and pre-pour checklists.

Path: tab DVD Addin → group Text and Number → arrow on the Numbering button → List Format section → Bullets menu.

Commands in this group

Command	What it does
Filled circle	Inserts ● — the neutral default for method statements
Filled star	Inserts ★ — the strongest emphasis, good for ITP hold points
Minus	Inserts − (mathematical minus, U+2212) — second level under a ● heading
Filled diamond	Inserts ◆ — mid-level emphasis, good for programme milestones
Plus	Inserts + — plain ASCII, safe when exporting to CSV or other software
Asterisk	Inserts * — the familiar mark for footnotes and table remarks
Checkbox	Inserts ☐ — awaiting inspection
Checked	Inserts ☑ — passed / completed
Rejected	Inserts ☒ — failed / not applicable
(None)	Strips the bullet, returning plain text

Every insert command clears the previous symbol first, so switching between styles takes one click and never stacks two symbols.

Building a site inspection sheet

1. Type the check items down a column, or several lines inside one cell using Alt+Enter.
2. Select the range and click Bullets ▸ Checkbox — each line gets ☐ in front. The status bar reports the number of cells processed.
3. Print the sheet for site; the inspector ticks the boxes by hand.
4. Back in the office, select only the lines that passed and click Checked → they become ☑. Ctrl-click several separate cells and run it once for the whole group.
5. Select the failed or not-applicable lines and click Rejected → ☒. Those are the entries a corrective-action notice is based on.
6. Need plain prose to paste into a Word document: select the range again and click (None).

For a method statement, swap step 2 for Filled circle on ordinary items and Filled star on mandatory ones.

Example

Pre-pour checklist for the level 3 slab, after the results were ticked back in:

Check item	Result
Reinforcement diameter and spacing per drawing	☑ Reinforcement diameter and spacing per drawing
Spacers in place, correct cover thickness	☑ Spacers in place, correct cover thickness
Formwork tight and adequately propped	☒ Formwork tight and adequately propped
Formwork cleaned and dampened	☐ Formwork cleaned and dampened

A formula cell =B5&" m³" becomes =""&"● "&(B5&" m³") once a bullet is applied — still a live formula, so the result follows the quantity.

Tips and caveats

• The command applies the symbol to every cell in the selection — select only the rows whose state you want to change instead of sweeping the whole table before clicking Checked.
• Numbers, dates and TRUE/FALSE cells are skipped entirely, so dates never turn into serial numbers.
• Text cells are switched to Text (@) format before writing, which is why a string starting with + or * is not mistaken for a formula. Formula cells keep their original format.
• Each line is trimmed at both ends before the symbol is added — lines indented with spaces lose that indent.
• (None) only recognises the add-in's own symbol set: − • + * ○ ● □ ■ ◇ ◆ ☆ ★ ☐ ☑ ☒. A keyboard hyphen - typed by hand is not removed, because the Minus command inserts the mathematical minus −.
• A cell carrying * is awkward to find with the normal Find box — the * in the cell is a literal character while * in Find is a wildcard, so search for ~*.
• Ctrl+Z does not undo this; hidden rows and columns are skipped, and each merged area is processed once at its top-left cell.

See also

• Numbering — the other half of the List Format section: 1., I., A., a. and multilevel 1.1.1.
• (None) — numbered list — the matching stripper for numbering prefixes.
• Cells and Rows — AutoFit merged so the printout does not clip the last line of a multi-line cell.