Function Problems

How to Repeat the Alphabet A-Z Multiple Times in Excel

Bushra Parveen Oct 15, 2026 869 views

Question details

The user needs to generate a vertical list in a spreadsheet that repeats the English alphabet (A through Z) 30 times, resulting in 780 rows of data.

How to Repeat the Alphabet A-Z Multiple Times in Excel

Product: Excel
Device & OS: not provided
Scenario: Generating a repetitive sequence of letters vertically for data categorization, testing, or labeling purposes.
Observed behavior: Populating 780 continuous rows starting from cell A1 with a cyclical A to Z sequence.

Before you start

Ensure your spreadsheet software is updated to a version that supports dynamic array functions like SEQUENCE, and verify that you have at least 780 empty rows below your target cell to prevent #SPILL! errors.

Solution 1Recommended

Use Dynamic Array Formulas (SEQUENCE and CHAR)

The most efficient way to generate a repeating alphabet in modern spreadsheets is by combining dynamic array functions. This single formula will automatically populate all required rows.

Dynamic array formulas allow a single function to return multiple results, automatically 'spilling' them into adjacent cells. By using SEQUENCE to generate numeric values and CHAR to convert them into ASCII characters, you can easily loop through the alphabet.

Select the starting cell

Click on cell A1, or whichever cell you want the sequence to begin in.

Enter the SEQUENCE formula

Type the following formula exactly as shown: =CHAR(ROUNDDOWN(SEQUENCE(30*26,,65+1/30,1/30),0))

Execute the formula

Press Enter. The formula will automatically spill down 780 rows, producing the letters A through Z repeatedly for 30 complete cycles.

Use Dynamic Array Formulas (SEQUENCE and CHAR)

Alternative Formula: If you prefer a modular approach, you can also use: =CHAR(65+MOD(SEQUENCE(780)-1,26)) which yields the same repeating A-Z result.

Solution 2

Generate the Sequence using Power Query

Ideal for data modeling and manipulation, Power Query can quickly generate a repeating list of characters using M code.

Generate Sequences Easily with WPS

Use WPS Spreadsheet to Quickly Generate Repeated Sequences

WPS Spreadsheet fully supports advanced dynamic array formulas like SEQUENCE, providing a lightweight, fast environment for managing large datasets and complex calculations.

1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing spreadsheet document.
2. Select your target cell: Click on the cell where you want your alphabet sequence to begin (e.g., A1).
3. Input the formula: Type the dynamic array formula =CHAR(65+MOD(SEQUENCE(780)-1,26)) into the formula bar.
4. Generate the sequence: Press Enter to instantly populate the 780 rows with your A-Z cycles.

Fully compatible with Microsoft Excel formulas and functionsSeamlessly supports dynamic array functions for rapid data generationFree, lightweight, and fast performance even with large datasetsFamiliar user interface requiring no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

How can I repeat the alphabet horizontally across columns instead of rows?

You can change the orientation by specifying columns instead of rows in the SEQUENCE function, or by wrapping the existing formula inside a TRANSPOSE() function.

Why am I getting a #SPILL! error when I enter the formula?

A #SPILL! error occurs if there is existing data blocking the formula from expanding into the necessary 780 rows. Clear the cells immediately below your formula to resolve this.

Can I generate a sequence of lowercase letters?

Yes. Lowercase letters have different ASCII values starting at 97 for 'a'. You can modify the formula to use 97 instead of 65 (e.g., =CHAR(97+MOD(SEQUENCE(780)-1,26))).

Is there a way to do this in older versions of Excel without the SEQUENCE function?

Yes, in older versions that do not support dynamic arrays, you can enter =CHAR(65+MOD(ROW(A1)-1,26)) in cell A1, and then manually drag the fill handle down to row 780.

Excel & Data Problems