Here's our Microsoft Office Tip for.. March 13, 2000
Click Here to see a complete list of all of our previously released Tips!
Using Excel's Autofill Feature
Excel's AutoFill feature is one of its most powerful tools. You can automatically create lists of labels or values, depending on the contents of the anchored cells. You enter data in one or more cells and then use the AutoFill handle to extend and fill the selection.
Double-click the AutoFill for even more mileage. If the column to the left of the current cell contains data, double-clicking the AutoFill handle will extend the selection until it matches the contents of the column to the left. For instance, if the current cell is C5 and the column to the left contains data in cells B5:B8, double-clicking the AutoFill handle will extend the selection in column C to row 8 (C5:C8).
If there is no data in the left column, AutoFill considers the data to the right and extends the current selection to match the cell to the right. If both columns contain data, the AutoFill double-click feature gives precedent to the left column.