Select a custom cell range

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:

range_row

range_column

range_rect

Select a row or column entirely

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 the Shift key, 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.

Select all cells in a spreadsheet

To select all cells in the current sheet of a spreadsheet, do one of the following:

On the Edit menu, select Select all.

Press Ctrl+A.

When using these commands, only the cells on the active sheet are selected. Cells on the other sheets in the spreadsheet are not selected.

Deselect a cell range

To deselect a cell range, left-click any cell in a spreadsheet.

When you move to another sheet, the range remains selected.
Was the material useful?
Yes
No
Users found this material useful: 0 из 0