00:00have you ever seen anything like this where the alphabet increases as you drag the fill handle
00:06this feature is not something that's turned on by default in excel let me start from the beginning
00:10if you drag the field handle for numeric values sure you'll increase as it goes down the list
00:16however for alphabet it just repeats by itself even if you have the cell in this format
00:21in order for you to have an alphabet increase sequentially follow these steps go to file options
00:28advance scroll all the way down and click on edit custom list then in list entry enter the comma
00:35separated a to z like this and after that click on add and click on ok and ok now when
00:42you go to the
00:42alphabet cell and drag the fill handle the alphabet appears in sequential increments it also works if
00:48you double click the fill handle on the alphabet cell
00:50you
00:51you
00:53you
Comments