Microsoft® Office Home and Student 2007 Step by Step

Key Points

• 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. ...