Create A1 Through M16 in Excel with a Fill-Down Formula
Question details
Generate a grouped sequence from A1 through M16 using a fill-down 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.
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.
Fill down a formula to generate the grouped sequence
Use this formula to create all 208 entries in one column.
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.
Select the formula cell and drag its fill handle down until the list occupies 208 cells. If you started in A1, drag through A208.
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.

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. Open a spreadsheet: Open WPS Spreadsheets and create a new workbook or open an existing spreadsheet.
- 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. 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. Verify the result: Check that the first entry is A1, the 17th entry is B1, and the last entry is M16.

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.




