[Free Excel Tutorial] HOW TO AUTOFILL THE LETTERS IN ALPHABET IN EXCEL -Full HD
[Free Excel Tutorial] HOW TO AUTOFILL THE LETTERS IN ALPHABET IN EXCEL -Full HD
If you've tried to create an alphabetic list using Excel's fill handle, you already know that the fill handle can't handle the task. For instance, if you enter A, B, and C, in adjacent cells and then use the fill handle to fill in the rest, it just copies A, B, and C, over and over. Fortunately, there are three workarounds for forcing the fill handle to produce the list. Create a manual list.
You can enter A through Z yourself. Then, select the cells that contain the letters and use the fill handle to copy the entire alphabet as many times as required. This way isn't so hot, but it'll work.
The AutoFill tool in Excel has a few standard sequences it will fill automatically, such as dates and numeric sequences. The very powerful part of AutoFill, however, is that you can create custom lists that the tool uses just as easily as the built-in sequences. In order to create a custom list manually, you can follow these steps:
1. Display the Excel Options dialog box. In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and Excel2013 display the File tab of the ribbon and then click Options.
2. If you are using Excel 2007, make sure Popular is selected at the left of the dialog box. If you are using Excel 2010 or Excel 2013, click Advanced at the left of the screen and scroll down to the General area.
3. Click Edit Custom Lists. Excel displays the Custom Lists dialog box and hides the Excel Options dialog box.
Free Excel Tutorial, HOW TO AUTOFILL THE LETTERS IN ALPHABET IN EXCEL, Full HD
Free Tutorial, HOW TO AUTOFILL, ALPHABET IN EXCEL, Full, HD
Excel Tutorial, HOW TO AUTOFILL IN EXCEL
This video [Free Excel Tutorial] HOW TO AUTOFILL THE LETTERS IN ALPHABET IN EXCEL -Full HD is copyrighted for Rui Ludovino channel: • [Free Excel Tutorial] HOW TO AUTOFILL THE ...