How to display A-Z without typing them manually in Excel

If we want to display a number series, say 1-100, in column A, we can simply drag the cursor to expand the series. But if we  need to display an alphabetic series, say we require A-Z, in column A, unfortunately dragging will not work. One option is to key each alphabet manually. That works, but it can be very time consuming.

To display the A-Z series without typing them manually in Excel, you can use the “char” function. Enter the following formula in cell A1 and drag it all the way to cell A90.


The result?

You will notice cell “A65″ to “A90″ will display the A-Z letters.

This entry was posted in Functions. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>