Selecting data
• Select nonadjacent cells or ranges by selecting the first cell or range, and then holding down CTRL while you select other cells or ranges.
• To select only the blank cells in a region, select the region, click Go To on the Edit menu, click Special, and then click Blanks.
• Selecting a large range is easy. Just click the cell at one corner of the range, scroll to the opposite corner, and then hold down SHIFT while you click the cell at that corner.
• You can specify the direction you want the selection to move after you enter data in a cell (for example, to the right if you work in rows). Click Options on the Tools menu, make sure the Move selection after Enter check box is selected on the Edit tab, and then click a direction in the Direction box.
• Move to a specific area of the worksheet (such as the current region or the last cell) by clicking Go To on the Edit menu. Click Special, and then select the option you want.
Editing data
• Instead of using the formula bar to edit the contents of a cell, you can edit directly in the cell by double-clicking it.
• If you don't want to edit directly in cells, click Options on the Tools menu, click the Edit tab, and then clear the Edit directly in cell check box.
• To increment a single number, hold down CTRL while you drag the fill handle at the corner of the selection.
• To increment weekdays, quarters, or other series, select the first item and then drag the fill handle at the corner.
• Create your own custom fill