source/text/scalc/04/01020000.xhp | 503 ++++++++++++++++++--------------------
1 file changed, 249 insertions(+), 254 deletions(-)
New commits:
commit 00f0e430db96a35765ce1289fa377d1dc6d1bbda
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Aug 4 20:27:49 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Aug 5 02:37:10 2025 +0200
Rearrange Calc shortcut keys tables
The current shortcut keys table are a keyboard shopping list with poor
readability and effectiveness.
The patch presents the actions in the first column and the shortcuts in
second column.
Furthermore, the tables are divided by operation categories making easy to
locate the actions.
Change-Id: I6f81e421cec9111212b0e9d2422b1f9c0158219b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/188929
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/scalc/04/01020000.xhp
b/source/text/scalc/04/01020000.xhp
index d55dbca74e..08392256b6 100644
--- a/source/text/scalc/04/01020000.xhp
+++ b/source/text/scalc/04/01020000.xhp
@@ -48,810 +48,805 @@
<paragraph role="paragraph" id="par_id3146978">To delete the contents of
selected cells, press <keycode>Backspace</keycode>. This opens the <link
href="text/scalc/01/02150000.xhp">Delete Contents</link> dialog, where you
choose which contents of the cell you want to delete. To delete the contents of
selected cells without a dialog, press the <keycode>Delete</keycode>
key.</paragraph>
<h2 id="hd_id541750170879864">To cut contents without removing the source
cells format</h2>
<paragraph role="paragraph" id="par_id431750170896895">To cut contents
without removing the source cells format, press <switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ Shift + X</keycode>.</paragraph>
- <h2 id="hd_id3145386">Navigating in Spreadsheets</h2>
+ <h2 id="hd_id151754343610991">Moving Cursor</h2>
<table id="tbl_id5963927">
<tablerow>
<tablecell>
- <paragraph role="tablehead" id="hd_id3149407">Shortcut
Keys</paragraph>
+ <paragraph role="tablehead" id="par_id3153845"><variable
id="effect"><emph>Effect</emph></variable></paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablehead"
id="par_id3153815"><emph>Effect</emph></paragraph>
+ <paragraph role="tablehead" id="hd_id3149407"><variable
id="key"><emph>Shortcut Keys</emph></variable></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3146871"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Home</paragraph>
+ <paragraph role="tablecontent" id="par_id3159093">Moves the cursor
to the first cell in the sheet (A1).</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3159093">Moves the cursor
to the first cell in the sheet (A1).</paragraph>
+ <paragraph role="tablecontent" id="hd_id3146871"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Home</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3145073"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+End</paragraph>
+ <paragraph role="tablecontent" id="par_id3153283">Moves the cursor
to the last cell on the sheet that contains data.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153283">Moves the cursor
to the last cell on the sheet that contains data.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3145073"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+End</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149127">Home</paragraph>
+ <paragraph role="tablecontent" id="par_id3159205">Moves the cursor
to the first cell of the current row.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3159205">Moves the cursor
to the first cell of the current row.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149127">Home</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149897">End</paragraph>
+ <paragraph role="tablecontent" id="par_id3155095">Moves the cursor
to the last column that contains data in any row.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3155095">Moves the cursor
to the last column that contains data in any row.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149897">End</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent"
id="hd_id4149127">Shift+Home</paragraph>
+ <paragraph role="tablecontent" id="par_id3154766">Moves the cursor
leftward to the start and end of cell blocks with data. If the cell to the left
of the cursor is empty or the cell with the cursor is empty, the cursor moves
leftward in the current row until it reaches the next cell with contents. If
all cells in the same row to the left of the cursor are empty, the cursor moves
to the first cell in the row.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id4159205">Selects cells from
the current cell to the first cell of the current row.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3143220"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left
Arrow</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent"
id="hd_id4149897">Shift+End</paragraph>
+ <paragraph role="tablecontent" id="par_id3155593">Moves the cursor
rightward to the start and end of cell blocks with data. If the cell to the
right of the cursor is empty or the cell with the cursor is empty, the cursor
moves rightward in the current row until it reaches the next cell with
contents. If all cells in the same row to the right of the cursor are empty,
the cursor moves to the last cell in the row.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id4155095">Selects all cells
from the current cell to the last column that contains data in any
row.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3153554"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Right
Arrow</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id5149127">Shift+Page
Up</paragraph>
+ <paragraph role="tablecontent" id="par_id3153076">Moves the cursor
upward to the start and end of cell blocks with data. If the cell above the
cursor is empty or the cell with the cursor is empty, the cursor moves upward
in the current column until it reaches the next cell with contents. If all
cells in the same column above the cursor are empty, the cursor moves to the
first cell in the column.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id5159205">Selects cells from
the current cell up to one page in the current column or extends the existing
selection one page up.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149317"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Up
Arrow</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id5149897">Shift+Page
Down</paragraph>
+ <paragraph role="tablecontent" id="par_id3149054">Moves the cursor
downward to the start and end of cell blocks with data. If the cell below the
cursor is empty or the cell with the cursor is empty, the cursor moves downward
in the current column until it reaches the next cell with contents. If all
cells in the same column below the cursor are empty, the cursor moves to the
last cell in the column.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id5155095">Selects cells from
the current cell down to one page in the current column or extends the existing
selection one page down.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3147250"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Down
Arrow</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent"
id="hd_id451550311052582">Shift+Space</paragraph>
+ <paragraph role="tablecontent" id="par_id3145236">Moves one sheet to
the left.</paragraph>
+ <paragraph role="tablecontent" id="par_id3149725">In the print
preview: Moves to the previous print page.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id971550311052582">Selects
the current row or extends the existing selection to all respective
rows.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3156399"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page
Up</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent"
id="hd_id281550311052582"><switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Space</paragraph>
+ <paragraph role="tablecontent" id="par_id3150372">Moves one sheet to
the right.</paragraph>
+ <paragraph role="tablecontent" id="par_id3159120">In the print
preview: Moves to the next print page.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id261550311052582">Selects
the current column or extends the existing selection to all respective
columns.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3147411"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page
Down</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent"
id="hd_id311550311052582"><switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Space</paragraph>
+ <paragraph role="tablecontent" id="par_id3152976">Moves one screen
to the left.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id851550311052582">Selects
all cells in the sheet.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3146885"><switchinline
select="sys"><caseinline select="MAC">Option
+</caseinline><defaultinline>Alt</defaultinline></switchinline>+Page
Up</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3143220"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left
Arrow</paragraph>
+ <paragraph role="tablecontent" id="par_id3150477">Moves one screen
page to the right.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3154766">Moves the cursor
leftward to the start and end of cell blocks with data. If the cell to the left
of the cursor is empty or the cell with the cursor is empty, the cursor moves
leftward in the current row until it reaches the next cell with contents. If
all cells in the same row to the left of the cursor are empty, the cursor moves
to the first cell in the row.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149013"><switchinline
select="sys"><caseinline select="MAC">Option
+</caseinline><defaultinline>Alt</defaultinline></switchinline>+Page
Down</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3153554"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Right
Arrow</paragraph>
+ <paragraph role="tablecontent" id="par_id3155929">Moves the cursor
to the <emph>Input line</emph> where you can enter a formula for the current
cell.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3155593">Moves the cursor
rightward to the start and end of cell blocks with data. If the cell to the
right of the cursor is empty or the cell with the cursor is empty, the cursor
moves rightward in the current row until it reaches the next cell with
contents. If all cells in the same row to the right of the cursor are empty,
the cursor moves to the last cell in the row.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3147366">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149317"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Up
Arrow</paragraph>
+ <paragraph role="tablecontent" id="par_id3153551">Moves the cursor
from the <emph>Input line</emph> to the <menuitem>Name Box</menuitem>. You can
also use Shift+<switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+T.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153076">Moves the cursor
upward to the start and end of cell blocks with data. If the cell above the
cursor is empty or the cell with the cursor is empty, the cursor moves upward
in the current column until it reaches the next cell with contents. If all
cells in the same column above the cursor are empty, the cursor moves to the
first cell in the column.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3150568">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F5</paragraph>
</tablecell>
</tablerow>
+ </table>
+ <h2 id="hd_id381754343663084">Selection</h2>
+ <table id="tbl_id5963928">
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3147250"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Down
Arrow</paragraph>
+ <paragraph role="tablehead" id="par_id3153815" localize="false"
><embedvar href="text/scalc/04/01020000.xhp#effect" markup="keep"/></paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3149054">Moves the cursor
downward to the start and end of cell blocks with data. If the cell below the
cursor is empty or the cell with the cursor is empty, the cursor moves downward
in the current column until it reaches the next cell with contents. If all
cells in the same column below the cursor are empty, the cursor moves to the
last cell in the column.</paragraph>
+ <paragraph role="tablehead" id="hd_id3139407" localize="false"
><embedvar href="text/scalc/04/01020000.xhp#key" markup="keep"/></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3148744"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Arrow</paragraph>
+ <paragraph role="tablecontent" id="par_id4159205">Selects cells from
the current cell to the first cell of the current row.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3159258">Selects all cells
of the range created by the cursor movements using the <switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Arrows</keycode>
key combinations. If used to select rows and columns together, a rectangular
cell range is selected. If the cursor is in an empty cell, the selection will
stretch from the current cell up to the first cell with value in the direction
of the arrow pressed.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id4149127">Shift+Home</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3156399"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page
Up</paragraph>
+ <paragraph role="tablecontent" id="par_id4155095">Selects all cells
from the current cell to the last column that contains data in any
row.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3145236">Moves one sheet to
the left.</paragraph>
- <paragraph role="tablecontent" id="par_id3149725">In the print
preview: Moves to the previous print page.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id4149897">Shift+End</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3147411"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page
Down</paragraph>
+ <paragraph role="tablecontent" id="par_id5159205">Selects cells from
the current cell up to one page in the current column or extends the existing
selection one page up.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3150372">Moves one sheet to
the right.</paragraph>
- <paragraph role="tablecontent" id="par_id3159120">In the print
preview: Moves to the next print page.</paragraph>
+ <paragraph role="tablecontent" id="hd_id5149127">Shift+Page
Up</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3146885"><switchinline
select="sys"><caseinline select="MAC">Option
-</caseinline><defaultinline>Alt</defaultinline></switchinline>+Page
Up</paragraph>
+ <paragraph role="tablecontent" id="par_id5155095">Selects cells from
the current cell down to one page in the current column or extends the existing
selection one page down.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3152976">Moves one screen
to the left.</paragraph>
+ <paragraph role="tablecontent" id="hd_id5149897">Shift+Page
Down</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149013"><switchinline
select="sys"><caseinline select="MAC">Option
-</caseinline><defaultinline>Alt</defaultinline></switchinline>+Page
Down</paragraph>
+ <paragraph role="tablecontent" id="par_id971550311052582">Selects
the current row or extends the existing selection to all respective
rows.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3150477">Moves one screen
page to the right.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id451550311052582">Shift+Space</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="par_idN10AFC">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page
Up</paragraph>
+ <paragraph role="tablecontent" id="par_id261550311052582">Selects
the current column or extends the existing selection to all respective
columns.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_idN10B00">Adds the previous
sheet to the current selection of sheets. If all the sheets in a spreadsheet
are selected, this shortcut key combination only selects the previous sheet.
Makes the previous sheet the current sheet.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id281550311052582"><switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Space</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="par_idN10B03">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page
Down</paragraph>
+ <paragraph role="tablecontent" id="par_id851550311052582">Selects
all cells in the sheet.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_idN10B07">Adds the next sheet
to the current selection of sheets. If all the sheets in a spreadsheet are
selected, this shortcut key combination only selects the next sheet. Makes the
next sheet the current sheet.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id311550311052582"><switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Space</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3145826"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+
*</paragraph>
+ <paragraph role="tablecontent" id="par_id3159258">Selects all cells
of the range created by the cursor movements using the <switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Arrows</keycode>
key combinations. If used to select rows and columns together, a rectangular
cell range is selected. If the cursor is in an empty cell, the selection will
stretch from the current cell up to the first cell with value in the direction
of the arrow pressed.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3148882">where (*) is the
multiplication sign on the numeric key pad</paragraph>
- <paragraph role="tablecontent" id="par_id3154847">Selects the data
range that contains the cursor. A range is a contiguous cell range that
contains data and is bounded by empty row and columns.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3148744"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Arrow</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3151233"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+
/</paragraph>
+ <paragraph role="tablecontent" id="par_id3154847">Selects the data
block that contains the cursor. A block is a contiguous cell range that
contains data and is bounded by empty row and columns.</paragraph>
+ <paragraph role="tablecontent" id="par_id3148882">Where (*) is the
multiplication sign on the numeric key pad</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3149949">where (/) is the
division sign on the numeric key pad</paragraph>
- <paragraph role="tablecontent" id="par_id3150144">Selects the matrix
formula range that contains the cursor.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3145826"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+
*</paragraph>
+ <paragraph role="tablecontent"
id="par_id891754345222474"><switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+
A</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="par_id8163396"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Plus
key</paragraph>
+ <paragraph role="tablecontent" id="par_id3150144">Selects the matrix
formula range that contains the cursor.</paragraph>
+ <paragraph role="tablecontent" id="par_id3149949">Where (/) is the
division sign on the numeric key pad</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id9901425">Insert cells (as
in menu Insert - Cells)<comment>[sc-features] of 8.June07</comment></paragraph>
+ <paragraph role="tablecontent" id="hd_id3151233"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+
/</paragraph>
</tablecell>
</tablerow>
+
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="par_id3389080"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Minus
key</paragraph>
+ <paragraph role="tablecontent" id="par_id5104220">Delete cells (as
in menu Edit - Delete Cells)</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id5104220">Delete cells (as
in menu Edit - Delete Cells)</paragraph>
+ <paragraph role="tablecontent" id="par_id3389080"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Minus
key</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3155825">Enter (in a
selected range)<comment>see i80051</comment></paragraph>
+ <paragraph role="tablecontent" id="par_id3153935">Moves the cursor
down one cell in a selected range. To specify the direction that the cursor
moves, choose <switchinline select="sys"><caseinline
select="MAC"><emph>%PRODUCTNAME -
Preferences</emph></caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc -
General</emph> and change the option in <emph>Press Enter to move
selection</emph>.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153935">Moves the cursor
down one cell in a selected range. To specify the direction that the cursor
moves, choose <switchinline select="sys"><caseinline
select="MAC"><emph>%PRODUCTNAME -
Preferences</emph></caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc -
General</emph> and change the option in <emph>Press Enter to move
selection</emph>.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3155825">Enter (in a
selected range)<comment>see i80051</comment></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id351630625364216" role="tablecontent">Enter
(after copying cell contents)</paragraph>
+ <paragraph id="par_id681630625395135" role="tablecontent">If cell
contents have just been copied to the clipboard and no additional editing has
been done in the current file, then pressing <keycode>Enter</keycode> will
paste clipboard contents to the current cursor position.</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id681630625395135" role="tablecontent">If cell
contents have just been copied to the clipboard and no additional editing has
been done in the current file, then pressing <keycode>Enter</keycode> will
paste clipboard contents to the current cursor position.</paragraph>
+ <paragraph id="par_id351630625364216" role="tablecontent">Enter
(after copying cell contents)</paragraph>
</tablecell>
</tablerow>
<tablerow>
- <tablecell>
- <paragraph id="par_id521630625780621"
role="tablecontent">Shift+Enter</paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id541630625783264" role="tablecontent">If the
clipboard contains cell contents and no editing has been done in the file, then
<keycode>Shift+Enter</keycode> has the same behavior as
<keycode>Enter</keycode> and pastes clipboard contents to the current cursor
position.</paragraph>
<paragraph role="tablecontent" id="par_id921630625968749">If no
cells are selected, <keycode>Shift+Enter</keycode> moves the cursor to the
opposite direction defined in the option <emph>Press Enter to move
selection</emph> found in <switchinline select="sys"><caseinline
select="MAC"><emph>%PRODUCTNAME -
Preferences</emph></caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc -
General</emph>.</paragraph>
<paragraph role="paragraph" id="par_id951630626229215">If a range
of cells is selected, <keycode>Shift+Enter</keycode> moves the cursor inside
the current selection to the opposite direction defined in the option
<emph>Press Enter to move selection</emph>.</paragraph>
</tablecell>
+ <tablecell>
+ <paragraph id="par_id521630625780621"
role="tablecontent">Shift+Enter</paragraph>
+ </tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="par_id5961180"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+
` (see note below this table)</paragraph>
+ <paragraph role="tablecontent" id="par_id3147482">Turns additional
selection mode on or off. In this mode, you can use the arrow keys to extend
the selection. You can also click in another cell to extend the
selection.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id6407055">Displays or hides
the formulas instead of the values in all
cells.<comment>i56202</comment></paragraph>
+ <paragraph role="tablecontent" id="hd_id3156257">F8</paragraph>
</tablecell>
</tablerow>
</table>
- <note id="par_id8070314">The ` key is located next to the "1" key on most
English keyboards. If your keyboard does not show this key, you can assign
another key: Choose <emph>Tools - Customize</emph>, click the
<emph>Keyboard</emph> tab. Select the "View" category and the "Show Formulas"
function.</note>
- <bookmark branch="index" id="bm_id3143661">
- <bookmark_value>spreadsheets; duplicate</bookmark_value>
- <bookmark_value>spreadsheets; quick rename</bookmark_value>
- </bookmark>
- <h2 id="hd_id271637246984980">Copying and Renaming Sheets</h2>
- <paragraph role="paragraph" id="par_id781637247029711">The sheet tabs used
to navigate between sheets can be clicked in combination with keyboard keys to
perform the following operations:</paragraph>
- <table id="tab_id91637247123788">
+ <h2 id="hd_id641754347512449">Open, display or hide</h2>
+ <table id="tab_id91667247133788">
<tablerow>
<tablecell>
- <paragraph id="par_id741637247123788" role="tablehead">Shortcut
Keys</paragraph>
+ <paragraph role="tablehead" id="par_id601754347472085"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#effect"
markup="keep"/></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id731637247123788"
role="tablehead">Effect</paragraph>
+ <paragraph role="tablehead" id="par_id751754347474765"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#key"
markup="keep"/></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id211637247123788"
role="tablecontent"><switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
+ Drag sheet tab</paragraph>
+ <paragraph role="tablecontent" id="par_id3145140">Displays the
comment that is attached to the current cell</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id981637247123788" role="tablecontent">Creates a
copy of the sheet whose tab was clicked. The copied sheet is placed at the
position where the mouse button was released.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3154809"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id211637247123024"
role="tablecontent"><switchinline select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>
+ Click sheet tab</paragraph>
+ <paragraph role="tablecontent" id="par_id3145245">Opens the
<emph>Define Names</emph> dialog.</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id981637247123114" role="tablecontent">Makes the
sheet name editable. Edit the sheet name and press <keycode>Enter</keycode>
when finished.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3153730"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph>
</tablecell>
</tablerow>
- </table>
-
- <h2 id="hd_id3148756">Function Keys Used in Spreadsheets</h2>
- <table id="tbl_id5384685">
<tablerow>
<tablecell>
- <paragraph role="tablehead" id="hd_id3148581">Shortcut
Keys</paragraph>
+ <paragraph role="tablecontent" id="par_id3145162">Opens the Function
Wizard.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablehead" id="par_id3152790">
- <emph>Effect</emph>
- </paragraph>
+ <paragraph role="tablecontent" id="hd_id3146850"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3154809"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F1</paragraph>
+ <paragraph role="tablecontent" id="par_id3153047">Shows or Hides the
Database explorer.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3145140">Displays the
comment that is attached to the current cell</paragraph>
+ <paragraph role="tablecontent" id="hd_id3148768">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F4</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3146142">F2</paragraph>
+ <paragraph role="tablecontent" id="par_id3149540">Shows or hides the
<emph>Navigator</emph>.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3148568">With a cell
selected, press F2 to open cell contents for editing. If the cell contains a
formula, use arrow keys to navigate the sheet to easily enter range addresses
into the formula.</paragraph>
- <paragraph role="paragraph" id="par_id381629750112725">Press F2
again to enable the use of arrow keys to move the cursor in the formula
text.</paragraph>
- <paragraph role="paragraph" id="par_id481629750230372">Each
additional use of the F2 shortcut switches between the two states previously
described.</paragraph>
- <paragraph role="paragraph" id="par_id461629750358215">Some dialog
boxes have input fields with a <emph>Shrink</emph> button. Pressing F2 with the
cursor inside such field causes the <emph>Shrink</emph> command to be
executed.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3156063">F5</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3146850"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph>
+ <paragraph role="tablecontent" id="par_id3150268">Traces
dependents.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3145162">Opens the Function
Wizard.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3148392">Shift+F5</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3147366">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph>
+ <paragraph role="tablecontent" id="par_id3153179">Traces
precedents.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3155929">Moves the cursor
to the <emph>Input line</emph> where you can enter a formula for the current
cell.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3148430">Shift+F9</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3153730"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph>
+ <paragraph role="tablecontent" id="par_id3153155">Increases the
height of current row (only in <link
href="text/shared/optionen/01060800.xhp">OpenOffice.org legacy compatibility
mode</link>).</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3145245">Opens the
<emph>Define Names</emph> dialog.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3151264"><switchinline
select="sys"><caseinline select="MAC">Option
+</caseinline><defaultinline>Alt</defaultinline></switchinline>+Down
Arrow</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3148768">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F4</paragraph>
+ <paragraph role="tablecontent" id="par_id3155849">Decreases the
height of current row (only in <link
href="text/shared/optionen/01060800.xhp">OpenOffice.org legacy compatibility
mode</link>).</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153047">Shows or Hides the
Database explorer.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3151297"><switchinline
select="sys"><caseinline select="MAC">Option
+</caseinline><defaultinline>Alt</defaultinline></switchinline>+Up
Arrow</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3145353">F4</paragraph>
+ <paragraph role="tablecontent" id="par_id3150256">Increases the
width of the current column.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3155620">Rearranges the
relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input
field.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3155997"><switchinline
select="sys"><caseinline select="MAC">Option
+</caseinline><defaultinline>Alt</defaultinline></switchinline>+Right
Arrow</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3156063">F5</paragraph>
+ <paragraph role="tablecontent" id="par_id3150155">Decreases the
width of the current column.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3149540">Shows or hides the
<emph>Navigator</emph>.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3154046"><switchinline
select="sys"><caseinline select="MAC">Option
+</caseinline><defaultinline>Alt</defaultinline></switchinline>+Left
Arrow</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3148392">Shift+F5</paragraph>
+ <paragraph role="tablecontent" id="par_id3159180">Optimizes the
column width or row height based on the current cell.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3150268">Traces
dependents.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149293"><switchinline
select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Shift+Arrow
Key</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3148430">Shift+F9</paragraph>
+ <paragraph role="tablecontent" id="par_id3150967">Opens the
<emph>Styles</emph> window where you can apply a formatting style to the
contents of the cell or to the current sheet.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153179">Traces
precedents.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149279"><switchinline
select="sys"><caseinline
select="MAC">Command+T</caseinline><defaultinline>F11</defaultinline></switchinline></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3150568">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F5</paragraph>
+ <paragraph role="tablecontent" id="par_id6407055">Displays or hides
the formulas instead of the values in all
cells.<comment>i56202</comment></paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153551">Moves the cursor
from the <emph>Input line</emph> to the <menuitem>Name Box</menuitem>. You can
also use Shift+<switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+T.</paragraph>
+ <paragraph role="tablecontent" id="par_id5961180"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+
` (see note below this table)</paragraph>
</tablecell>
</tablerow>
+ </table>
+ <note id="par_id8070314">The ` key is located next to the "1" key on most
English keyboards. If your keyboard does not show this key, you can assign
another key: Choose <emph>Tools - Customize</emph>, click the
<emph>Keyboard</emph> tab. Select the "View" category and the "Show Formulas"
function.</note>
+ <h2 id="hd_id501754346216850">Addition and Insertion</h2>
+ <table id="tab_id91667247123788">
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3155368">F7</paragraph>
+ <paragraph role="tablehead" id="par_id351754346187626"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#effect"
markup="keep"/></paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3154871">Checks spelling in
the current sheet.</paragraph>
+ <paragraph role="tablehead" id="par_id221754346191163"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#key"
markup="keep"/></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3150688"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F7</paragraph>
+ <paragraph role="tablecontent" id="par_idN10B00">Adds the previous
sheet to the current selection of sheets. If all the sheets in a spreadsheet
are selected, this shortcut key combination only selects the previous sheet.
Makes the previous sheet the current sheet.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3149781">Opens the
Thesaurus if the current cell contains text.</paragraph>
+ <paragraph role="tablecontent" id="par_idN10AFC">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page
Up</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3156257">F8</paragraph>
+ <paragraph role="tablecontent" id="par_idN10B07">Adds the next sheet
to the current selection of sheets. If all the sheets in a spreadsheet are
selected, this shortcut key combination only selects the next sheet. Makes the
next sheet the current sheet.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3147482">Turns additional
selection mode on or off. In this mode, you can use the arrow keys to extend
the selection. You can also click in another cell to extend the
selection.</paragraph>
+ <paragraph role="tablecontent" id="par_idN10B03">Shift+<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page
Down</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3154313"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F8</paragraph>
+ <paragraph role="tablecontent" id="par_id9901425">Insert cells (as
in menu Insert - Cells)<comment>[sc-features] of 8.June07</comment></paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3150385">Highlights cells
containing values.</paragraph>
+ <paragraph role="tablecontent" id="par_id8163396"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Plus
key</paragraph>
</tablecell>
</tablerow>
+ </table>
+ <bookmark branch="index" id="bm_id3143661">
+ <bookmark_value>spreadsheets; duplicate</bookmark_value>
+ <bookmark_value>spreadsheets; quick rename</bookmark_value>
+ </bookmark>
+ <h2 id="hd_id271637246984980">Copying and Renaming Sheets</h2>
+ <paragraph role="paragraph" id="par_id781637247029711">The sheet tabs used
to navigate between sheets can be clicked in combination with keyboard keys to
perform the following operations:</paragraph>
+ <table id="tab_id91637247123788">
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3152479">F9</paragraph>
+ <paragraph role="tablehead" id="par_id511754345873098"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#effect"
markup="keep"/></paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3163827">Recalculates
changed formulas in the current sheet.</paragraph>
+ <paragraph role="tablehead" id="par_id231754345875658"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#key"
markup="keep"/></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="par_id9027069"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+F9</paragraph>
+ <paragraph id="par_id981637247123788" role="tablecontent">Creates a
copy of the sheet whose tab was clicked. The copied sheet is placed at the
position where the mouse button was released.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id1729178">Recalculates all
formulas in all sheets.</paragraph>
+ <paragraph id="par_id211637247123788"
role="tablecontent"><switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
+ Drag sheet tab</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3156300"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9</paragraph>
+ <paragraph id="par_id981637247123114" role="tablecontent">Makes the
sheet name editable. Edit the sheet name and press <keycode>Enter</keycode>
when finished.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3154817">Updates the
selected chart.</paragraph>
+ <paragraph id="par_id211637247123024"
role="tablecontent"><switchinline select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>
+ Click sheet tab</paragraph>
</tablecell>
</tablerow>
+ </table>
+ <h2 id="hd_id3148756">Other Keys Used in Spreadsheets</h2>
+ <table id="tbl_id5384685">
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149279">
- <switchinline select="sys">
- <caseinline select="MAC">Command+T</caseinline>
- <defaultinline>F11</defaultinline>
- </switchinline>
- </paragraph>
+ <paragraph role="tablehead" id="par_id1001754345888553"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#effect"
markup="keep"/></paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3150967">Opens the
<emph>Styles</emph> window where you can apply a formatting style to the
contents of the cell or to the current sheet.</paragraph>
+ <paragraph role="tablehead" id="par_id551754345891657"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#key"
markup="keep"/></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent"
id="hd_id3156308">Shift+F11</paragraph>
+ <paragraph role="tablecontent" id="par_id3148568">With a cell
selected, press F2 to open cell contents for editing. If the cell contains a
formula, use arrow keys to navigate the sheet to easily enter range addresses
into the formula.</paragraph>
+ <paragraph role="paragraph" id="par_id381629750112725">Press F2
again to enable the use of arrow keys to move the cursor in the formula
text.</paragraph>
+ <paragraph role="paragraph" id="par_id481629750230372">Each
additional use of the F2 shortcut switches between the two states previously
described.</paragraph>
+ <paragraph role="paragraph" id="par_id461629750358215">Some dialog
boxes have input fields with a <emph>Shrink</emph> button. Pressing F2 with the
cursor inside such field causes the <emph>Shrink</emph> command to be
executed.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3145209">Creates a document
template.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3146142">F2</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3147622">Shift<switchinline
select="sys"><caseinline
select="MAC">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+F11</paragraph>
+ <paragraph role="tablecontent" id="par_id3155620">Rearranges the
relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input
field.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153215">Updates the
templates.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3145353">F4</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3150760">F12</paragraph>
+ <paragraph role="tablecontent" id="par_id3154871">Checks spelling in
the current sheet.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3156321">Groups the
selected data range.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3155368">F7</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3146859"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph>
+ <paragraph role="tablecontent" id="par_id3149781">Opens the
Thesaurus if the current cell contains text.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3156128">Ungroups the
selected data range.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3150688"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F7</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3151264"><switchinline
select="sys"><caseinline select="MAC">Option
-</caseinline><defaultinline>Alt</defaultinline></switchinline>+Down
Arrow</paragraph>
+ <paragraph role="tablecontent" id="par_id3150385">Highlights cells
containing values.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153155">Increases the
height of current row (only in <link
href="text/shared/optionen/01060800.xhp">OpenOffice.org legacy compatibility
mode</link>).</paragraph>
+ <paragraph role="tablecontent" id="hd_id3154313"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F8</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3151297"><switchinline
select="sys"><caseinline select="MAC">Option
-</caseinline><defaultinline>Alt</defaultinline></switchinline>+Up
Arrow</paragraph>
+ <paragraph role="tablecontent" id="par_id3163827">Recalculates
changed formulas in the current sheet.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3155849">Decreases the
height of current row (only in <link
href="text/shared/optionen/01060800.xhp">OpenOffice.org legacy compatibility
mode</link>).</paragraph>
+ <paragraph role="tablecontent" id="hd_id3152479">F9</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3155997"><switchinline
select="sys"><caseinline select="MAC">Option
-</caseinline><defaultinline>Alt</defaultinline></switchinline>+Right
Arrow</paragraph>
+ <paragraph role="tablecontent" id="par_id1729178">Recalculates all
formulas in all sheets.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3150256">Increases the
width of the current column.</paragraph>
+ <paragraph role="tablecontent" id="par_id9027069"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+F9</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3154046"><switchinline
select="sys"><caseinline select="MAC">Option
-</caseinline><defaultinline>Alt</defaultinline></switchinline>+Left
Arrow</paragraph>
+ <paragraph role="tablecontent" id="par_id3154817">Updates the
selected chart.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3150155">Decreases the
width of the current column.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3156300"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149293"><switchinline
select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Shift+Arrow
Key</paragraph>
+ <paragraph role="tablecontent" id="par_id3145209">Creates a document
template.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3159180">Optimizes the
column width or row height based on the current cell.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id3156308">Shift+F11</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="tablecontent" id="par_id3153215">Updates the
templates.</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="tablecontent" id="hd_id3147622">Shift<switchinline
select="sys"><caseinline
select="MAC">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+F11</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="tablecontent" id="par_id3156321">Groups the
selected data range.</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="tablecontent" id="hd_id3150760">F12</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="tablecontent" id="par_id3156128">Ungroups the
selected data range.</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="tablecontent" id="hd_id3146859"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph>
</tablecell>
</tablerow>
</table>
- <h2 id="hd_id3156013">Formatting Cells Using Shortcut Keys</h2>
+ <h2 id="hd_id3156013">Number Formatting Using Shortcut Keys</h2>
<paragraph role="paragraph" id="par_id3153979">The following cell formats
can be applied with the keyboard:</paragraph>
<table id="tbl_id6533097">
<tablerow>
<tablecell>
- <paragraph role="tablehead" id="hd_id3147492">Shortcut
Keys</paragraph>
+ <paragraph role="tablehead" id="par_id601754347472085"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#effect"
markup="keep"/></paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablehead" id="par_id3154305">
- <emph>Effect</emph>
- </paragraph>
+ <paragraph role="tablehead" id="hd_id3147492">Shortcut Keys (not on
the number pad)</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3145669"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+1
(not on the number pad)</paragraph>
+ <paragraph role="tablecontent" id="par_id3149197">Open Format Cells
dialog</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3149197">Open Format Cells
dialog</paragraph>
+ <paragraph role="tablecontent" id="hd_id3145669"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3145668"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+1
(not on the number pad)</paragraph>
+ <paragraph role="tablecontent" id="par_id3149196">Two decimal
places, thousands separator</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3149196">Two decimal
places, thousands separator</paragraph>
+ <paragraph role="tablecontent" id="hd_id3145668"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3155331"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+2
(not on the number pad)</paragraph>
+ <paragraph role="tablecontent" id="par_id3150120">Standard
exponential format</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3150120">Standard
exponential format</paragraph>
+ <paragraph role="tablecontent" id="hd_id3155331"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+2</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3154932"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+3
(not on the number pad)</paragraph>
+ <paragraph role="tablecontent" id="par_id3148822">Standard date
format</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3148822">Standard date
format</paragraph>
+ <paragraph role="tablecontent" id="hd_id3154932"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+3</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3148829"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+4
(not on the number pad)</paragraph>
+ <paragraph role="tablecontent" id="par_id3159152">Standard currency
format</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3159152">Standard currency
format</paragraph>
+ <paragraph role="tablecontent" id="hd_id3148829"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+4</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3150776"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+5
(not on the number pad)</paragraph>
+ <paragraph role="tablecontent" id="par_id3148800">Standard
percentage format (two decimal places)</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3148800">Standard
percentage format (two decimal places)</paragraph>
+ <paragraph role="tablecontent" id="hd_id3150776"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+5</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3158407"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+6
(not on the number pad)</paragraph>
+ <paragraph role="tablecontent" id="par_id3148444">Standard
format</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3148444">Standard
format</paragraph>
+ <paragraph role="tablecontent" id="hd_id3158407"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+6</paragraph>
</tablecell>
</tablerow>
</table>
<h2 id="hd_id3154205">Using the pivot table</h2>
<paragraph role="paragraph" id="par_id631581375238556">The shortcut keys
below are for the <emph>Pivot Table Layout</emph> dialog.</paragraph>
<table id="tbl_id2419507">
+ <tablerow>
+ <tablecell>
+ <paragraph role="tablehead" id="par_id961754345923929"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#effect"
markup="keep"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="tablehead" id="par_id841754345926761"
localize="false" ><embedvar href="text/scalc/04/01020000.xhp#key"
markup="keep"/></paragraph>
+ </tablecell>
+ </tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablehead" id="par_idN11326">Keys</paragraph>
+ <paragraph role="tablecontent" id="par_id3147511">Changes the
focus by moving forwards through the areas and buttons of the
dialog.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablehead" id="par_idN1132C">Effect</paragraph>
+ <paragraph role="tablecontent"
id="hd_id3153577"><keycode>Tab</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3153577">
- <keycode>Tab</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3155362">Changes the
focus by moving backwards through the areas and buttons of the
dialog.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3147511">Changes the
focus by moving forwards through the areas and buttons of the
dialog.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id3154266"><keycode>Shift+Tab</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3154266">
- <keycode>Shift+Tab</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3149152">Moves the focus
up one item in the current dialog area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3155362">Changes the
focus by moving backwards through the areas and buttons of the
dialog.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3148484"><keycode>Up
Arrow</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3148484">
- <keycode>Up Arrow</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3158424">Moves the focus
down one item in the current dialog area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3149152">Moves the focus
up one item in the current dialog area.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3154273"><keycode>Down
Arrow</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3154273">
- <keycode>Down Arrow</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3153238">Moves the focus
one item to the left in the current dialog area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3158424">Moves the focus
down one item in the current dialog area.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3148912"><keycode>Left
Arrow</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3148912">
- <keycode>Left Arrow</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3166458">Moves the focus
one item to the right in the current dialog area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153238">Moves the focus
one item to the left in the current dialog area.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3150712"><keycode>Right
Arrow</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3150712">
- <keycode>Right Arrow</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3153742">Selects the
first item in the current dialog area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3166458">Moves the focus
one item to the right in the current dialog area.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id3146947"><keycode>Home</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3146947">
- <keycode>Home</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3153684">Selects the last
item in the current dialog area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153742">Selects the
first item in the current dialog area.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id3153387"><keycode>End</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3153387">
- <keycode>End</keycode>
- </paragraph>
- </tablecell>
- <tablecell>
- <paragraph role="tablecontent" id="par_id3153684">Selects the last
item in the current dialog area.</paragraph>
+ <paragraph role="tablecontent" id="par_id3152949">Copies or moves
the current field into the "Row Fields" area.</paragraph>
</tablecell>
- </tablerow>
- <tablerow>
<tablecell>
<paragraph role="tablecontent" id="hd_id3155584"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Option</keycode></caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline>
and the underlined character in the label "Row Fields"</paragraph>
</tablecell>
- <tablecell>
- <paragraph role="tablecontent" id="par_id3152949">Copies or moves
the current field into the "Row Fields" area.</paragraph>
- </tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3159269"><switchinline
select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline>
and the underlined character in the label "Column Fields"</paragraph>
+ <paragraph role="tablecontent" id="par_id3149968">Copies or moves
the current field into the "Column Fields" area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3149968">Copies or moves
the current field into the "Column Fields" area.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3159269"><switchinline
select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline>
and the underlined character in the label "Column Fields"</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149923"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Option</keycode></caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline>
and the underlined character in the label "Data Fields"</paragraph>
+ <paragraph role="tablecontent" id="par_id3148649">Copies or moves
the current field into the "Data Fields" area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3148649">Copies or moves
the current field into the "Data Fields" area.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149923"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Option</keycode></caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline>
and the underlined character in the label "Data Fields"</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149423"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Option</keycode></caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline>
and the underlined character in the label "Filters"</paragraph>
+ <paragraph role="tablecontent" id="par_id3144649">Copies or moves
the current field into the "Filters" area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3144649">Copies or moves
the current field into the "Filters" area.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149423"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Option</keycode></caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline>
and the underlined character in the label "Filters"</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149418">
- <switchinline select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Up
Arrow</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3154335">Moves the
current field up one place.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3154335">Moves the
current field up one place.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149418"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Up
Arrow</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3148462">
- <switchinline select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Down
Arrow</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3154603">Moves the
current field down one place.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3154603">Moves the
current field down one place.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3148462"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Down
Arrow</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3145373">
- <switchinline select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Left
Arrow</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3151125">Moves the
current field one place to the left.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3151125">Moves the
current field one place to the left.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3145373"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Left
Arrow</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3150423">
- <switchinline select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Right
Arrow</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3153316">Moves the
current field one place to the right.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153316">Moves the
current field one place to the right.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3150423"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Right
Arrow</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3149519">
- <switchinline select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Home</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3149237">Moves the
current field to the first place.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3149237">Moves the
current field to the first place.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3149519"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Home</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3145310">
- <switchinline select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+End</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3153942">Moves the
current field to the last place.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3153942">Moves the
current field to the last place.</paragraph>
+ <paragraph role="tablecontent" id="hd_id3145310"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+End</keycode></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph role="tablecontent" id="hd_id3148418">
- <keycode>Delete</keycode>
- </paragraph>
+ <paragraph role="tablecontent" id="par_id3159251">Removes the
current field from the area.</paragraph>
</tablecell>
<tablecell>
- <paragraph role="tablecontent" id="par_id3159251">Removes the
current field from the area.</paragraph>
+ <paragraph role="tablecontent"
id="hd_id3148418"><keycode>Delete</keycode></paragraph>
</tablecell>
</tablerow>
</table>
