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 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 . 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. You can use its controls to determine which elements of the cut or copied elements Excel 2007 applies when they are pasted back into the worksheet.
You can find and replace data within a worksheet by searching for specific values or by searching for cells that have a particular format applied.
Excel 2007 provides a variety of powerful proofing and research tools, enabling you to check your workbook's spelling, find alternative words using the Thesaurus, and translate words between languages.
Data tables, which are new in Excel 2007, enable you to organize and summarize your data effectively.