O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required