Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Navigating within spreadsheets"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Navigating within spreadsheets}} {{Documentation/CG3Ch1TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Starting opening saving |NextPage=Document...)
 
 
(11 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
{{Documentation/CG3Ch1TOC
 
{{Documentation/CG3Ch1TOC
 
|ShowPrevNext=block
 
|ShowPrevNext=block
−
|PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Starting opening saving
+
|PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Saving spreadsheets
 
|NextPage=Documentation/OOo3_User_Guides/Calc Guide/Selecting items
 
|NextPage=Documentation/OOo3_User_Guides/Calc Guide/Selecting items
 
}}
 
}}
 +
Calc provides many ways to navigate within a spreadsheet from cell to cell and sheet to sheet. You can generally use whatever method you prefer.
 +
 
== Going to a particular cell ==
 
== Going to a particular cell ==
 
=== Using the mouse ===
 
=== Using the mouse ===
Line 10: Line 12:
  
 
=== Using a cell reference ===
 
=== Using a cell reference ===
−
Click on the little inverted black triangle just to the right of the Name box (Figure 3). The existing cell reference will be highlighted. Type the cell reference of the cell you want to go to and press ''Enter''. Or just click into the Name box, backspace over the existing cell reference and type in the cell reference you want.
+
Click on the little inverted black triangle just to the right of the Name Box on the Formula Bar. The existing cell reference will be highlighted. Type the cell reference of the cell you want to go to and press ''Enter''. Or just click into the Name box, delete the existing cell reference, and type in the cell reference you want.
  
 
=== Using the Navigator ===
 
=== Using the Navigator ===
 
Click on the Navigator button [[Image:Nav-icon.jpg]] in the Standard toolbar (or press ''F5'') to display the Navigator. Type the cell reference into the top two fields, labeled Column and Row, and press ''Enter''. In the figure below, the Navigator would select cell G28.
 
Click on the Navigator button [[Image:Nav-icon.jpg]] in the Standard toolbar (or press ''F5'') to display the Navigator. Type the cell reference into the top two fields, labeled Column and Row, and press ''Enter''. In the figure below, the Navigator would select cell G28.
  
−
[[Image:CG3Ch1F5.png|thumb|none|500px|''Calc Navigator'']]
+
[[Image:Calc-navigator3.png|thumb|none|500px|''Calc Navigator'']]
  
 
== Moving from cell to cell ==
 
== Moving from cell to cell ==
−
In the spreadsheet, one cell, or a group of cells, normally has a darker black border. This black border indicates where the ''focus'' is (see below).
+
In the spreadsheet, one cell normally has a black border. This black border indicates where the ''focus'' is (see below). If a group of cells is selected, they have a highlight color (usually gray), with the focus cell having a dark border.
  
 
[[Image:CG3Ch1F6.png|thumb|none|500px|''(Left) One selected cell and (right) a group of selected cells'']]
 
[[Image:CG3Ch1F6.png|thumb|none|500px|''(Left) One selected cell and (right) a group of selected cells'']]
Line 28: Line 30:
 
* Pressing ''Enter'' or ''Shift+Enter'' moves the focus down or up, respectively.
 
* Pressing ''Enter'' or ''Shift+Enter'' moves the focus down or up, respectively.
 
* Pressing ''Tab'' or ''Shift+Tab'' moves the focus right or left, respectively.
 
* Pressing ''Tab'' or ''Shift+Tab'' moves the focus right or left, respectively.
−
 
−
=== Customizing the effect of the Enter key ===
 
−
You can customize the direction in which the ''Enter'' key moves the focus, by selecting '''Tools > Options > OpenOffice.org Calc > General'''.
 
−
 
−
[[Image:CG3Ch1F7.png|thumb|none|500px|''Customizing the effect of the Enter key'']]
 
−
 
−
The four choices for the direction of the ''Enter'' key are shown on the right side of the figure above. It can move data down, right, up, or left. Depending on the file being used or on the type of data being entered, different directions can be useful.
 
−
 
−
The ''Enter'' key can also be used to switch into and out of editing mode. Use the options under ''Input settings'' to change the ''Enter'' key settings.
 
  
 
=== Using the arrow keys ===
 
=== Using the arrow keys ===
Line 47: Line 40:
 
* Combinations of ''Control'' and ''Alt'' with ''Home'', ''End'', ''Page Down'', ''Page Up'', and the cursor keys move the focus of the current cell in other ways. Table 1 describes the keyboard shortcuts for moving about a spreadsheet.
 
* Combinations of ''Control'' and ''Alt'' with ''Home'', ''End'', ''Page Down'', ''Page Up'', and the cursor keys move the focus of the current cell in other ways. Table 1 describes the keyboard shortcuts for moving about a spreadsheet.
  
−
{{Documentation/Tip| Holding down ''Alt+Cursor key ''resizes a cell.}}
+
{{Tip| Holding down ''Alt+Cursor key ''resizes a cell.}}
−
 
+
  
 
''Table 1. Moving from cell to cell using the keyboard''
 
''Table 1. Moving from cell to cell using the keyboard''
−
 
−
 
 
{| class="prettytable"
 
{| class="prettytable"
 
! Key Combination
 
! Key Combination
Line 75: Line 65:
 
|-
 
|-
 
| ''Control+→''
 
| ''Control+→''
−
| To last column containing data in that row or to Column IV
+
| To last column containing data in that row or to Column AMJ
  
 
|-
 
|-
Line 87: Line 77:
 
|-
 
|-
 
| ''Control+↓''
 
| ''Control+↓''
−
| To last row containing data in that column or to Row 32000
+
| To last row containing data in that column or to Row 65536
  
 
|-
 
|-
Line 95: Line 85:
 
|-
 
|-
 
| ''Control+End''
 
| ''Control+End''
−
| To lower right hand corner of the square area containing data
+
| To lower right hand corner of the area containing data
  
 
|-
 
|-
Line 107: Line 97:
 
|-
 
|-
 
| ''Control+PgDn''
 
| ''Control+PgDn''
−
| One sheet to the right (in Sheet Tabs)
+
| One sheet to the right (in sheet tabs)
  
 
|-
 
|-
 
| ''Control+PgUp''
 
| ''Control+PgUp''
−
| One sheet to the left (in Sheet Tabs)
+
| One sheet to the left (in sheet tabs)
  
 
|-
 
|-
Line 130: Line 120:
  
 
|}
 
|}
 +
 +
=== Customizing the effect of the Enter key ===
 +
You can customize the direction in which the ''Enter'' key moves the focus, by selecting '''Tools > Options > OpenOffice.org Calc > General'''.
 +
 +
The four choices for the direction of the ''Enter'' key are shown on the right side of the figure below. It can move data down, right, up, or left. Depending on the file being used or on the type of data being entered, different directions can be useful.
 +
 +
The ''Enter'' key can also be used to switch into and out of editing mode. Use the options under ''Input settings'' to change the ''Enter'' key settings.
 +
 +
[[Image:Custom-enter-calc.png|thumb|none|600px|''Customizing the effect of the Enter key'']]
  
 
== Moving from sheet to sheet ==
 
== Moving from sheet to sheet ==
−
Each sheet in a spreadsheet is independent of the others though they can be linked with references from one sheet to another. There are three ways to navigate between different sheets in a spreadsheet.
+
Each sheet in a spreadsheet is independent of the others, though they can be linked with references from one sheet to another. There are three ways to navigate between different sheets in a spreadsheet.
  
 
=== Using the keyboard ===
 
=== Using the keyboard ===
Line 138: Line 137:
  
 
=== Using the mouse ===
 
=== Using the mouse ===
−
Clicking one of the Sheet Tabs at the bottom of the spreadsheet selects that sheet.
+
Clicking one of the sheet tabs at the bottom of the spreadsheet selects that sheet.
  
 
If you have a lot of sheets, then some of the sheet tabs may be hidden behind the horizontal scroll bar at the bottom of the screen. If this is the case, then the four buttons at the left of the sheet tabs can move the tabs into view. The figure below shows how to do this.
 
If you have a lot of sheets, then some of the sheet tabs may be hidden behind the horizontal scroll bar at the bottom of the screen. If this is the case, then the four buttons at the left of the sheet tabs can move the tabs into view. The figure below shows how to do this.
Line 146: Line 145:
 
Notice that the sheets here are not numbered in order. Sheet numbering is arbitrary—you can name a sheet as you wish.
 
Notice that the sheets here are not numbered in order. Sheet numbering is arbitrary—you can name a sheet as you wish.
  
−
{{Documentation/Note| The sheet tab arrows shown in the figure above only appear if you have some sheet tabs that can not be seen. Otherwise they will appear faded.}}
+
{{Note| The sheet tab arrows shown in the figure above only appear if you have some sheet tabs that can not be seen. Otherwise they will appear faded.}}
  
  
 
{{CCBY}}
 
{{CCBY}}
 
[[Category: Calc Guide (Documentation)]]
 
[[Category: Calc Guide (Documentation)]]

Latest revision as of 20:51, 15 July 2018



Calc provides many ways to navigate within a spreadsheet from cell to cell and sheet to sheet. You can generally use whatever method you prefer.

Going to a particular cell

Using the mouse

Place the mouse pointer over the cell and click.

Using a cell reference

Click on the little inverted black triangle just to the right of the Name Box on the Formula Bar. The existing cell reference will be highlighted. Type the cell reference of the cell you want to go to and press Enter. Or just click into the Name box, delete the existing cell reference, and type in the cell reference you want.

Using the Navigator

Click on the Navigator button Nav-icon.jpg in the Standard toolbar (or press F5) to display the Navigator. Type the cell reference into the top two fields, labeled Column and Row, and press Enter. In the figure below, the Navigator would select cell G28.

Calc Navigator

Moving from cell to cell

In the spreadsheet, one cell normally has a black border. This black border indicates where the focus is (see below). If a group of cells is selected, they have a highlight color (usually gray), with the focus cell having a dark border.

(Left) One selected cell and (right) a group of selected cells

Using the mouse

To move the focus using the mouse, simply move the mouse pointer to the cell where the focus should be and click the left mouse button. This changes the focus to the new cell. This method is most useful when the two cells are a large distance apart.

Using the Tab and Enter keys

  • Pressing Enter or Shift+Enter moves the focus down or up, respectively.
  • Pressing Tab or Shift+Tab moves the focus right or left, respectively.

Using the arrow keys

Pressing the arrow keys on the keyboard moves the focus in the direction of the arrows.

Using Home, End, Page Up and Page Down

  • Home moves the focus to the start of a row.
  • End moves the focus to the column furthest to the right that contains data.
  • Page Down moves the display down one complete screen and Page Up moves the display up one complete screen.
  • Combinations of Control and Alt with Home, End, Page Down, Page Up, and the cursor keys move the focus of the current cell in other ways. Table 1 describes the keyboard shortcuts for moving about a spreadsheet.
Tip.png Holding down Alt+Cursor key resizes a cell.


Table 1. Moving from cell to cell using the keyboard

Key Combination Movement
→ Right one cell
← Left one cell
↑ Up one cell
↓ Down one cell
Control+→ To last column containing data in that row or to Column AMJ
Control+← To first column containing data in that row or to Column A
Control+↑ To first row containing data in that column or to Row 1
Control+↓ To last row containing data in that column or to Row 65536
Control+Home To Cell A1
Control+End To lower right hand corner of the area containing data
Alt+PgDn One screen to the right (if possible)
Alt+PgUp One screen to the left (if possible)
Control+PgDn One sheet to the right (in sheet tabs)
Control+PgUp One sheet to the left (in sheet tabs)
Tab To the cell on the right
Shift+Tab To the cell on the left
Enter Down one cell (unless changed by user)
Shift+Enter Up one cell (unless changed by user)

Customizing the effect of the Enter key

You can customize the direction in which the Enter key moves the focus, by selecting Tools > Options > OpenOffice.org Calc > General.

The four choices for the direction of the Enter key are shown on the right side of the figure below. It can move data down, right, up, or left. Depending on the file being used or on the type of data being entered, different directions can be useful.

The Enter key can also be used to switch into and out of editing mode. Use the options under Input settings to change the Enter key settings.

Customizing the effect of the Enter key

Moving from sheet to sheet

Each sheet in a spreadsheet is independent of the others, though they can be linked with references from one sheet to another. There are three ways to navigate between different sheets in a spreadsheet.

Using the keyboard

Pressing Control+PgDn moves one sheet to the right and pressing Control+PgUp moves one sheet to the left.

Using the mouse

Clicking one of the sheet tabs at the bottom of the spreadsheet selects that sheet.

If you have a lot of sheets, then some of the sheet tabs may be hidden behind the horizontal scroll bar at the bottom of the screen. If this is the case, then the four buttons at the left of the sheet tabs can move the tabs into view. The figure below shows how to do this.

Sheet tab arrows

Notice that the sheets here are not numbered in order. Sheet numbering is arbitrary—you can name a sheet as you wish.

Documentation note.png The sheet tab arrows shown in the figure above only appear if you have some sheet tabs that can not be seen. Otherwise they will appear faded.


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/Navigating_within_spreadsheets&oldid=242774"
Personal tools