The AutoFill feature in Microsoft Excel can automatically fill in cells with commonly used series (numbers, months, and days of the week) or with custom lists you can create. This chapter demonstrates how to use the drag handle and other ways to fill in information. These operations work in all directions: top down, down up, left to right, and right to left. Figure 1.1 demonstrates this feature.
Select two adjacent cells and release the mouse. When you hover again over the lower right corner, your mouse pointer should change shape to a crosshair (+) called a drag handle. You can click and drag down the column and Excel will continue the initial two-cell series for you.
You can AutoFill several types of data including, but not limited to, numbers, dates, days, and annual quarters by selecting cells and dragging the handle as shown in Figure 1.1.
The most popular Form Filling software this year has to be AnyForm Form Software. This software allows you to create new form as well as to fill in paper and pre printed forms. It helps you turn paper forms in electronic forms and add arithmetic formulae on forms.
By default, a number of AutoFill lists are pre-installed in the program. For a list of the available AutoFill series, in the 2010 version we use the File icon to get to the Excel Advanced Options menu and the Custom Lists menu. See Figure 1.2. For 2007 go to the Windows icon, click on Excel Options, and click on the Edit Custom Lists button. See Figure 1.2.
FIGURE 1.2 Custom Lists
![Windows Windows](http://techpackets.com/wp-content/uploads/2011/02/Chrome-autofill-Logo.png)
![Delete autofill on mac Delete autofill on mac](/uploads/1/2/6/2/126225050/526515732.png)
You ...