Difference between revisions of "Documentation/OOoAuthors User Manual/Getting Started/Selecting columns and rows"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
Line 1: Line 1:
 +
{{DISPLAYTITLE:Selecting columns and rows}}
 
{{Documentation/GSCalcTOC
 
{{Documentation/GSCalcTOC
 
|ShowPrevNext=block
 
|ShowPrevNext=block
Line 4: Line 5:
 
|NextPage=Documentation/OOoAuthors User Manual/Getting Started/Inserting columns and rows
 
|NextPage=Documentation/OOoAuthors User Manual/Getting Started/Inserting columns and rows
 
}}
 
}}
==Selecting columns and rows==
 
 
 
Entire columns and rows can be selected very quickly in OOo.
 
Entire columns and rows can be selected very quickly in OOo.
  
'''Single column or row'''
+
==Single column or row==
  
 
To select a single column, click on the column identifier letter (see Figure 1).
 
To select a single column, click on the column identifier letter (see Figure 1).
Line 14: Line 13:
 
To select a single row, click on the row identifier number (see Figure 1).
 
To select a single row, click on the row identifier number (see Figure 1).
  
'''Multiple columns or rows'''
+
==Multiple columns or rows==
  
 
To select multiple columns or rows that are contiguous:
 
To select multiple columns or rows that are contiguous:
Line 28: Line 27:
 
# Click on all of the subsequent columns or rows while holding down the ''Control'' key.
 
# Click on all of the subsequent columns or rows while holding down the ''Control'' key.
  
'''Entire sheet'''
+
==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.''
 
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.''

Latest revision as of 03:09, 13 April 2008


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.

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