Using the fill handle is easy. Simply start typing a list of consecutive numbers, dates, etc. and drag the rest. You can easily fill 100 cells in no time at all. Well what if you wanted to fill the alphabet down a list of cells? Unfortunately, Excel doesn't have this functionality built in. If you were to start typing the alphabet down column A, so that A1=A, A2=B, A3=C, and … [Read more...]

If you need to fill cells with sequential text such as months of the year, days of the week, or text plus a number such as Quarter 1, Quarter 2,…, use the fill handle to quickly create labels for the cells simply by typing the first item in the series. For example, you would type January in your first cell, then hover the mouse over the bottom right hand corner until it … [Read more...]