(None)
Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Multilevel
Command ID: btnNone_3
What it does
Strips the multilevel numbering prefix (1., 1.1., 1.1.1. …) previously applied to the selected cells and returns the content to its original text. Only the leading number group is cut; the wording after it is untouched.
Use it whenever the structure of the table changes — a new item is inserted, an indent level is adjusted, two sections are merged — and you want to renumber from scratch. It is also worth running before clicking Multilevel 1.1.1 a second time, because the multilevel command does not clear old prefixes by itself.
How to use
- Select the cells that currently carry multilevel numbers.
- Go to tab DVD Addin → group Text and Number → open the Multilevel menu → click (None).
- The command runs immediately — no dialog appears.
- The Excel status bar reports something like "Processed N cells (multilevel)".
How each cell is handled:
- Text cell: the leading pattern "one or more number groups ending with a dot, plus a space" is removed, e.g.
1.2.3.. - Formula cell: only the wrapper DVDAddin itself created (
=""&"1.1. "&(…)) is unwrapped, restoring the original formula. - Empty, numeric, date and TRUE/FALSE cells are left alone.
Example
A bill of quantities that has to be renumbered after a new section was inserted:
| Before | After |
|---|---|
| 1. Substructure | Substructure |
| 1.1. Earthworks | Earthworks |
| 1.1.1. Machine excavation | Machine excavation |
| 2. Superstructure | Superstructure |
Notes
- The prefix is only cut from the start of the cell; lines inside a multi-line cell are not processed individually.
- A formula you wrote yourself, such as
="1.1. "&B2, is left untouched because it lacks the marker DVDAddin adds when wrapping. - The command does not change number formats — a cell forced to Text during numbering stays Text.
- Hidden rows and columns are skipped; a merged area counts once, via its top-left cell.
- Content is overwritten in place, so verify the result before saving rather than relying on Ctrl+Z.
Related
- Multilevel 1.1.1 — the numbering this command removes.
- Number list — the single-level 1., 2., 3. numbering.
- (None) — removes single-level list prefixes in the Numbered list menu.
- (None) — removes bullet symbols.