Before using AutoFill, it is important to note that:
AutoFill allows data to be extended from a cell, or cell range, to cells in the same column(s) or row(s). Data can be extended to the cells below or to the right of the selected cell(s); however, it cannot be extended to the cells above, nor to the left.
AutoFill will copy formulas and formats.
To AutoFill:
Place your mouse cursor over the small, black square in the bottom-right corner of the cell (or cell range). The cursor will change to a small plus sign.
Click and hold down your left mouse button. Without releasing the mouse button, move your mouse cursor over the cells you want to copy to. These cells can be below or to the right of the cell(s) you originally selected.
Release the mouse button. The data from the cell(s) you originally selected will be extended to the other cells.
Values and Labels
Formulas
Release the mouse button. The formula will automatically be copied to cells D10, E10, F10 and G10.
Days and Months
You can use AutoFill to copy patterns of the names of days or months.
Built-in patterns include:
Sunday, Monday, Tuesday...
Sun, Mon, Tues, Wed...
January, February, March...
Jan, Feb, Mar...
Example:
Type Sunday in a cell.
Select the cell you just typed in (click your left mouse button somewhere outside of the cell, and then click the cell again).
Click the small black square on the bottom-right corner of the cell. While holding down your mouse button, move your mouse over adjoining cells.
Release your mouse button. The pattern Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, Monday, Tuesday... will automatically appear in the cells.
Note: A pattern can be started at any point within the pattern. For example, perhaps you entered Feb in a cell, selected the cell and then dragged the small black square to the two adjoining cells. Mar and Apr will appear in these two cells.
Cell Ranges
You can use AutoFill to extend data from a block of cells to adjoining cells.
Example:
Creating Custom AutoFill Patterns
You can create your own AutoFill patterns:
Go to the Tools menu, and click AutoFill List.
An Options window will appear.
In the Current List, type your list. Separate the items in your list with semi-colons (;). For example, item1;item2;item3.
When you are finished typing your list, click the Add button.
To return to your sheet, click OK.
Example:
Perhaps you typed one banana;two banana;three banana in the Current List box.
Click Add, and then OK.
When you return to your spreadsheet, enter one banana in a cell.
Select the cell and drag its small black square to the adjoining cells. You will see the pattern one banana, two banana, three banana, one banana, two banana, and so on.
Note: Depending on your version of EasySpreadsheet, your own customized AutoFill lists may or may not be saved along with your spreadsheet.
See Also: