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

Get Microsoft® Office Home and Student 2007 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.