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.

=char(row())

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>

*
*