You can select and work with multiple cells if the selection is rectangular and contiguous.
To select a cell range, a row, or a column:
Open a form.
Take an action:
To select a cell range, click in the range's upper-left cell, press Shift, and then click in the range's lower-right cell.
To select a row or column, click in its heading.
After you select a group of cells, you can copy and paste them or adjust the data values. See: