Upper letters list

Location on ribbon: Tab DVD Addin → Group Text and Number → arrow on Numbering → section 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

1. Select the cells you want lettered.
2. Go to tab DVD Addin → group Text and Number → arrow on Numbering → Numbered list section → click Upper letters list.
3. The Confirm data change box tells you how many cells will be overwritten; keep Back up sheet ticked and click Continue.
4. 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.

Video tutorial

Narrated in Vietnamese, with Vietnamese subtitles. Danh sách số và chữ · 4 min 50 s · 10 cases · Download the video · Practice workbook for the video

Commands in this video: Number list · Lower letters list · Remove list numbering · Roman list · Upper letters list

Chapters (14)

1. Giới thiệu
2. Mở lệnh
3. 1 · Ô nhiều dòng
4. 2 · Đánh số lại
5. 3 · Hai cấp: La Mã và số
6. 4 · Ô trống – chữ thường
7. 5 · Ô công thức
8. 6 · Ô gộp và dòng ẩn
9. 7 · Lỡ chọn cả bảng
10. 8 · Bỏ đánh số danh sách
11. 9 · Ghi đè và hoàn tác
12. 10 · Khi không có gì để làm
13. Mẹo
14. Kết thúc

Illustrated walkthrough

Practice

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

Step 1. Select the section cells to letter (1).

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

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. Each cell gets an A., B., C., D. prefix (1). The status bar reports the lines and cells numbered (2).

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 Remove list numbering in the same menu once you have done other work; right after the command Ctrl+Z is enough.

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.