Selecting Cells
From Apache OpenOffice Wiki
< Documentation | AOO4 User Guides/Getting Started | Getting Started with Calc | Selecting Items in a Sheet or Spreadsheet
- What is Calc
- Parts of the main Calc window
- Open and Save CSV files
- Navigating within spreadsheets
- Selecting items in a sheet or a spreadsheet
- Selecting Cells
- Selecting Columns and Rows
- Selecting Sheets
- Working with Columns and Rows
- Working with Sheets
- Viewing Calc
- Entering data using the keyboard
- Speeding up data entry
- Validating cell contents
- Editing data
- Formatting data
- Auto-formatting cells and sheets
- Formatting spreadsheets using themes
- Using conditional formatting
- Hiding and showing data
- Sorting records
- Using formulas and functions
- Analyzing data
- Printing from Calc
Selecting Cells
Cells can be selected in a variety of combinations and quantities.
Single cell
Left-click in the cell. The result will look like the left side of Figure 71. You can verify your selection by looking in the Name box.
Range of contiguous cells
A range of cells can be selected using the keyboard or the mouse.
To select a range of cells by dragging the mouse:
- Click in a cell.
- Press and hold down the left mouse button.
- Move the mouse around the screen.
- Once the desired block of cells is highlighted, release the left mouse button.
To select a range of cells without dragging the mouse:
- Click in the cell which is to be one corner of the range of cells.
- Move the mouse to the opposite corner of the range of cells.
- Hold down the ⇧ Shift key and click.
To select a range of cells without using the mouse:
- Select the cell that will be one of the corners in the range of cells.
- While holding down the ⇧ Shift key, use the cursor arrows to select the rest of the range.
The result of these methods looks like the right side of Figure 71.
To select all the occupied cells in one direction:
- Click the first cell in the desired range.
- Hold the Ctrl + ⇧ Shift keys and press the arrow to move in the desired direction. The cursor will jump to the last occupied cell.
Range of noncontiguous cells
- Select the cell or range of cells using one of the methods above.
- Move the mouse pointer to the start of the next range or single cell.
- Hold down the Ctrl key and click or click-and-drag to select a range.
- Repeat as necessary.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |