Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Selecting items"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Selecting items in a sheet or spreadsheet}} {{Documentation/CG3Ch1TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Navigating within spreadsheets ...)
 
 
(4 intermediate revisions by one other user not shown)
Line 9: Line 9:
  
 
=== Single cell ===
 
=== Single cell ===
−
Left-click in the cell. The result will look like the left side of Figure 6. You can verify your selection by looking in the Name box.
+
Left-click in the cell. The result will look like the left side of [[../Navigating_within_spreadsheets#Moving from cell to cell|this figure]]. You can verify your selection by looking in the Name Box.
  
 
=== Range of contiguous cells ===
 
=== Range of contiguous cells ===
Line 18: Line 18:
 
# Click in a cell.
 
# Click in a cell.
 
# Press and hold down the left mouse button.
 
# Press and hold down the left mouse button.
−
# Move the mouse around the screen.
+
# Move the mouse pointer around the screen.
 
# Once the desired block of cells is highlighted, release the left mouse button.
 
# Once the desired block of cells is highlighted, release the left mouse button.
  
Line 24: Line 24:
  
 
# Click in the cell which is to be one corner of the range of cells.
 
# 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.
+
# Move the mouse pointer to the opposite corner of the range of cells.
 
# Hold down the ''Shift'' key and click.
 
# Hold down the ''Shift'' key and click.
  
 +
{{Tip| You can also select a contiguous range of cells by first clicking in the STD field on the status bar and changing it to EXT, before clicking in the opposite corner of the range of cells in step 3 above. If you use this method, be sure to change EXT back to STD or you may find yourself extending the selection unintentionally.}}
 
To select a range of cells without using the mouse:
 
To select a range of cells without using the mouse:
  
Line 32: Line 33:
 
# While holding down the ''Shift'' key, use the cursor arrows to select the rest of the range.
 
# While holding down the ''Shift'' key, use the cursor arrows to select the rest of the range.
  
−
The result of any of these methods looks like the right side of Figure 6.
+
The result of any of these methods looks like the right side of [../Navigating_within_spreadsheets#Moving from cell to cell|this figure].
  
−
{{Documentation/Tip| You can also directly select a range of cells using the Name box. Click into the Name box as described in “[[#Using a cell reference|Using a cell reference]]” on page [[#Using a cell reference|10]]. To select a range of cells, enter the cell reference for the upper left hand cell, followed by a colon (:), and then the lower right hand cell reference. For example, to select the range that would go from A3 to C6, you would enter ''A3:C6''.}}
+
{{Tip| You can also directly select a range of cells using the Name box. Click into the Name Box on the Formula Bar. To select a range of cells, type the cell reference for the upper left hand cell, followed by a colon (:), and then the lower right hand cell reference. For example, to select the range that would go from A3 to C6, you would type ''A3:C6''.}}
  
 
=== Range of non-contiguous cells ===
 
=== Range of non-contiguous cells ===
−
# Select the cell or range of cells using one of the methods above.
+
# Select a 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.
 
# Move the mouse pointer to the start of the next range or single cell.
−
# Hold down the ''Control'' key and click or click-and-drag to select a range.  
+
# Hold down the ''Control'' key and click or click-and-drag to select another range of cells to add to the first range..  
 
# Repeat as necessary.
 
# Repeat as necessary.
 +
 +
{{Tip|You can also select a noncontiguous range of cells by first clicking twice in the STD field on the status bar to change it to ADD, before clicking on a cell that you want to add to the range of cells in step 3 above. This method works best when adding single cells to a range. If you use this method, be sure to change EXT back to STD or you may find yourself extending the selection unintentionally.}}
  
 
== Selecting 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 Calc.
  
 
=== 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 header.
  
−
To select a single row, click on the row identifier number.
+
To select a single row, click on the row header.
  
 
=== 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:
  
−
# Click on the first column or row in the group.
+
# Click on the header for the first column or row in the group.
 
# Hold down the ''Shift'' key.
 
# Hold down the ''Shift'' key.
−
# Click the last column or row in the group.
+
# Click on the header for the last column or row in the group.
  
 
To select multiple columns or rows that are not contiguous:
 
To select multiple columns or rows that are not contiguous:
  
−
# Click on the first column or row in the group.
+
# Click on the header for the first column or row in the group.
 
# Hold down the ''Control'' key.
 
# Hold down the ''Control'' key.
−
# Click on all of the subsequent columns or rows while holding down the ''Control'' key.
+
# Click on the headers for all of the subsequent columns or rows.
  
 
=== Entire sheet ===
 
=== Entire sheet ===
−
To select the entire sheet, click on the small box between the A column header and the 1 row header.
+
To select the entire sheet, click on the small box between the column A header and the 1 row header.
  
 
[[Image:CalcSelectAll.png|thumb|none|500px|''Select All box'']]
 
[[Image:CalcSelectAll.png|thumb|none|500px|''Select All box'']]

Latest revision as of 20:51, 15 July 2018



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 this figure. 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:

  1. Click in a cell.
  2. Press and hold down the left mouse button.
  3. Move the mouse pointer around the screen.
  4. Once the desired block of cells is highlighted, release the left mouse button.

To select a range of cells without dragging the mouse:

  1. Click in the cell which is to be one corner of the range of cells.
  2. Move the mouse pointer to the opposite corner of the range of cells.
  3. Hold down the Shift key and click.
Tip.png You can also select a contiguous range of cells by first clicking in the STD field on the status bar and changing it to EXT, before clicking in the opposite corner of the range of cells in step 3 above. If you use this method, be sure to change EXT back to STD or you may find yourself extending the selection unintentionally.

To select a range of cells without using the mouse:

  1. Select the cell that will be one of the corners in the range of cells.
  2. While holding down the Shift key, use the cursor arrows to select the rest of the range.

The result of any of these methods looks like the right side of [../Navigating_within_spreadsheets#Moving from cell to cell|this figure].

Tip.png You can also directly select a range of cells using the Name box. Click into the Name Box on the Formula Bar. To select a range of cells, type the cell reference for the upper left hand cell, followed by a colon (:), and then the lower right hand cell reference. For example, to select the range that would go from A3 to C6, you would type A3:C6.


Range of non-contiguous cells

  1. Select a cell or range of cells using one of the methods above.
  2. Move the mouse pointer to the start of the next range or single cell.
  3. Hold down the Control key and click or click-and-drag to select another range of cells to add to the first range..
  4. Repeat as necessary.
Tip.png You can also select a noncontiguous range of cells by first clicking twice in the STD field on the status bar to change it to ADD, before clicking on a cell that you want to add to the range of cells in step 3 above. This method works best when adding single cells to a range. If you use this method, be sure to change EXT back to STD or you may find yourself extending the selection unintentionally.


Selecting columns and rows

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

Single column or row

To select a single column, click on the column header.

To select a single row, click on the row header.

Multiple columns or rows

To select multiple columns or rows that are contiguous:

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

To select multiple columns or rows that are not contiguous:

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

Entire sheet

To select the entire sheet, click on the small box between the column A header and the 1 row header.

Select All box

You can also use the keyboard to select the entire sheet by pressing Control+A.

Selecting sheets

You can select either one or multiple sheets. It can be advantageous to select multiple sheets at times when you want to make changes to many sheets at once.

Single sheet

Click on the sheet tab for the sheet you want to select. The active sheet becomes white.

Multiple contiguous sheets

To select multiple contiguous sheets:

  1. Click on the sheet tab for the first sheet.
  2. Move the mouse pointer over the last sheet tab.
  3. Hold down the Shift key and click on the sheet tab.

All the tabs between these two sheets will turn white. Any actions that you perform will now affect all highlighted sheets.

Multiple non contiguous sheets

To select multiple non contiguous sheets:

  1. Click on the sheet tab for the first sheet.
  2. Move the mouse pointer over the second sheet tab.
  3. Hold down the Control key and click on the sheet tab.
  4. Repeat as necessary.

The selected tabs will turn white. Any actions that you perform will now affect all highlighted sheets.

All sheets

Right-click over any one of the sheet tabs and select Select All Sheets from the popup menu.


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/OOo3_User_Guides/Calc_Guide/Selecting_items&oldid=242773"
Personal tools