Numbering

Number sequence cells — simple (1, 2, 3) or multilevel (1, 1.1, 1.1.1, 2, 2.1, ...).

Simple numbering (Number)

DVD Addin → group Text and Number → split-button Number → main click (or dropdown → "Simple Number").

How to use

1. Select the start cell (e.g. A2 — number 1 will be written here).
2. Enter start number in dialog (default 1).
3. Enter step (default 1).
4. Range:
   • To cell — enter cell address (e.g. A100) → fill from start down.
   • Cell count — enter N → fill down N cells.
5. Options:
   • Skip empty rows — if the adjacent column has an empty cell, do NOT number that row.
6. Click OK → writes 1, 2, 3, ... starting at the start cell.

Example

A table with column A empty, column B has data B2:B50, B5 and B12 are empty.

Number at A2 with "Cell count = 50" + tick "Skip empty rows":

• A2 = 1, A3 = 2, A4 = 3, A5 = (blank), A6 = 4, ..., A12 = (blank), A13 = 11, ...

→ Sequence numbers don't shift when there are empty rows.

Multilevel numbering

DVD Addin → group Cells and Rows → split-button Multilevel → click.

Number by WBS (Work Breakdown Structure) tree: 1, 1.1, 1.1.1, 1.2, 2, ...

How to use

1. Prepare a table with a "Level" column — 1 for top, 2 for child, 3 for grandchild, ...
2. Select the range to number (the No. column).
3. Dialog opens:
   • Level cell — adjacent cell containing the level number.
   • Separator — . (default) → 1.1.1. Or - → 1-1-1.
   • Format:
     • Decimal: 1, 1.1, 1.1.1, 2, ...
     • Roman: I, I.1, I.1.a, ...
     • Letter: A, A.1, A.1.a, ...
   • Auto reset when parent changes:
     • Tick → restart from 1 each time the parent level increments.
     • Untick → continuous count, no reset.
4. Click OK.

Example

Table:

Level	Description	(No. — to be filled)
1	Foundation	1
2	Earthwork	1.1
2	Lean concrete	1.2
2	Formwork	1.3
3	Column formwork	1.3.1
3	Beam formwork	1.3.2
1	Superstructure	2
2	Floor 1 columns	2.1
...	...	...

Roman / Letter numbering (Bullet)

DVD Addin → group Text and Number → menu Bullets.

Options:

• Bulleted list (•) — round dot.
• Roman uppercase (I, II, III, IV, ...).
• Roman lowercase (i, ii, iii, iv, ...).
• Letter uppercase (A, B, C, ...).
• Letter lowercase (a, b, c, ...).
• Filled circle (●).
• Black star (★).
• Black rhombus (♦).
• X checkbox (☒) / V checkbox (☑) / Empty checkbox (☐).
• Asterisk (*).

Different from Numbering: only adds a bullet character at the start of each selected cell, not a sequence number.

Custom step numbering

To number 5, 10, 15, 20, ... → open the Number dialog → step = 5, start = 5.

Or with letters: A, C, E, G, ... — not directly supported, use Excel formula CHAR(64 + ROW(A1)*2).

Troubleshooting

Numbers duplicate / skip when there are empty rows

• Tick Skip empty rows in the Number dialog.
• Adjacent column dependency — the addin checks the column NEXT TO the start cell, not the start cell itself.

Wrong number format (e.g. 1.1 displays as a date)

• Cell formatted as Date/Currency → switch to General (Ctrl+1 → General).
• Or prefix with apostrophe ': '1.1.

Multilevel doesn't reset when parent changes

• Tick Auto reset when parent changes in the dialog.
• Verify the Level column: child levels must be GREATER than parent (e.g. parent = 1, child = 2, grandchild = 3).

License gating

All numbering commands (simple, multilevel, bullet) are free — no license required.

Related

• Insert Rows — auto insert rows.
• Delete Empty Rows — remove empty rows.
• Multilevel Numbering — variant of Numbering.