Click Popular in the left pane and then click Edit Custom Lists. In Excel 2007, click the Office button and then click Excel Options. Choose Options from the Tools menu and click the Custom Lists tab.First, create an actual list from A to Z using either of the above methods. If you think you’ll need an alphabetic list again, consider creating a custom list. Once the alphabetic list consists of characters and no functions, you can use the fill handle to copy it.Įither of the above methods works well for a one-time task. In Excel 20, press +H+V+S+V and press Enter. I find the keyboard shortcut a bit awkward, but you might prefer it. Check the Values setting in the Paste section, and click OK. Right-click again and choose Paste Special.Choose Copy from the resulting context menu.Before you can copy the list, you must convert the list from functions to values as follows:
If you use the handle to copy the complete list, as is, you’ll get a bunch of errors. Next, use the fill handle to create your alpha list. Now, enter a CHAR() function that refers to the cell storing the integer 65. As you move down, Excel will display values for each cell that you add to the selection.
Fortunately, there are three workarounds for forcing the fill handle to produce the list. 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. 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. Microsoft Excel's fill handle tool won't create an alphabetic list by default, but there are a few tricks you can use to make it work. Using Excel’s fill handle to create an alphabetic list