This article explains how we can have A-Z letters on a column without typing them in manually.

If we want a number series say 1-100, we can simply drag the cursor to expand the series. But if we instead need an alphabetic series say we require A-Z in column A then simple dragging system would not work.And it will be very time consuming if we key them in manually.

We can use the following methods to get around this:

1)Using “Char” function
Enter =char(row()) in cell A1 and drag it.
You will notice cell “A65″ to “A90″ will give the A-Z letters.
Just copy these and use them anywhere. But make sure you make them values before pasting them somewhere else.You can do that using Edit- paste special - values.

2)Using cell function
Enter =CELL(”address”,A1) and drag it to the last column.
This will return $A$1. To pull out just A from this we can use left and right functions.
=RIGHT(LEFT(CELL(”address”,A1),2),1)

An excel worksheet has 65,536 rows and 256 columns.
Excel assigns numbers to rows starting with 1 and letters to columns starting from A.
But as number of columns are more than 26, so it names column 27 as AA and column 52 as AZ, and names column 53 as BA and so on.
Therefore, after 26th column, we will need to modify our right and left function a bit so that it takes two letters from the right and not just one as shown below:

Once we have the list, we can add it to a custom list so that next time we can simply drag cursor to get an alphabetical list.
To add it to a custom list, first keep the alphabetic list handy in column A. Then go to “Tools” and then “options” and then custom list. Just import the list from column A and hit OK.

Sometimes your worksheet may have several columns. And each may have functions referencing to different columns like cell B5 = D5+K5+AB5+BF5. It will be very time consuming if we go to each cell to check what it is. In that case, if we make a list of all the columns with their headings,it will save a lot of time. Say, we have the following worksheet with columns till J

We can make a list to display what each column represents.

Popularity: 29%