Create an AA, AB, AC Numbering Sequence in Microsoft Word
Question details
Create paragraph labels that continue from z to aa, ab, ac, and beyond in Word.

- Product
- Microsoft Word 2016
- Device & OS
- not provided
- Scenario
- The user wants to apply a continuous alphabetical sequence to paragraphs in a document.
- Observed behavior
- Word's built-in numbering does not provide the requested sequence after z.
Open the document in desktop Word and identify the paragraphs you want to label. If they already have automatic numbering, remove it from Home > Numbering first to avoid duplicate labels.
Use a VBA macro to add alphabetical labels to selected paragraphs
Use this method in desktop Word to insert labels such as (a), (z), (aa), and (ab), each followed by a tab.
The macro inserts plain text rather than automatic list numbering. Labels will not update when you add, delete, or rearrange paragraphs, and running the macro again will add another set of labels.
In Word, open the VBA editor with Alt+F11 on Windows, then select Insert > Module.
Paste this code into the module: Sub AddAlphabeticalLabels() Dim selectedRange As Range Dim i As Long Set selectedRange = Selection.Range For i = selectedRange.Paragraphs.Count To 1 Step -1 selectedRange.Paragraphs(i).Range.InsertBefore "(" & AlphaLabel(i) & ")" & vbTab Next i End Sub Function AlphaLabel(ByVal number As Long) As String Dim result As String Do While number > 0 number = number - 1 result = Chr(97 + (number Mod 26)) & result number = number \ 26 Loop AlphaLabel = result End Function
Return to the document and select the paragraphs to label. Avoid including the start of an extra paragraph unless it should also receive a label.
Choose View > Macros > View Macros, select AddAlphabeticalLabels, and click Run. Check that the labels begin with (a) and continue with (aa) after (z).

Edit Alphabetical Lists with WPS Writer
WPS Writer is a free, lightweight alternative for editing Word documents in a familiar interface. Open an existing document and edit its paragraph labels while moving between compatible Office formats; it does not fix Word's numbering settings.

Frequently Asked Questions
Does Word automatically update the labels added by this macro?
No. The macro inserts plain text. If you add, delete, or move paragraphs, edit the labels manually or remove the existing labels before running the macro again.
What label comes after (z)?
The macro continues with (aa), (ab), and (ac). It also handles longer labels after (zz).
How do I save the macro with my document?
If the macro is stored in the document, select File > Save As and choose Word Macro-Enabled Document (.docm). A standard DOCX file cannot retain VBA macros.
Can I start the selected paragraphs at a label other than (a)?
The supplied macro starts each selection at (a). To start elsewhere, change the number passed to AlphaLabel in the VBA editor; for example, AlphaLabel(i + 26) starts at (aa).




