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. 😉