Function Problems

How to Create an Alphanumeric Sequence Like A1, A2, A3 in Excel

Algirdas Jasaitis Oct 21, 2026 868 views

Question details

The user wants to generate a sequential list combining a text prefix and incrementing numbers (e.g., A1, A2, A3) across rows or columns.

How to Create an Alphanumeric Sequence Like A1, A2, A3 in Excel

Product: Excel
Device & OS: not provided
Scenario: Generating lists, custom IDs, or tracking numbers that require a standard text prefix followed by a continuous numeric sequence without manual typing.
Observed behavior: Users need a fast way to fill this specific text-and-number pattern, and optionally convert formula-based sequence results into static text values.

Before you start

Ensure you have a clear starting cell and enough empty adjacent cells in the row or column to accommodate the sequence without overwriting your existing data.

Solution 1Recommended

Use the Auto Fill Handle for Quick Sequences

The easiest way to create a text-and-number sequence is by using Excel's built-in Auto Fill feature, which automatically recognizes alphanumeric patterns.

Excel is designed to recognize sequences that start with text and end with a number. By simply dragging the fill handle, you can generate hundreds of sequential values in seconds.

Enter the starting value

Click on your desired starting cell and type the initial value of your sequence, such as A1.

Use the fill handle

Select the cell you just typed in. Hover your cursor over the small green square in the bottom-right corner of the cell until the cursor changes to a solid black plus sign.

Drag to fill the sequence

Click and hold the left mouse button, then drag the fill handle vertically down a column or horizontally across a row. Release the mouse button to populate the cells with A2, A3, A4, and so on.

Use the Auto Fill Handle for Quick Sequences

Auto Fill Options: If Excel copies the exact same text instead of creating a sequence, click the small 'Auto Fill Options' icon that appears next to your selection after dragging, and choose 'Fill Series'.

Solution 2

Generate Dynamic Sequences Using the ROW Formula

If you need a sequence that automatically adjusts when rows are added or deleted, using a formula is the best approach.

Seamless Spreadsheet Management

Easily Create Custom Sequences with WPS Spreadsheet

WPS Spreadsheet offers intuitive Auto Fill capabilities that perfectly match Microsoft Excel. You can generate alphanumeric sequences, dates, and custom lists with a simple drag, completely free of charge.

1. Open WPS Spreadsheet: Launch WPS Office and open your workbook or create a new one.
2. Type the starting value: Enter your initial sequence value, such as A1, into a cell and press Enter.
3. Drag the fill handle: Select the cell, click the small square in the bottom-right corner, and drag it across your desired rows or columns.
4. Format as values: If you used a formula instead, use the Paste Special feature on the ribbon to quickly convert dynamic formulas to static text values.

100% compatible with Microsoft Excel files (.xlsx, .xls)Smart Auto Fill recognizes complex text and number patternsBuilt-in Paste Special features for advanced data formattingLightweight application that runs smoothly on all devices

microsoft office alternative - wps office

Frequently Asked Questions

Why does Auto Fill copy the exact text instead of creating a sequence?

If your spreadsheet only copies the text (e.g., A1, A1, A1), it means the default drag action is set to copy. To fix this, click the Auto Fill Options icon that appears at the bottom right of your selection after dragging, and select 'Fill Series' instead of 'Copy Cells'.

Can I create a sequence with text at the end, like 1A, 2A, 3A?

Yes. You can type '1A' in the first cell and drag the fill handle. If Auto Fill doesn't recognize the pattern automatically, you can use a formula like =ROW()&"A" and drag it down to achieve the result.

How do I create a sequence that skips numbers, like A1, A3, A5?

Type 'A1' in the first cell and 'A3' in the cell directly below it. Select both cells together, then drag the fill handle down. The spreadsheet will recognize the pattern and increment the numbers by 2 automatically.

How do I remove the formulas and keep only the sequence text?

Select the cells containing your formulas, copy them (Ctrl+C), right-click the same selected area, choose 'Paste Special,' and click 'Values'. This instantly converts dynamic formula outputs into static text.

Excel & Data Problems