Formatting Issues

Create an AA, AB, AC Numbering Sequence in Microsoft Word

Olivia MillerOlivia Miller Nov 20, 2026 868 views

Question details

Create paragraph labels that continue from z to aa, ab, ac, and beyond in Word.

Create an AA, AB, AC Numbering Sequence in Microsoft 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the VBA editor

In Word, open the VBA editor with Alt+F11 on Windows, then select Insert > Module.

2
Paste the macro

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

3
Select the paragraphs

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.

4
Run the macro

Choose View > Macros > View Macros, select AddAlphabeticalLabels, and click Run. Check that the labels begin with (a) and continue with (aa) after (z).

Use a VBA macro to add alphabetical labels to selected paragraphs
Keep the macro if needed: If you store the macro in the document and want to retain it, use File > Save As and choose Word Macro-Enabled Document (.docm). Only enable macros from sources you trust.
Free Microsoft Office alternative

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.

Edit alphabetical paragraph labels and surrounding textOpen and save compatible Microsoft Word DOC and DOCX filesUse a familiar interface for everyday document editingMove existing documents into a lightweight, free office suite
microsoft office alternative - wps office

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).