Formula Errors

Create A1 Through M16 in Excel with a Fill-Down Formula

Chanuka GeekiyanageChanuka Geekiyanage Nov 20, 2026 869 views

Question details

Generate a grouped sequence from A1 through M16 using a fill-down formula.

Create A1 Through M16 in Excel with a Formula
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants each letter from A to M paired with the numbers 1 through 16 in a single column.
Observed behavior
The desired list starts with A1 through A16, continues with B1 through B16, and ends with M1 through M16.
Before you start

Choose an empty column with at least 208 consecutive cells available. Each letter group contains 16 entries, and there are 13 letter groups from A through M.

Solution 1Recommended

Fill down a formula to generate the grouped sequence

Use this formula to create all 208 entries in one column.

1
Enter the formula

Select the first cell for the list, such as A1, and enter =CHAR(64+ROUNDUP(ROW(1:1)/16,0))&MOD(ROW(1:1)-1,16)+1. Press Enter.

2
Fill the formula down

Select the formula cell and drag its fill handle down until the list occupies 208 cells. If you started in A1, drag through A208.

3
Check the sequence

Look at the results: the first 16 cells should show A1 through A16, the next cell should show B1, and the last cell should show M16.

Fill down a formula to generate the grouped sequence
Change the group size: For a different number of entries per letter, replace both occurrences of 16 in the formula with the desired group size. The formula produces single-letter groups from A through Z.
WPS Spreadsheets

Generate the same grouped sequence in WPS Spreadsheets

Use the fill-down formula in WPS Spreadsheets to create A1 through M16 in a single column.

  1. 1. Open a spreadsheet: Open WPS Spreadsheets and create a new workbook or open an existing spreadsheet.
  2. 2. Enter the formula: Select an empty cell, such as A1, and enter =CHAR(64+ROUNDUP(ROW(1:1)/16,0))&MOD(ROW(1:1)-1,16)+1. Press Enter.
  3. 3. Fill down 208 cells: Select the formula cell and drag its fill handle down through 208 cells. If you started in A1, fill through A208.
  4. 4. Verify the result: Check that the first entry is A1, the 17th entry is B1, and the last entry is M16.
Generate grouped letter-and-number sequences with a formulaOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceFill formulas down a column quickly
microsoft office alternative - wps office

Frequently Asked Questions

How many cells do I need for A1 through M16?

You need 208 cells: 13 letter groups multiplied by 16 entries per group. Starting in A1, fill the formula through A208.

Can I start the formula in a cell other than A1?

Yes. Enter the formula in any empty cell and fill it down 208 cells. ROW(1:1) starts the sequence at A1 regardless of the formula cell's location.

How do I change the number of entries in each letter group?

In the formula, replace both instances of 16 with the number of entries you want per letter. Then fill down enough cells for all your groups.

Will the formula continue past M16?

Yes. If you fill beyond the 208th cell, the next entry is N1. Stop at 208 cells to end the list at M16.