Sheet Numbering

Location on ribbon: Tab DVD Addin → Group View and Sheets → Menu Sheet Menu

Command ID: btnSheetAutoNumber

What it does

Prefixes every visible sheet name with a sequence number in tab order, left to right: 1_, 2_, 3_… If a name already carries a numeric prefix followed by an underscore, the old prefix is stripped before the new one is applied, so repeated runs always produce a clean, gap-free sequence.

Use it to lock the document order inside a multi-sheet submission — method statement, quantities, appendices — so the recipient knows the reading and printing order at a glance.

How to use

1. Drag the tabs into the order you want.
2. Hide any working sheets that should not be numbered (hidden sheets are skipped).
3. Go to tab DVD Addin → group View and Sheets → Sheet Menu → Sheet Numbering.
4. The rename happens immediately with no further prompt, then a message reports "Numbered N sheets (errors=…)".
5. Check the tab bar; if the order was wrong, rearrange the tabs and run the command again.

Example

A cost estimate workbook, tab bar before and after:

Before	After
Thuyetminh	1_Thuyetminh
Tonghop	2_Tonghop
KL-Mong	3_KL-Mong
KL-Than	4_KL-Than
2_Phuluc	5_Phuluc

2_Phuluc already carried an old number; the add-in strips 2_ and re-applies 5_ for its new position.

Notes

• The prefix is a plain counter (1_, 2_, … 10_) with no leading zero; for 01_ style names use Rename Sheets with a mapping table.
• Only visible sheets are numbered; hidden sheets are neither renamed nor counted in the sequence.
• Only an integer prefix before the first underscore is stripped; a name like KL_Than is left intact and becomes 3_KL_Than.
• A resulting name longer than 31 characters is rejected by Excel, counted as an error, and that sheet keeps its old name.
• Hold ESC to stop partway. The command cannot be undone with Ctrl+Z.

Related

• Rename Sheets — mapping-table renaming when you need a custom rule.
• Sheet List — build the index once the numbering is right.
• UnDiacritics — clean up sheet names before numbering them.
• Navigation — reorder the tabs before running the command.