Datasheet

15
Chapter 1: Getting Started
1
2
3
4
2
You can easily select all cells with formulas, comments,
conditional formatting, constants, or data validation.
Click the Home tab. Click Find & Select in the Editing
group. A menu appears. Click the option you want.
Excel selects all the cells that contain the option you
selected. For example, if you chose Formulas, Excel
selects all the cells that contain formulas.
You can also use the arrow keys to select cells. Click in
any cell, hold down the Shift key and then use the left,
right, up, and down arrow keys to expand your
selection.
You can press Ctrl+Shift+an arrow key to select
everything from the active cell to the next blank cell that
is to the right, to the left, above, or below the active cell.
You can press Ctrl+Shift+* to select a block of cells. You
will find this option particularly useful with large tables.
For a list of keyboard shortcuts, see the Appendix.
Select Columns or Rows
1 Click the label for the first column or row
you want to select.
2 Drag to the last column or row you want
to select.
•
Excel selects the columns or rows.
Select Noncontiguous Cells
1 Click the corner of the first block of cells.
2 Drag the mouse to highlight the desired
cells.
3 Press Ctrl.
4 Repeat Steps 1 and 2 to select the next
block of cells.
5 Repeat Steps 3 and 4 to select additional cell
ranges.
03_591604-ch01.indd 1503_591604-ch01.indd 15 5/25/10 12:34 PM5/25/10 12:34 PM