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