Selecting Cells and Ranges

Selecting a Single Cell

Selecting a single cell allows you to make changes to just that cell. You can use several methods:

• Click on the cell you want to select;
• Navigate between cells using the arrow keys on the keyboard;
• Press Tab to move right and Shift + Tab to move left.

Selecting a Range of Cells

Selecting a range of cells helps you work with multiple cells at once. You can use several methods:

• To select a range using the mouse, click and hold the left mouse button on the first cell of the range, then drag the pointer to the last cell of the range;
• To select a range using the keyboard, click on one cell, then hold Shift and click on the last cell of the range; Alternatively, hold Shift and use the arrow keys to expand the selection;
• To select multiple non-contiguous areas, hold Ctrl (Windows) or ⌘ (Mac) while selecting the desired areas.

Selecting Rows and Columns

Selecting rows and columns allows you to quickly apply changes to an entire row or column. You can use several methods:

• To select a row, click on the row number to the left of the table; To select a column, click on the column letter at the top of the table;
• To select multiple non-contiguous rows or columns, hold Ctrl (Windows) or ⌘ (Mac) and click on different rows or columns;
• To select a large group of rows or columns, click on a row or column, then hold the left mouse button and drag the pointer to the desired row or column; Alternatively, hold Shift and click on row numbers or column letters to extend the selection.

Selecting All Cells on the Sheet

Selecting all cells on the sheet allows you to work with the entire sheet’s content at once. You can do this by clicking the square button in the upper-left corner of the table where the rows and columns intersect; Alternatively, use the keyboard shortcut Ctrl + A (Windows) or ⌘ + A (Mac).

Navigating the Document

Navigating through the document helps you quickly access different parts of the sheet for viewing and editing. You can quickly navigate using keyboard shortcuts:

• Move to the last cell in a column: Press Ctrl + ↓ (Windows) or ⌘ + ↓ (Mac);
• Move to the first cell in a column: Press Ctrl + ↑ (Windows) or ⌘ + ↑ (Mac);
• Move to the last cell in a row: Press Ctrl + → (Windows) or ⌘ + → (Mac);
• Move to the first cell in a row: Press Ctrl + ← (Windows) or ⌘ + ← (Mac).