To select a custom cell range:
1.Hold the pointer over the first cell in a range.
2.With the left mouse button pressed, drag the pointer over the cells you want to select.
You can select a range in any direction of rows or columns.
Here are some cell range selection examples:
To select the entire row or column:
1.Place the pointer over the header of the element that you want to select.
2.Left-click the header.
To select multiple rows and columns entirely:
1.Place the pointer over the header of the first element that you want to select.
2.Press Shift, click the header of the first element and click the header of the second element while keeping the Shift button pressed. All rows or columns within the selected range will be selected.
To select a row or column containing merged cells, select the first row or the first column containing that cell.
To select all cells in the current sheet of a spreadsheet, do one of the following:
•On the menu, select .
When using these commands, only the cells on the active sheet are selected. Cells on the other sheets in the spreadsheet are not selected.
To deselect a cell range, left-click any cell in a spreadsheet.
When you move to another sheet, the range remains selected.