You can enter a series of data quickly by entering one or more values in adjacent cells, selecting the cells, and then dragging the fill handle. To change how dragging the fill handle extends a data series, hold down the Ctrl key.
Dragging a fill handle displays the Auto Fill Options button, which enables you to specify whether to copy the selected cells’ values, extend a recognized series, or apply the selected cells’ formatting to the new cells.
Excel 2007 enables you to enter data by using a drop-down list, AutoComplete, and Ctrl+Enter. You should experiment with these techniques and use the one that best fits your circumstances.
When you copy (or cut) and paste cells, columns, or rows, Excel 2007 displays the Paste Options smart tag. ...