How to enter consecutive letters: A, B, C… Excel

When you want to enter consecutive numbers in Excel, such as 1, 2, 3, etc., it is convenient to use the AutoFill feature.

Now, what if you want to enter sequential alphabetical data like A, B, C, etc. Unfortunately, alphabetical sequences do not support auto-fill.

This time, we will introduce how to enter consecutive letter data, such as A, B, C, etc.

Using the CHAR function

Use the CHAR (character) function.

function	CHAR
Description	Returns the character specified by the number.
Format	=CHAR(number)
link	Official Office Support

Computers have character codes for numbers.

These are called "ASCII codes."

The CHAR function returns the character code for a number.

There, 65 is "A", 66 is "B", 67 is "C", and so on.

*There is no basis for these numbers, so the only way to find out is to check the JIS code.

Enter "=CHAR(64+ROW())" in cell A1.

The ROW function returns the row number.

If you use "()" without specifying an argument, it will return the row number of the input cell.

Since cell A1 is in the first row, ROW() = 1, 64 + ROW() = 65, and CHAR(65) = "A".

function	ROW
Description	Returns the row number of the specified array.
Format	=ROW([Range])
link	Official Office Support

When you autofill downwards, ROW() increases by 1, allowing you to enter consecutive data such as A, B, C, etc.

Similarly, if you want to enter data horizontally, enter "=CHAR(64+COLUMN())".

The COLUMN function returns the column number.

function	COLUMN
Description	Returns the column number of the specified array.
Format	=COLUMN([Range])
link	Official Office Support

By applying AutoFill horizontally, you can enter consecutive data horizontally, such as A, B, C, etc.

summary

What did you think?

We introduced how to use the CHAR function to enter consecutive alphabetical data such as A, B, C, etc.

If you've been typing A, B, C…, you should definitely try this.