Selecting columns and rows

From Wiki
Revision as of 09:18, 30 March 2012 by Sancho (talk | contribs) (1 revision)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search


Entire columns and rows can be selected very quickly in OOo.

Single column or row

To select a single column, click on the column identifier letter (see Figure 1).

To select a single row, click on the row identifier number (see Figure 1).

Multiple columns or rows

To select multiple columns or rows that are contiguous:

  1. Click on the first column or row in the group.
  2. Hold down the Shift key.
  3. Click the last column or row in the group.

To select multiple columns or rows that are not contiguous:

  1. Click on the first column or row in the group.
  2. Hold down the Control key.
  3. Click on all of the subsequent columns or rows while holding down the Control key.

Entire sheet

To select the entire sheet, click on the small box between the A column header and the 1 row header (Figure 7). You can also use the keyboard to select the entire sheet by pressing Control+A.

File:CalcSelectAll.png
Figure 7: Select All box.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).