Have you ever tried to input “A” and then drag it down with a hope of getting a list of 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.  😉