1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski 5*b1cdbd2cSJim Jagielski<!--*********************************************************** 6*b1cdbd2cSJim Jagielski * 7*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 8*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 9*b1cdbd2cSJim Jagielski * distributed with this work for additional information 10*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 11*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 12*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 13*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 14*b1cdbd2cSJim Jagielski * 15*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 16*b1cdbd2cSJim Jagielski * 17*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 18*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 19*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 21*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 22*b1cdbd2cSJim Jagielski * under the License. 23*b1cdbd2cSJim Jagielski * 24*b1cdbd2cSJim Jagielski ***********************************************************--> 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski <helpdocument version="1.0"> 30*b1cdbd2cSJim Jagielski<meta> 31*b1cdbd2cSJim Jagielski<topic id="textscalc0401020000xml" indexer="include" status="PUBLISH"> 32*b1cdbd2cSJim Jagielski<title id="tit" xml-lang="en-US">Shortcut Keys for Spreadsheets</title> 33*b1cdbd2cSJim Jagielski<filename>/text/scalc/04/01020000.xhp</filename> 34*b1cdbd2cSJim Jagielski</topic> 35*b1cdbd2cSJim Jagielski</meta> 36*b1cdbd2cSJim Jagielski<body> 37*b1cdbd2cSJim Jagielski<section id="starcalctasten"> 38*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3145801"><bookmark_value>spreadsheets; shortcut keys in</bookmark_value> 39*b1cdbd2cSJim Jagielski<bookmark_value>shortcut keys; spreadsheets</bookmark_value> 40*b1cdbd2cSJim Jagielski<bookmark_value>sheet ranges; filling</bookmark_value> 41*b1cdbd2cSJim Jagielski</bookmark><comment>mw deleted "matrices;..."</comment><paragraph role="heading" id="hd_id3145801" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="calc_keys"><link href="text/scalc/04/01020000.xhp" name="Shortcut Keys for Spreadsheets">Shortcut Keys for Spreadsheets</link> 42*b1cdbd2cSJim Jagielski</variable></paragraph> 43*b1cdbd2cSJim Jagielski<embed href="text/shared/00/00000099.xhp#keys"/> 44*b1cdbd2cSJim Jagielski</section> 45*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3155067" xml-lang="en-US" l10n="U" oldref="3">To fill a selected cell range with the formula that you entered on the <emph>Input line</emph>, press <switchinline select="sys"><caseinline select="MAC">Option 46*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter. Hold down <switchinline select="sys"><caseinline select="MAC">Option 47*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter+Shift to apply the cell format of the input cell to the entire cell range.</paragraph> 48*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3153967" xml-lang="en-US" l10n="U" oldref="84">To create a matrix in which all the cells contain the same information as what you entered on the <emph>Input line</emph>, press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter. You cannot edit the components of the matrix.</paragraph> 49*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3166426" xml-lang="en-US" l10n="U" oldref="4">To select multiple cells in different areas of a sheet, hold down <switchinline select="sys"><caseinline select="MAC">Command 50*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Ctrl </defaultinline></switchinline>and drag in the different areas.</paragraph> 51*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3150207" xml-lang="en-US" l10n="U" oldref="127">To select multiple sheets in a spreadsheet, hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, and then click the name tabs at the lower edge of the workspace. To select only one sheet in a selection, hold down Shift, and then click the name tab of the sheet.</paragraph> 52*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3166432" xml-lang="en-US" l10n="U" oldref="129">To insert a manual line break in a cell, click in the cell, and then press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter.</paragraph> 53*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3146978" xml-lang="en-US" l10n="U" oldref="130">To delete the contents of selected cells, press Delete. This opens the <link href="text/scalc/01/02150000.xhp" name="Delete Contents">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 Backspace key.</paragraph> 54*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3145386" xml-lang="en-US" level="2" l10n="U" oldref="85">Navigating in Spreadsheets</paragraph> 55*b1cdbd2cSJim Jagielski<table id="tbl_id5963927"> 56*b1cdbd2cSJim Jagielski<tablerow> 57*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 58*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="hd_id3149407" xml-lang="en-US" l10n="U" oldref="86">Shortcut Keys</paragraph> 59*b1cdbd2cSJim Jagielski</tablecell> 60*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 61*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="par_id3153815" xml-lang="en-US" l10n="U" oldref="87"> 62*b1cdbd2cSJim Jagielski<emph>Effect</emph> 63*b1cdbd2cSJim Jagielski</paragraph> 64*b1cdbd2cSJim Jagielski</tablecell> 65*b1cdbd2cSJim Jagielski</tablerow> 66*b1cdbd2cSJim Jagielski<tablerow> 67*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 68*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3146871" xml-lang="en-US" l10n="U" oldref="88"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Home</paragraph> 69*b1cdbd2cSJim Jagielski</tablecell> 70*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 71*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3159093" xml-lang="en-US" l10n="U" oldref="89">Moves the cursor to the first cell in the sheet (A1).</paragraph> 72*b1cdbd2cSJim Jagielski</tablecell> 73*b1cdbd2cSJim Jagielski</tablerow> 74*b1cdbd2cSJim Jagielski<tablerow> 75*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 76*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3145073" xml-lang="en-US" l10n="U" oldref="90"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+End</paragraph> 77*b1cdbd2cSJim Jagielski</tablecell> 78*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 79*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153283" xml-lang="en-US" l10n="U" oldref="91">Moves the cursor to the last cell on the sheet that contains data.</paragraph> 80*b1cdbd2cSJim Jagielski</tablecell> 81*b1cdbd2cSJim Jagielski</tablerow> 82*b1cdbd2cSJim Jagielski<tablerow> 83*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 84*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149127" xml-lang="en-US" l10n="U" oldref="92">Home</paragraph> 85*b1cdbd2cSJim Jagielski</tablecell> 86*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 87*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3159205" xml-lang="en-US" l10n="U" oldref="93">Moves the cursor to the first cell of the current row.</paragraph> 88*b1cdbd2cSJim Jagielski</tablecell> 89*b1cdbd2cSJim Jagielski</tablerow> 90*b1cdbd2cSJim Jagielski<tablerow> 91*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 92*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149897" xml-lang="en-US" l10n="U" oldref="94">End</paragraph> 93*b1cdbd2cSJim Jagielski</tablecell> 94*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 95*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3155095" xml-lang="en-US" l10n="U" oldref="95">Moves the cursor to the last cell of the current row.</paragraph> 96*b1cdbd2cSJim Jagielski</tablecell> 97*b1cdbd2cSJim Jagielski</tablerow> 98*b1cdbd2cSJim Jagielski<tablerow> 99*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 100*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3143220" xml-lang="en-US" l10n="U" oldref="101"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left Arrow</paragraph> 101*b1cdbd2cSJim Jagielski</tablecell> 102*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 103*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3154766" xml-lang="en-US" l10n="U" oldref="102">Moves the cursor to the left edge of the current data range. If the column to the left of the cell that contains the cursor is empty, the cursor moves to the next column to the left that contains data.</paragraph> 104*b1cdbd2cSJim Jagielski</tablecell> 105*b1cdbd2cSJim Jagielski</tablerow> 106*b1cdbd2cSJim Jagielski<tablerow> 107*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 108*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3153554" xml-lang="en-US" l10n="U" oldref="103"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Right Arrow</paragraph> 109*b1cdbd2cSJim Jagielski</tablecell> 110*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 111*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3155593" xml-lang="en-US" l10n="U" oldref="104">Moves the cursor to the right edge of the current data range. If the column to the right of the cell that contains the cursor is empty, the cursor moves to the next column to the right that contains data.</paragraph> 112*b1cdbd2cSJim Jagielski</tablecell> 113*b1cdbd2cSJim Jagielski</tablerow> 114*b1cdbd2cSJim Jagielski<tablerow> 115*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 116*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149317" xml-lang="en-US" l10n="U" oldref="105"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Up Arrow</paragraph> 117*b1cdbd2cSJim Jagielski</tablecell> 118*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 119*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153076" xml-lang="en-US" l10n="U" oldref="106">Moves the cursor to the top edge of the current data range. If the row above the cell that contains the cursor is empty, the cursor moves up to the next row that contains data.</paragraph> 120*b1cdbd2cSJim Jagielski</tablecell> 121*b1cdbd2cSJim Jagielski</tablerow> 122*b1cdbd2cSJim Jagielski<tablerow> 123*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 124*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3147250" xml-lang="en-US" l10n="U" oldref="107"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Down Arrow</paragraph> 125*b1cdbd2cSJim Jagielski</tablecell> 126*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 127*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149054" xml-lang="en-US" l10n="U" oldref="108">Moves the cursor to the bottom edge of the current data range. If the row below the cell that contains the cursor is empty, the cursor moves down to the next row that contains data.</paragraph> 128*b1cdbd2cSJim Jagielski</tablecell> 129*b1cdbd2cSJim Jagielski</tablerow> 130*b1cdbd2cSJim Jagielski<tablerow> 131*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 132*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3148744" xml-lang="en-US" l10n="U" oldref="184"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Arrow</paragraph> 133*b1cdbd2cSJim Jagielski</tablecell> 134*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 135*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3159258" xml-lang="en-US" l10n="U" oldref="185">Selects all cells containing data from the current cell to the end of the continuous range of data cells, in the direction of the arrow pressed. If used to select rows and columns together, a rectangular cell range is selected.</paragraph> 136*b1cdbd2cSJim Jagielski</tablecell> 137*b1cdbd2cSJim Jagielski</tablerow> 138*b1cdbd2cSJim Jagielski<tablerow> 139*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 140*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3156399" xml-lang="en-US" l10n="U" oldref="109"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up</paragraph> 141*b1cdbd2cSJim Jagielski</tablecell> 142*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 143*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3145236" xml-lang="en-US" l10n="U" oldref="110">Moves one sheet to the left.</paragraph> 144*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149725" xml-lang="en-US" l10n="U" oldref="131">In the page preview: Moves to the previous print page.</paragraph> 145*b1cdbd2cSJim Jagielski</tablecell> 146*b1cdbd2cSJim Jagielski</tablerow> 147*b1cdbd2cSJim Jagielski<tablerow> 148*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 149*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3147411" xml-lang="en-US" l10n="U" oldref="111"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Down</paragraph> 150*b1cdbd2cSJim Jagielski</tablecell> 151*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 152*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3150372" xml-lang="en-US" l10n="U" oldref="112">Moves one sheet to the right.</paragraph> 153*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3159120" xml-lang="en-US" l10n="U" oldref="132">In the page preview: Moves to the next print page.</paragraph> 154*b1cdbd2cSJim Jagielski</tablecell> 155*b1cdbd2cSJim Jagielski</tablerow> 156*b1cdbd2cSJim Jagielski<tablerow> 157*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 158*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3146885" xml-lang="en-US" l10n="U" oldref="113"><switchinline select="sys"><caseinline select="MAC">Option 159*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Alt</defaultinline></switchinline> + Page Up</paragraph> 160*b1cdbd2cSJim Jagielski</tablecell> 161*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 162*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3152976" xml-lang="en-US" l10n="U" oldref="114">Moves one screen to the left.</paragraph> 163*b1cdbd2cSJim Jagielski</tablecell> 164*b1cdbd2cSJim Jagielski</tablerow> 165*b1cdbd2cSJim Jagielski<tablerow> 166*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 167*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149013" xml-lang="en-US" l10n="U" oldref="115"><switchinline select="sys"><caseinline select="MAC">Option 168*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Alt</defaultinline></switchinline> + Page Down</paragraph> 169*b1cdbd2cSJim Jagielski</tablecell> 170*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 171*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3150477" xml-lang="en-US" l10n="U" oldref="116">Moves one screen page to the right.</paragraph> 172*b1cdbd2cSJim Jagielski</tablecell> 173*b1cdbd2cSJim Jagielski</tablerow> 174*b1cdbd2cSJim Jagielski<tablerow> 175*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 176*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_idN10AFC" xml-lang="en-US" l10n="NEW">Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up</paragraph> 177*b1cdbd2cSJim Jagielski</tablecell> 178*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 179*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_idN10B00" xml-lang="en-US" l10n="NEW">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> 180*b1cdbd2cSJim Jagielski</tablecell> 181*b1cdbd2cSJim Jagielski</tablerow> 182*b1cdbd2cSJim Jagielski<tablerow> 183*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 184*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_idN10B03" xml-lang="en-US" l10n="NEW">Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Down</paragraph> 185*b1cdbd2cSJim Jagielski</tablecell> 186*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 187*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_idN10B07" xml-lang="en-US" l10n="NEW">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> 188*b1cdbd2cSJim Jagielski</tablecell> 189*b1cdbd2cSJim Jagielski</tablerow> 190*b1cdbd2cSJim Jagielski<tablerow> 191*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 192*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3145826" xml-lang="en-US" l10n="U" oldref="96"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + *</paragraph> 193*b1cdbd2cSJim Jagielski</tablecell> 194*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 195*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3148882" xml-lang="en-US" l10n="U" oldref="97">where (*) is the multiplication sign on the numeric key pad</paragraph> 196*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3154847" xml-lang="en-US" l10n="U" oldref="98">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> 197*b1cdbd2cSJim Jagielski</tablecell> 198*b1cdbd2cSJim Jagielski</tablerow> 199*b1cdbd2cSJim Jagielski<tablerow> 200*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 201*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3151233" xml-lang="en-US" l10n="U" oldref="180"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + /</paragraph> 202*b1cdbd2cSJim Jagielski</tablecell> 203*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 204*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149949" xml-lang="en-US" l10n="U" oldref="181">where (/) is the division sign on the numeric key pad</paragraph> 205*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3150144" xml-lang="en-US" l10n="U" oldref="182">Selects the matrix formula range that contains the cursor.</paragraph> 206*b1cdbd2cSJim Jagielski</tablecell> 207*b1cdbd2cSJim Jagielski</tablerow> 208*b1cdbd2cSJim Jagielski<tablerow> 209*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 210*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id8163396" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Plus key</paragraph> 211*b1cdbd2cSJim Jagielski</tablecell> 212*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 213*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id9901425" xml-lang="en-US" l10n="NEW">Insert cells (as in menu Insert - Cells)<comment>[sc-features] of 8.June07</comment></paragraph> 214*b1cdbd2cSJim Jagielski</tablecell> 215*b1cdbd2cSJim Jagielski</tablerow> 216*b1cdbd2cSJim Jagielski<tablerow> 217*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 218*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3389080" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Minus key</paragraph> 219*b1cdbd2cSJim Jagielski</tablecell> 220*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 221*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id5104220" xml-lang="en-US" l10n="NEW">Delete cells (as in menu Edit - Delete Cells)</paragraph> 222*b1cdbd2cSJim Jagielski</tablecell> 223*b1cdbd2cSJim Jagielski</tablerow> 224*b1cdbd2cSJim Jagielski<tablerow> 225*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 226*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3155825" xml-lang="en-US" l10n="CHG" oldref="99">Enter (in a selected range)<comment>see i80051</comment></paragraph> 227*b1cdbd2cSJim Jagielski</tablecell> 228*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 229*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153935" xml-lang="en-US" l10n="U" oldref="100">Moves the cursor down one cell in a selected range. To specify the direction that the cursor moves, choose <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - General</emph>.</paragraph> 230*b1cdbd2cSJim Jagielski</tablecell> 231*b1cdbd2cSJim Jagielski</tablerow> 232*b1cdbd2cSJim Jagielski<tablerow> 233*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 234*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id5961180" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline> + ` (see note below this table)</paragraph> 235*b1cdbd2cSJim Jagielski</tablecell> 236*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 237*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id6407055" xml-lang="en-US" l10n="NEW">Displays or hides the formulas instead of the values in all cells.<comment>i56202</comment></paragraph> 238*b1cdbd2cSJim Jagielski</tablecell> 239*b1cdbd2cSJim Jagielski</tablerow> 240*b1cdbd2cSJim Jagielski</table> 241*b1cdbd2cSJim Jagielski<paragraph role="note" id="par_id8070314" xml-lang="en-US" l10n="NEW">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 Tools - Customize, click the Keyboard tab. Select the "View" category and the "Toggle Formula" function.</paragraph> 242*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3148756" xml-lang="en-US" level="2" l10n="U" oldref="5">Function Keys Used in Spreadsheets</paragraph> 243*b1cdbd2cSJim Jagielski<table id="tbl_id5384685"> 244*b1cdbd2cSJim Jagielski<tablerow> 245*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 246*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="hd_id3148581" xml-lang="en-US" l10n="U" oldref="6">Shortcut Keys</paragraph> 247*b1cdbd2cSJim Jagielski</tablecell> 248*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 249*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="par_id3152790" xml-lang="en-US" l10n="U" oldref="8"> 250*b1cdbd2cSJim Jagielski<emph>Effect</emph> 251*b1cdbd2cSJim Jagielski</paragraph> 252*b1cdbd2cSJim Jagielski</tablecell> 253*b1cdbd2cSJim Jagielski</tablerow> 254*b1cdbd2cSJim Jagielski<tablerow> 255*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 256*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3154809" xml-lang="en-US" l10n="U" oldref="139"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F1</paragraph> 257*b1cdbd2cSJim Jagielski</tablecell> 258*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 259*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3145140" xml-lang="en-US" l10n="U" oldref="138">Displays the comment that is attached to the current cell</paragraph> 260*b1cdbd2cSJim Jagielski</tablecell> 261*b1cdbd2cSJim Jagielski</tablerow> 262*b1cdbd2cSJim Jagielski<tablerow> 263*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 264*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3146142" xml-lang="en-US" l10n="U" oldref="9">F2</paragraph> 265*b1cdbd2cSJim Jagielski</tablecell> 266*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 267*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3148568" xml-lang="en-US" l10n="U" oldref="10">Switches to Edit mode and places the cursor at the end of the contents of the current cell. Press again to exit Edit mode.</paragraph> 268*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153108" xml-lang="en-US" l10n="U" oldref="179">If the cursor is in an input box in a dialog that has a <emph>Minimize </emph>button, the dialog is hidden and the input box remains visible. Press F2 again to show the whole dialog.</paragraph> 269*b1cdbd2cSJim Jagielski</tablecell> 270*b1cdbd2cSJim Jagielski</tablerow> 271*b1cdbd2cSJim Jagielski<tablerow> 272*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 273*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3146850" xml-lang="en-US" l10n="U" oldref="11"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph> 274*b1cdbd2cSJim Jagielski</tablecell> 275*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 276*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3145162" xml-lang="en-US" l10n="U" oldref="12">Opens the Function Wizard.</paragraph> 277*b1cdbd2cSJim Jagielski</tablecell> 278*b1cdbd2cSJim Jagielski</tablerow> 279*b1cdbd2cSJim Jagielski<tablerow> 280*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 281*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3147366" xml-lang="en-US" l10n="U" oldref="137">Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph> 282*b1cdbd2cSJim Jagielski</tablecell> 283*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 284*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3155929" xml-lang="en-US" l10n="U" oldref="136">Moves the cursor to the <emph>Input line</emph> where you can enter a formula for the current cell.</paragraph> 285*b1cdbd2cSJim Jagielski</tablecell> 286*b1cdbd2cSJim Jagielski</tablerow> 287*b1cdbd2cSJim Jagielski<tablerow> 288*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 289*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3153730" xml-lang="en-US" l10n="U" oldref="15"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph> 290*b1cdbd2cSJim Jagielski</tablecell> 291*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 292*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3145245" xml-lang="en-US" l10n="U" oldref="16">Opens the <emph>Define Names</emph> dialog.</paragraph> 293*b1cdbd2cSJim Jagielski</tablecell> 294*b1cdbd2cSJim Jagielski</tablerow> 295*b1cdbd2cSJim Jagielski<tablerow> 296*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 297*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3148768" xml-lang="en-US" l10n="U" oldref="17">F4</paragraph> 298*b1cdbd2cSJim Jagielski</tablecell> 299*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 300*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153047" xml-lang="en-US" l10n="U" oldref="18">Shows or Hides the Database explorer.</paragraph> 301*b1cdbd2cSJim Jagielski</tablecell> 302*b1cdbd2cSJim Jagielski</tablerow> 303*b1cdbd2cSJim Jagielski<tablerow> 304*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 305*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3145353" xml-lang="en-US" l10n="U" oldref="19">Shift+F4</paragraph> 306*b1cdbd2cSJim Jagielski</tablecell> 307*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 308*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3155620" xml-lang="en-US" l10n="U" oldref="20">Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input field.</paragraph> 309*b1cdbd2cSJim Jagielski</tablecell> 310*b1cdbd2cSJim Jagielski</tablerow> 311*b1cdbd2cSJim Jagielski<tablerow> 312*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 313*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3156063" xml-lang="en-US" l10n="U" oldref="21">F5</paragraph> 314*b1cdbd2cSJim Jagielski</tablecell> 315*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 316*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149540" xml-lang="en-US" l10n="U" oldref="22">Shows or hides the <emph>Navigator</emph>.</paragraph> 317*b1cdbd2cSJim Jagielski</tablecell> 318*b1cdbd2cSJim Jagielski</tablerow> 319*b1cdbd2cSJim Jagielski<tablerow> 320*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 321*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3148392" xml-lang="en-US" l10n="U" oldref="23">Shift+F5</paragraph> 322*b1cdbd2cSJim Jagielski</tablecell> 323*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 324*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3150268" xml-lang="en-US" l10n="U" oldref="24">Traces dependents.</paragraph> 325*b1cdbd2cSJim Jagielski</tablecell> 326*b1cdbd2cSJim Jagielski</tablerow> 327*b1cdbd2cSJim Jagielski<tablerow> 328*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 329*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3148430" xml-lang="en-US" l10n="U" oldref="27">Shift+F7</paragraph> 330*b1cdbd2cSJim Jagielski</tablecell> 331*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 332*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153179" xml-lang="en-US" l10n="U" oldref="28">Traces precedents.</paragraph> 333*b1cdbd2cSJim Jagielski</tablecell> 334*b1cdbd2cSJim Jagielski</tablerow> 335*b1cdbd2cSJim Jagielski<tablerow> 336*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 337*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3150568" xml-lang="en-US" l10n="U" oldref="135">Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F5</paragraph> 338*b1cdbd2cSJim Jagielski</tablecell> 339*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 340*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153551" xml-lang="en-US" l10n="U" oldref="134">Moves the cursor from the <emph>Input line </emph>to the <emph>Sheet area</emph> box.</paragraph> 341*b1cdbd2cSJim Jagielski</tablecell> 342*b1cdbd2cSJim Jagielski</tablerow> 343*b1cdbd2cSJim Jagielski<tablerow> 344*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 345*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3155368" xml-lang="en-US" l10n="U" oldref="29">F7</paragraph> 346*b1cdbd2cSJim Jagielski</tablecell> 347*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 348*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3154871" xml-lang="en-US" l10n="U" oldref="30">Checks spelling in the current sheet.</paragraph> 349*b1cdbd2cSJim Jagielski</tablecell> 350*b1cdbd2cSJim Jagielski</tablerow> 351*b1cdbd2cSJim Jagielski<tablerow> 352*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 353*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3150688" xml-lang="en-US" l10n="U" oldref="31"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F7</paragraph> 354*b1cdbd2cSJim Jagielski</tablecell> 355*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 356*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149781" xml-lang="en-US" l10n="U" oldref="32">Opens the Thesaurus if the current cell contains text.</paragraph> 357*b1cdbd2cSJim Jagielski</tablecell> 358*b1cdbd2cSJim Jagielski</tablerow> 359*b1cdbd2cSJim Jagielski<tablerow> 360*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 361*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3156257" xml-lang="en-US" l10n="U" oldref="33">F8</paragraph> 362*b1cdbd2cSJim Jagielski</tablecell> 363*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 364*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3147482" xml-lang="en-US" l10n="U" oldref="34">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> 365*b1cdbd2cSJim Jagielski</tablecell> 366*b1cdbd2cSJim Jagielski</tablerow> 367*b1cdbd2cSJim Jagielski<tablerow> 368*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 369*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3154313" xml-lang="en-US" l10n="U" oldref="37"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F8</paragraph> 370*b1cdbd2cSJim Jagielski</tablecell> 371*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 372*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3150385" xml-lang="en-US" l10n="U" oldref="38">Highlights cells containing values.</paragraph> 373*b1cdbd2cSJim Jagielski</tablecell> 374*b1cdbd2cSJim Jagielski</tablerow> 375*b1cdbd2cSJim Jagielski<tablerow> 376*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 377*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3152479" xml-lang="en-US" l10n="U" oldref="39">F9</paragraph> 378*b1cdbd2cSJim Jagielski</tablecell> 379*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 380*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3163827" xml-lang="en-US" l10n="CHG" oldref="40">Recalculates changed formulas in the current sheet.</paragraph> 381*b1cdbd2cSJim Jagielski</tablecell> 382*b1cdbd2cSJim Jagielski</tablerow> 383*b1cdbd2cSJim Jagielski<tablerow> 384*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 385*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id9027069" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+F9</paragraph> 386*b1cdbd2cSJim Jagielski</tablecell> 387*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 388*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id1729178" xml-lang="en-US" l10n="NEW">Recalculates all formulas in all sheets.</paragraph> 389*b1cdbd2cSJim Jagielski</tablecell> 390*b1cdbd2cSJim Jagielski</tablerow> 391*b1cdbd2cSJim Jagielski<tablerow> 392*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 393*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3156300" xml-lang="en-US" l10n="U" oldref="41"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9</paragraph> 394*b1cdbd2cSJim Jagielski</tablecell> 395*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 396*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3154817" xml-lang="en-US" l10n="U" oldref="42">Updates the selected chart.</paragraph> 397*b1cdbd2cSJim Jagielski</tablecell> 398*b1cdbd2cSJim Jagielski</tablerow> 399*b1cdbd2cSJim Jagielski<tablerow> 400*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 401*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149279" xml-lang="en-US" l10n="U" oldref="46"><switchinline select="sys"><caseinline select="MAC">Command+T</caseinline><defaultinline>F11</defaultinline></switchinline></paragraph> 402*b1cdbd2cSJim Jagielski</tablecell> 403*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 404*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3150967" xml-lang="en-US" l10n="U" oldref="47">Opens the <emph>Styles and Formatting</emph> window where you can apply a formatting style to the contents of the cell or to the current sheet.</paragraph> 405*b1cdbd2cSJim Jagielski</tablecell> 406*b1cdbd2cSJim Jagielski</tablerow> 407*b1cdbd2cSJim Jagielski<tablerow> 408*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 409*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3156308" xml-lang="en-US" l10n="U" oldref="48">Shift+F11</paragraph> 410*b1cdbd2cSJim Jagielski</tablecell> 411*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 412*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3145209" xml-lang="en-US" l10n="U" oldref="49">Creates a document template.</paragraph> 413*b1cdbd2cSJim Jagielski</tablecell> 414*b1cdbd2cSJim Jagielski</tablerow> 415*b1cdbd2cSJim Jagielski<tablerow> 416*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 417*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3147622" xml-lang="en-US" l10n="U" oldref="50">Shift<switchinline select="sys"><caseinline select="MAC">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+F11</paragraph> 418*b1cdbd2cSJim Jagielski</tablecell> 419*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 420*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153215" xml-lang="en-US" l10n="U" oldref="51">Updates the templates.</paragraph> 421*b1cdbd2cSJim Jagielski</tablecell> 422*b1cdbd2cSJim Jagielski</tablerow> 423*b1cdbd2cSJim Jagielski<tablerow> 424*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 425*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3150760" xml-lang="en-US" l10n="U" oldref="52">F12</paragraph> 426*b1cdbd2cSJim Jagielski</tablecell> 427*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 428*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3156321" xml-lang="en-US" l10n="U" oldref="53">Groups the selected data range.</paragraph> 429*b1cdbd2cSJim Jagielski</tablecell> 430*b1cdbd2cSJim Jagielski</tablerow> 431*b1cdbd2cSJim Jagielski<tablerow> 432*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 433*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3146859" xml-lang="en-US" l10n="U" oldref="54"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph> 434*b1cdbd2cSJim Jagielski</tablecell> 435*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 436*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3156128" xml-lang="en-US" l10n="U" oldref="55">Ungroups the selected data range.</paragraph> 437*b1cdbd2cSJim Jagielski</tablecell> 438*b1cdbd2cSJim Jagielski</tablerow> 439*b1cdbd2cSJim Jagielski<tablerow> 440*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 441*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3151264" xml-lang="en-US" l10n="U" oldref="117"><switchinline select="sys"><caseinline select="MAC">Option 442*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Alt</defaultinline></switchinline> + Down Arrow</paragraph> 443*b1cdbd2cSJim Jagielski</tablecell> 444*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 445*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153155" xml-lang="en-US" l10n="U" oldref="118">Increases the height of current row.</paragraph> 446*b1cdbd2cSJim Jagielski</tablecell> 447*b1cdbd2cSJim Jagielski</tablerow> 448*b1cdbd2cSJim Jagielski<tablerow> 449*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 450*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3151297" xml-lang="en-US" l10n="U" oldref="119"><switchinline select="sys"><caseinline select="MAC">Option 451*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Alt</defaultinline></switchinline> + Up Arrow</paragraph> 452*b1cdbd2cSJim Jagielski</tablecell> 453*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 454*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3155849" xml-lang="en-US" l10n="U" oldref="120">Decreases the height of current row.</paragraph> 455*b1cdbd2cSJim Jagielski</tablecell> 456*b1cdbd2cSJim Jagielski</tablerow> 457*b1cdbd2cSJim Jagielski<tablerow> 458*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 459*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3155997" xml-lang="en-US" l10n="U" oldref="121"><switchinline select="sys"><caseinline select="MAC">Option 460*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Alt</defaultinline></switchinline> + Right Arrow</paragraph> 461*b1cdbd2cSJim Jagielski</tablecell> 462*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 463*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3150256" xml-lang="en-US" l10n="U" oldref="122">Increases the width of the current column.</paragraph> 464*b1cdbd2cSJim Jagielski</tablecell> 465*b1cdbd2cSJim Jagielski</tablerow> 466*b1cdbd2cSJim Jagielski<tablerow> 467*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 468*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3154046" xml-lang="en-US" l10n="U" oldref="123"><switchinline select="sys"><caseinline select="MAC">Option 469*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Alt</defaultinline></switchinline> + Left Arrow</paragraph> 470*b1cdbd2cSJim Jagielski</tablecell> 471*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 472*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3150155" xml-lang="en-US" l10n="U" oldref="124">Decreases the width of the current column.</paragraph> 473*b1cdbd2cSJim Jagielski</tablecell> 474*b1cdbd2cSJim Jagielski</tablerow> 475*b1cdbd2cSJim Jagielski<tablerow> 476*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 477*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149293" xml-lang="en-US" l10n="U" oldref="125"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Shift+Arrow Key</paragraph> 478*b1cdbd2cSJim Jagielski</tablecell> 479*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 480*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3159180" xml-lang="en-US" l10n="U" oldref="126">Optimizes the column width or row height based on the current cell.</paragraph> 481*b1cdbd2cSJim Jagielski</tablecell> 482*b1cdbd2cSJim Jagielski</tablerow> 483*b1cdbd2cSJim Jagielski</table> 484*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3156013" xml-lang="en-US" level="2" l10n="U" oldref="56">Formatting Cells Using Shortcut Keys</paragraph> 485*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3153979" xml-lang="en-US" l10n="U" oldref="57">The following cell formats can be applied with the keyboard:</paragraph> 486*b1cdbd2cSJim Jagielski<table id="tbl_id6533097"> 487*b1cdbd2cSJim Jagielski<tablerow> 488*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 489*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="hd_id3147492" xml-lang="en-US" l10n="U" oldref="58">Shortcut Keys</paragraph> 490*b1cdbd2cSJim Jagielski</tablecell> 491*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 492*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="par_id3154305" xml-lang="en-US" l10n="U" oldref="60"> 493*b1cdbd2cSJim Jagielski<emph>Effect</emph> 494*b1cdbd2cSJim Jagielski</paragraph> 495*b1cdbd2cSJim Jagielski</tablecell> 496*b1cdbd2cSJim Jagielski</tablerow> 497*b1cdbd2cSJim Jagielski<tablerow> 498*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 499*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3145669" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+1 (not on the number pad)</paragraph> 500*b1cdbd2cSJim Jagielski</tablecell> 501*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 502*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149197" xml-lang="en-US" l10n="NEW">Open Format Cells dialog</paragraph> 503*b1cdbd2cSJim Jagielski</tablecell> 504*b1cdbd2cSJim Jagielski</tablerow> 505*b1cdbd2cSJim Jagielski<tablerow> 506*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 507*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3145668" xml-lang="en-US" l10n="U" oldref="61"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+1 (not on the number pad)</paragraph> 508*b1cdbd2cSJim Jagielski</tablecell> 509*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 510*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149196" xml-lang="en-US" l10n="U" oldref="63">Two decimal places, thousands separator</paragraph> 511*b1cdbd2cSJim Jagielski</tablecell> 512*b1cdbd2cSJim Jagielski</tablerow> 513*b1cdbd2cSJim Jagielski<tablerow> 514*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 515*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3155331" xml-lang="en-US" l10n="U" oldref="64"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+2 (not on the number pad)</paragraph> 516*b1cdbd2cSJim Jagielski</tablecell> 517*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 518*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3150120" xml-lang="en-US" l10n="U" oldref="66">Standard exponential format</paragraph> 519*b1cdbd2cSJim Jagielski</tablecell> 520*b1cdbd2cSJim Jagielski</tablerow> 521*b1cdbd2cSJim Jagielski<tablerow> 522*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 523*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3154932" xml-lang="en-US" l10n="U" oldref="67"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+3 (not on the number pad)</paragraph> 524*b1cdbd2cSJim Jagielski</tablecell> 525*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 526*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3148822" xml-lang="en-US" l10n="U" oldref="69">Standard date format</paragraph> 527*b1cdbd2cSJim Jagielski</tablecell> 528*b1cdbd2cSJim Jagielski</tablerow> 529*b1cdbd2cSJim Jagielski<tablerow> 530*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 531*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3148829" xml-lang="en-US" l10n="U" oldref="70"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+4 (not on the number pad)</paragraph> 532*b1cdbd2cSJim Jagielski</tablecell> 533*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 534*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3159152" xml-lang="en-US" l10n="U" oldref="72">Standard currency format</paragraph> 535*b1cdbd2cSJim Jagielski</tablecell> 536*b1cdbd2cSJim Jagielski</tablerow> 537*b1cdbd2cSJim Jagielski<tablerow> 538*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 539*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3150776" xml-lang="en-US" l10n="U" oldref="73"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+5 (not on the number pad)</paragraph> 540*b1cdbd2cSJim Jagielski</tablecell> 541*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 542*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3148800" xml-lang="en-US" l10n="U" oldref="75">Standard percentage format (two decimal places)</paragraph> 543*b1cdbd2cSJim Jagielski</tablecell> 544*b1cdbd2cSJim Jagielski</tablerow> 545*b1cdbd2cSJim Jagielski<tablerow> 546*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 547*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3158407" xml-lang="en-US" l10n="U" oldref="76"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+6 (not on the number pad)</paragraph> 548*b1cdbd2cSJim Jagielski</tablecell> 549*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 550*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3148444" xml-lang="en-US" l10n="U" oldref="78">Standard format</paragraph> 551*b1cdbd2cSJim Jagielski</tablecell> 552*b1cdbd2cSJim Jagielski</tablerow> 553*b1cdbd2cSJim Jagielski</table> 554*b1cdbd2cSJim Jagielski<section id="datenpiloten"> 555*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3154205" xml-lang="en-US" level="2" l10n="CHG" oldref="178">Using the pivot table</paragraph> 556*b1cdbd2cSJim Jagielski<table id="tbl_id2419507"> 557*b1cdbd2cSJim Jagielski<tablerow> 558*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 559*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="par_idN11326" xml-lang="en-US" l10n="NEW">Keys</paragraph> 560*b1cdbd2cSJim Jagielski</tablecell> 561*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 562*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="par_idN1132C" xml-lang="en-US" l10n="NEW">Effect</paragraph> 563*b1cdbd2cSJim Jagielski</tablecell> 564*b1cdbd2cSJim Jagielski</tablerow> 565*b1cdbd2cSJim Jagielski<tablerow> 566*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 567*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3153577" xml-lang="en-US" l10n="U" oldref="177">Tab</paragraph> 568*b1cdbd2cSJim Jagielski</tablecell> 569*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 570*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3147511" xml-lang="en-US" l10n="U" oldref="176">Changes the focus by moving forwards through the areas and buttons of the dialog.</paragraph> 571*b1cdbd2cSJim Jagielski</tablecell> 572*b1cdbd2cSJim Jagielski</tablerow> 573*b1cdbd2cSJim Jagielski<tablerow> 574*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 575*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3154266" xml-lang="en-US" l10n="U" oldref="175">Shift+Tab</paragraph> 576*b1cdbd2cSJim Jagielski</tablecell> 577*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 578*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3155362" xml-lang="en-US" l10n="U" oldref="174">Changes the focus by moving backwards through the areas and buttons of the dialog.</paragraph> 579*b1cdbd2cSJim Jagielski</tablecell> 580*b1cdbd2cSJim Jagielski</tablerow> 581*b1cdbd2cSJim Jagielski<tablerow> 582*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 583*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3148484" xml-lang="en-US" l10n="U" oldref="173">up arrow</paragraph> 584*b1cdbd2cSJim Jagielski</tablecell> 585*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 586*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149152" xml-lang="en-US" l10n="U" oldref="172">Moves the focus up one item in the current dialog area.</paragraph> 587*b1cdbd2cSJim Jagielski</tablecell> 588*b1cdbd2cSJim Jagielski</tablerow> 589*b1cdbd2cSJim Jagielski<tablerow> 590*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 591*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3154273" xml-lang="en-US" l10n="U" oldref="171">down arrow</paragraph> 592*b1cdbd2cSJim Jagielski</tablecell> 593*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 594*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3158424" xml-lang="en-US" l10n="U" oldref="170">Moves the focus down one item in the current dialog area.</paragraph> 595*b1cdbd2cSJim Jagielski</tablecell> 596*b1cdbd2cSJim Jagielski</tablerow> 597*b1cdbd2cSJim Jagielski<tablerow> 598*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 599*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3148912" xml-lang="en-US" l10n="U" oldref="169">left arrow</paragraph> 600*b1cdbd2cSJim Jagielski</tablecell> 601*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 602*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153238" xml-lang="en-US" l10n="U" oldref="168">Moves the focus one item to the left in the current dialog area.</paragraph> 603*b1cdbd2cSJim Jagielski</tablecell> 604*b1cdbd2cSJim Jagielski</tablerow> 605*b1cdbd2cSJim Jagielski<tablerow> 606*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 607*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3150712" xml-lang="en-US" l10n="U" oldref="167">right arrow</paragraph> 608*b1cdbd2cSJim Jagielski</tablecell> 609*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 610*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3166458" xml-lang="en-US" l10n="U" oldref="166">Moves the focus one item to the right in the current dialog area.</paragraph> 611*b1cdbd2cSJim Jagielski</tablecell> 612*b1cdbd2cSJim Jagielski</tablerow> 613*b1cdbd2cSJim Jagielski<tablerow> 614*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 615*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3146947" xml-lang="en-US" l10n="U" oldref="165">Home</paragraph> 616*b1cdbd2cSJim Jagielski</tablecell> 617*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 618*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153742" xml-lang="en-US" l10n="U" oldref="164">Selects the first item in the current dialog area.</paragraph> 619*b1cdbd2cSJim Jagielski</tablecell> 620*b1cdbd2cSJim Jagielski</tablerow> 621*b1cdbd2cSJim Jagielski<tablerow> 622*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 623*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3153387" xml-lang="en-US" l10n="U" oldref="163">End</paragraph> 624*b1cdbd2cSJim Jagielski</tablecell> 625*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 626*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153684" xml-lang="en-US" l10n="U" oldref="162">Selects the last item in the current dialog area.</paragraph> 627*b1cdbd2cSJim Jagielski</tablecell> 628*b1cdbd2cSJim Jagielski</tablerow> 629*b1cdbd2cSJim Jagielski<tablerow> 630*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 631*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3155584" xml-lang="en-US" l10n="U" oldref="161"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> and the underlined character in the word "Row"</paragraph> 632*b1cdbd2cSJim Jagielski</tablecell> 633*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 634*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3152949" xml-lang="en-US" l10n="U" oldref="160">Copies or moves the current field into the "Row" area.</paragraph> 635*b1cdbd2cSJim Jagielski</tablecell> 636*b1cdbd2cSJim Jagielski</tablerow> 637*b1cdbd2cSJim Jagielski<tablerow> 638*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 639*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3159269" xml-lang="en-US" l10n="U" oldref="159"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> and the underlined character in the word "Column"</paragraph> 640*b1cdbd2cSJim Jagielski</tablecell> 641*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 642*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149968" xml-lang="en-US" l10n="U" oldref="158">Copies or moves the current field into the "Column" area.</paragraph> 643*b1cdbd2cSJim Jagielski</tablecell> 644*b1cdbd2cSJim Jagielski</tablerow> 645*b1cdbd2cSJim Jagielski<tablerow> 646*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 647*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149923" xml-lang="en-US" l10n="U" oldref="157"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> and the underlined character in the word "Data"</paragraph> 648*b1cdbd2cSJim Jagielski</tablecell> 649*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 650*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3148649" xml-lang="en-US" l10n="U" oldref="156">Copies or moves the current field into the "Data" area.</paragraph> 651*b1cdbd2cSJim Jagielski</tablecell> 652*b1cdbd2cSJim Jagielski</tablerow> 653*b1cdbd2cSJim Jagielski<tablerow> 654*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 655*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149418" xml-lang="en-US" l10n="U" oldref="155"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Up Arrow</paragraph> 656*b1cdbd2cSJim Jagielski</tablecell> 657*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 658*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3154335" xml-lang="en-US" l10n="U" oldref="154">Moves the current field up one place.</paragraph> 659*b1cdbd2cSJim Jagielski</tablecell> 660*b1cdbd2cSJim Jagielski</tablerow> 661*b1cdbd2cSJim Jagielski<tablerow> 662*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 663*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3148462" xml-lang="en-US" l10n="U" oldref="153"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Down Arrow</paragraph> 664*b1cdbd2cSJim Jagielski</tablecell> 665*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 666*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3154603" xml-lang="en-US" l10n="U" oldref="152">Moves the current field down one place.</paragraph> 667*b1cdbd2cSJim Jagielski</tablecell> 668*b1cdbd2cSJim Jagielski</tablerow> 669*b1cdbd2cSJim Jagielski<tablerow> 670*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 671*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3145373" xml-lang="en-US" l10n="U" oldref="151"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left Arrow</paragraph> 672*b1cdbd2cSJim Jagielski</tablecell> 673*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 674*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3151125" xml-lang="en-US" l10n="U" oldref="150">Moves the current field one place to the left.</paragraph> 675*b1cdbd2cSJim Jagielski</tablecell> 676*b1cdbd2cSJim Jagielski</tablerow> 677*b1cdbd2cSJim Jagielski<tablerow> 678*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 679*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3150423" xml-lang="en-US" l10n="U" oldref="149"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Right Arrow</paragraph> 680*b1cdbd2cSJim Jagielski</tablecell> 681*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 682*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153316" xml-lang="en-US" l10n="U" oldref="148">Moves the current field one place to the right.</paragraph> 683*b1cdbd2cSJim Jagielski</tablecell> 684*b1cdbd2cSJim Jagielski</tablerow> 685*b1cdbd2cSJim Jagielski<tablerow> 686*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 687*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149519" xml-lang="en-US" l10n="U" oldref="147"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Home</paragraph> 688*b1cdbd2cSJim Jagielski</tablecell> 689*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 690*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3149237" xml-lang="en-US" l10n="U" oldref="146">Moves the current field to the first place.</paragraph> 691*b1cdbd2cSJim Jagielski</tablecell> 692*b1cdbd2cSJim Jagielski</tablerow> 693*b1cdbd2cSJim Jagielski<tablerow> 694*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 695*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3145310" xml-lang="en-US" l10n="U" oldref="145"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+End</paragraph> 696*b1cdbd2cSJim Jagielski</tablecell> 697*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 698*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3153942" xml-lang="en-US" l10n="U" oldref="144">Moves the current field to the last place.</paragraph> 699*b1cdbd2cSJim Jagielski</tablecell> 700*b1cdbd2cSJim Jagielski</tablerow> 701*b1cdbd2cSJim Jagielski<tablerow> 702*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 703*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3149933" xml-lang="en-US" l10n="U" oldref="143"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+O</paragraph> 704*b1cdbd2cSJim Jagielski</tablecell> 705*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 706*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3154798" xml-lang="en-US" l10n="U" oldref="142">Displays the options for the current field.</paragraph> 707*b1cdbd2cSJim Jagielski</tablecell> 708*b1cdbd2cSJim Jagielski</tablerow> 709*b1cdbd2cSJim Jagielski<tablerow> 710*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 711*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="hd_id3148418" xml-lang="en-US" l10n="U" oldref="141">Delete</paragraph> 712*b1cdbd2cSJim Jagielski</tablecell> 713*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 714*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id3159251" xml-lang="en-US" l10n="U" oldref="140">Removes the current field from the area.</paragraph> 715*b1cdbd2cSJim Jagielski</tablecell> 716*b1cdbd2cSJim Jagielski</tablerow> 717*b1cdbd2cSJim Jagielski</table> 718*b1cdbd2cSJim Jagielski</section> 719*b1cdbd2cSJim Jagielski<section id="relatedtopics"> 720*b1cdbd2cSJim Jagielski<embed href="text/scalc/guide/keyboard.xhp#keyboard"/> 721*b1cdbd2cSJim Jagielski<embed href="text/shared/guide/keyboard.xhp#keyboard"/> 722*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3150630" xml-lang="en-US" l10n="U" oldref="183"><link href="text/shared/04/01010000.xhp" name="shortcut keys in $[officename]">Shortcut keys in $[officename]</link></paragraph> 723*b1cdbd2cSJim Jagielski</section> 724*b1cdbd2cSJim Jagielski</body> 725*b1cdbd2cSJim Jagielski</helpdocument> 726