HDTutorial
EN
How to AutoFill the Letters in the Alphabet in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to AutoFill the Letters in the Alphabet in Excel

260,618 views October 25, 2012 7:17

Watch on YouTube
ChannelDanny Rocks

Description from the creator

One of my viewers wants to be able to Autofill the letters in the Alphabet - he uses them in creating part numbers for his products.

Many Excel users are familiar with AutoFill to increment a series of Dates, Times, Months of the year, etc. In this lesson, I also show you some AutoFill tricks that most users do not know!

I will be using a combination of the CHAR() and ROW() Functions to quickly create the Alphabetical List and then, in Excel 2010, to turn this into a Custom List.

Later in the lesson, I will share a great tip to include the COpyright Symbol in the Footer Section of your Excel Workbook.

I invite you to visit my new, secure online shopping site - shop.thecompanyrocks.com - to preview my new extended length video tutorials.

Danny Rocks
The Company Rocks

About this tutorial

Danny Rocks published this 7:17 video tutorial on October 25, 2012. It has been watched 260,618 times on YouTube.

Category
Education
Duration
7:17
Published
October 25, 2012
Views
260,618
Likes
965

Tags

Share

Further reading

  • How To Autofill Letters From A-Z In Excel - AddictiveTips addictivetips.com

    Microsoft Excel has a neat autofill feature that can complete a series like days of the week, months of the year, or numbers in a series e.g., odd or even numbers, etc. Unfortunately, this feature doesn’t cater to the l…

  • How to autofill alpha characters in Excel? extendoffice.com

    Autofill alpha characters in Excel with formula. You can also create a formula to auto fill alphabet into cells, please do as this: 1. In a blank cell which you want to place the alphabet, enter this formula: =CHAR(ROW(…

  • How to autofill alpha characters in Excel? extendoffice.com

    Autofill alpha characters in Excel with creating a custom list. Creating a custom list of the alpha characters, you can use the alphabetic list time and time again whenever you want to auto fill them. You can do as foll…

This tutorial in other languages