Selecting Cell Ranges

You can select and work with multiple cells if the selection is rectangular and contiguous. To select a cell range in an ad hoc grid, click in the range's upper-left cell, click Shift, and then click in the range's lower-right cell. To select a cell range in a form, hover over the cell until the icon changes; then you can extend the range.

To select a row or column, click its heading. After you select a group of cells, you can copy and paste them or adjust the data values.