Upper letters list
Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Numbered list
Command ID: btnUpperLettersList
What it does
Prefixes the selected cells with uppercase letters A., B., C., … A single counter runs across the whole selection in row-major order.
The letter level usually sits between the Roman level and the number level: part I → sections A, B, C → items 1, 2, 3. You see it constantly in method statements, technical specifications and the main headings of acceptance records. Any earlier list prefix is stripped before writing, so repeated clicks are safe.
How to use
- Select the cells you want lettered.
- Go to tab DVD Addin → group Text and Number → open the Numbered list menu → click Upper letters list.
- The command runs immediately — no dialog appears.
- The Excel status bar reports how many lines and cells were processed.
How each cell is handled:
- Text cell: every line inside the cell gets its own letter.
- Empty cell: only the prefix is written, e.g.
B.. - Formula cell: wrapped as
=""&"B. "&(original formula), keeping the formula live. - Numeric, date and TRUE/FALSE cells are skipped.
Example
Main sections of a superstructure method statement:
| Before | After |
|---|---|
| Site preparation works | A. Site preparation works |
| Formwork and scaffolding method | B. Formwork and scaffolding method |
| Reinforcement method | C. Reinforcement method |
| Safety and environmental controls | D. Safety and environmental controls |
Notes
- After Z the counter wraps back to A — it does not continue with AA, AB.
- Value cells are forced to Text format (
@) before writing. - Hidden rows and columns are skipped; a merged area counts once and the letter lands in its top-left cell.
- The counter only advances after a successful write, so a locked cell leaves no gap.
- Use (None) in the same menu to remove the prefixes rather than Ctrl+Z.
Related
- Lower letters list — the same engine with lowercase a., b., c.
- Roman list — the higher level that normally sits above letters.
- Number list — the 1., 2., 3. level below letters.
- Upper letters — fills a letter sequence into its own column.