2007 Microsoft® Office System Step by Step, Second Edition
by Joyce Cox, Curtis D. Frye, M. Dow Lambert III, Steve Lambert, John Pierce, Joan Lambert
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. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access