Get a list of A to Z in #Excel

Have you ever tried to input “A” and then drag it down with a hope of getting a list of A to Z?

Excel Tip - Fill A to Z

If you tried (and without success), you may be wonder how I did it?

You may find the trick (using Custom List) in the following video:

The video starts with a formula to get a list of A to Z, followed by using the result for saving your custom list for future use.

Please note the pinned comment by Mike Girvin from excelisfun channel.ย  Mike suggested a robust formula for getting A to Z, which is super nice. ๐Ÿ‘

Hope you like the video.ย  If you do, please subscribe to my YouTube channel, and share it with your friend.ย  ๐Ÿ˜‰


About MF

An Excel nerd who just transition into a role related to data analytics at current company......๐Ÿ˜Š Recently in love with Power Query and Power BI.๐Ÿ˜ Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.