<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Shortcut Keys for Spreadsheets</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="fuzzysort.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="en-US/langnames.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body itemscope="true" itemtype="http://schema.org/TechArticle">
<div class="header-extrawurst">
<header><div class="logo-container"><a class="logo" href="en-US/text/shared/05/new_help.html"><div class="symbol"></div>
<p>LibreOffice 6.4 Help</p></a></div></header><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" onclick="setupModules('', 'en-US');">Module</button><nav id="modules-nav"></nav>
</div>
</div>
<aside class="rightside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1">Contents</label><div id="Contents" class="contents-treeview"></div></aside><aside class="leftside"><div id="Index">
<div class="index-label">Index 🔎︎ </div>
<div id="Bookmarks">
<input id="search-bar" type="text" class="search" placeholder="Search in chosen module"><nav class="index"></nav>
</div>
</div></aside><div id="DisplayArea" itemprop="articleBody">
<a name="starcalctasten"></a>
<a name="bm_id3145801"></a><meta itemprop="keywords" content="spreadsheets, shortcut keys in">
<meta itemprop="keywords" content="shortcut keys, spreadsheets">
<meta itemprop="keywords" content="sheet ranges, filling">
<h1 itemprop="articleSection" id="hd_id3145801">
<a name="calc_keys"></a>Shortcut Keys for Spreadsheets
</h1>
<div class="embedded">
<a name="keys"></a>
<div class="note">
<div class="noteicon"><img src="media/icon-themes/res/helpimg/note.svg" alt="Note Icon
" title="Note Icon
" style="width:40px;height:40px;"></div>
<div class="notetext"><p>Some of the shortcut keys may be assigned to your desktop system. Keys that are assigned to the desktop system are not available to LibreOffice. Try to assign different keys either for LibreOffice, in <span class="emph">Tools - Customize - Keyboard</span>, or in your desktop system.</p></div>
</div>
<br>
</div>
<p id="par_id3155067" class="paragraph">To fill a selected cell range with the formula that you entered on the <span class="emph">Input line</span>, press <span id="swlnsysidm19" class="switchinline"><span hidden="true" id="MACidm20" class="MAC">Option
</span><span hidden="true" id="defaultidm21">Alt</span></span>+Enter. Hold down <span id="swlnsysidm22" class="switchinline"><span hidden="true" id="MACidm23" class="MAC">Option
</span><span hidden="true" id="defaultidm24">Alt</span></span>+Enter+Shift to apply the cell format of the input cell to the entire cell range.</p>
<p id="par_id3153967" class="paragraph">To create a matrix in which all the cells contain the same information as what you entered on the <span class="emph">Input line</span>, press Shift+<span id="swlnsysidm27" class="switchinline"><span hidden="true" id="MACidm28" class="MAC">Command</span><span hidden="true" id="defaultidm29">Ctrl</span></span>+Enter. You cannot edit the components of the matrix.</p>
<p id="par_id3166426" class="paragraph">To select multiple cells in different areas of a sheet, hold down <span id="swlnsysidm31" class="switchinline"><span hidden="true" id="MACidm32" class="MAC">Command</span><span hidden="true" id="defaultidm33">Ctrl</span></span> and drag in the different areas.</p>
<p id="par_id3150207" class="paragraph">To select multiple sheets in a spreadsheet, hold down <span id="swlnsysidm35" class="switchinline"><span hidden="true" id="MACidm36" class="MAC">Command</span><span hidden="true" id="defaultidm37">Ctrl</span></span>, 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.</p>
<p id="par_id3166432" class="paragraph">To insert a manual line break in a cell, click in the cell, and then press <span id="swlnsysidm39" class="switchinline"><span hidden="true" id="MACidm40" class="MAC">Command</span><span hidden="true" id="defaultidm41">Ctrl</span></span>+Enter.</p>
<p id="par_id3146978" class="paragraph">To delete the contents of selected cells, press Backspace. This opens the <a target="_top" href="en-US/text/scalc/01/02150000.html">Delete Contents</a> 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 Delete key.</p>
<h2 itemprop="articleSection" id="hd_id3145386">Navigating in Spreadsheets</h2>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="" colspan="" class="tableheadcell">
<p id="hd_id3149407" class="tableheadintable">Shortcut Keys</p>
</td>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_id3153815" class="tableheadintable">
<span class="emph">Effect</span>
</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3146871" class="tablecontentintable"><span id="swlnsysidm55" class="switchinline"><span hidden="true" id="MACidm56" class="MAC">Command</span><span hidden="true" id="defaultidm57">Ctrl</span></span>+Home</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3159093" class="tablecontentintable">Moves the cursor to the first cell in the sheet (A1).</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3145073" class="tablecontentintable"><span id="swlnsysidm63" class="switchinline"><span hidden="true" id="MACidm64" class="MAC">Command</span><span hidden="true" id="defaultidm65">Ctrl</span></span>+End</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153283" class="tablecontentintable">Moves the cursor to the last cell on the sheet that contains data.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149127" class="tablecontentintable">Home</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3159205" class="tablecontentintable">Moves the cursor to the first cell of the current row.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149897" class="tablecontentintable">End</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155095" class="tablecontentintable">Moves the cursor to the last cell of the current row.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id4149127" class="tablecontentintable">Shift+Home</p>
</td>
<td rowspan="" colspan="">
<p id="par_id4159205" class="tablecontentintable">Selects cells from the current cell to the first cell of the current row.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id4149897" class="tablecontentintable">Shift+End</p>
</td>
<td rowspan="" colspan="">
<p id="par_id4155095" class="tablecontentintable">Selects cells from the current cell to the last cell of the current row.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id5149127" class="tablecontentintable">Shift+Page Up</p>
</td>
<td rowspan="" colspan="">
<p id="par_id5159205" class="tablecontentintable">Selects cells from the current cell up to one page in the current column or extends the existing selection one page up.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id5149897" class="tablecontentintable">Shift+Page Down</p>
</td>
<td rowspan="" colspan="">
<p id="par_id5155095" class="tablecontentintable">Selects cells from the current cell down to one page in the current column or extends the existing selection one page down.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id451550311052582" class="tablecontentintable">Shift+Space</p>
</td>
<td rowspan="" colspan="">
<p id="par_id971550311052582" class="tablecontentintable">Selects the current row or extends the existing selection to all respective rows.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id281550311052582" class="tablecontentintable"><span id="swlnsysidm106" class="switchinline"><span hidden="true" id="MACidm107" class="MAC">Command</span><span hidden="true" id="defaultidm108">Ctrl</span></span>+Space</p>
</td>
<td rowspan="" colspan="">
<p id="par_id261550311052582" class="tablecontentintable">Selects the current column or extends the existing selection to all respective columns.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id311550311052582" class="tablecontentintable"><span id="swlnsysidm114" class="switchinline"><span hidden="true" id="MACidm115" class="MAC">Command</span><span hidden="true" id="defaultidm116">Ctrl</span></span>+Shift+Space</p>
</td>
<td rowspan="" colspan="">
<p id="par_id851550311052582" class="tablecontentintable">Selects all cells in the sheet.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3143220" class="tablecontentintable"><span id="swlnsysidm122" class="switchinline"><span hidden="true" id="MACidm123" class="MAC">Command</span><span hidden="true" id="defaultidm124">Ctrl</span></span>+Left Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154766" class="tablecontentintable">Moves the cursor leftward to the start and end of cell blocks with data. If the cell to the left of the cursor is empty or the cell with cursor is empty, cursor moves leftward in row to the next cell with contents. If the row on the left of the cursor is empty, the cursor moves to then first cell in the row.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3153554" class="tablecontentintable"><span id="swlnsysidm130" class="switchinline"><span hidden="true" id="MACidm131" class="MAC">Command</span><span hidden="true" id="defaultidm132">Ctrl</span></span>+Right Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155593" class="tablecontentintable">Moves the cursor rightward to the start and end of cell blocks with contents. If the cell to the right of the cursor is empty or the cursor is in an empty cell, the cursor moves rightward to the next cell that contains data. If the row on the right of the cursor is empty, the cursor moves to the last cell in the row.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149317" class="tablecontentintable"><span id="swlnsysidm138" class="switchinline"><span hidden="true" id="MACidm139" class="MAC">Command</span><span hidden="true" id="defaultidm140">Ctrl</span></span>+Up Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153076" class="tablecontentintable">Moves the cursor upward to the start and end of cell blocks with data. If the cell above the cursor is empty or the cursor is in an empty cell, the cursor moves up to the end of next cell block with data. If the column above the cursor is empty, the cursor moves up to first cell in the column.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3147250" class="tablecontentintable"><span id="swlnsysidm146" class="switchinline"><span hidden="true" id="MACidm147" class="MAC">Command</span><span hidden="true" id="defaultidm148">Ctrl</span></span>+Down Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149054" class="tablecontentintable">Moves the cursor downward to the start and end of cell blocks with data. If the cell below the cursor is empty or the cursor is in an empty cell, the cursor moves down to the next cell that contains data. If the column below the cursor is empty, the cursor moves down to last cell in the column.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3148744" class="tablecontentintable"><span id="swlnsysidm154" class="switchinline"><span hidden="true" id="MACidm155" class="MAC">Command</span><span hidden="true" id="defaultidm156">Ctrl</span></span>+Shift+Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3159258" class="tablecontentintable">Selects all cells of the range created by the cursor movements using the Ctrl+Arrows key combinations. If used to select rows and columns together, a rectangular cell range is selected.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3156399" class="tablecontentintable"><span id="swlnsysidm162" class="switchinline"><span hidden="true" id="MACidm163" class="MAC">Command</span><span hidden="true" id="defaultidm164">Ctrl</span></span>+Page Up</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3145236" class="tablecontentintable">Moves one sheet to the left.</p>
<p id="par_id3149725" class="tablecontentintable">In the print preview: Moves to the previous print page.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3147411" class="tablecontentintable"><span id="swlnsysidm171" class="switchinline"><span hidden="true" id="MACidm172" class="MAC">Command</span><span hidden="true" id="defaultidm173">Ctrl</span></span>+Page Down</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150372" class="tablecontentintable">Moves one sheet to the right.</p>
<p id="par_id3159120" class="tablecontentintable">In the print preview: Moves to the next print page.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3146885" class="tablecontentintable"><span id="swlnsysidm180" class="switchinline"><span hidden="true" id="MACidm181" class="MAC">Option
</span><span hidden="true" id="defaultidm182">Alt</span></span>+Page Up</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3152976" class="tablecontentintable">Moves one screen to the left.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149013" class="tablecontentintable"><span id="swlnsysidm188" class="switchinline"><span hidden="true" id="MACidm189" class="MAC">Option
</span><span hidden="true" id="defaultidm190">Alt</span></span>+Page Down</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150477" class="tablecontentintable">Moves one screen page to the right.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN10AFC" class="tablecontentintable">Shift+<span id="swlnsysidm196" class="switchinline"><span hidden="true" id="MACidm197" class="MAC">Command</span><span hidden="true" id="defaultidm198">Ctrl</span></span>+Page Up</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN10B00" class="tablecontentintable">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.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN10B03" class="tablecontentintable">Shift+<span id="swlnsysidm204" class="switchinline"><span hidden="true" id="MACidm205" class="MAC">Command</span><span hidden="true" id="defaultidm206">Ctrl</span></span>+Page Down</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN10B07" class="tablecontentintable">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.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3145826" class="tablecontentintable"><span id="swlnsysidm212" class="switchinline"><span hidden="true" id="MACidm213" class="MAC">Command</span><span hidden="true" id="defaultidm214">Ctrl</span></span>+ *</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148882" class="tablecontentintable">where (*) is the multiplication sign on the numeric key pad</p>
<p id="par_id3154847" class="tablecontentintable">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.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3151233" class="tablecontentintable"><span id="swlnsysidm221" class="switchinline"><span hidden="true" id="MACidm222" class="MAC">Command</span><span hidden="true" id="defaultidm223">Ctrl</span></span>+ /</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149949" class="tablecontentintable">where (/) is the division sign on the numeric key pad</p>
<p id="par_id3150144" class="tablecontentintable">Selects the matrix formula range that contains the cursor.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id8163396" class="tablecontentintable"><span id="swlnsysidm230" class="switchinline"><span hidden="true" id="MACidm231" class="MAC">Command</span><span hidden="true" id="defaultidm232">Ctrl</span></span>+Plus key</p>
</td>
<td rowspan="" colspan="">
<p id="par_id9901425" class="tablecontentintable">Insert cells (as in menu Insert - Cells)</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3389080" class="tablecontentintable"><span id="swlnsysidm239" class="switchinline"><span hidden="true" id="MACidm240" class="MAC">Command</span><span hidden="true" id="defaultidm241">Ctrl</span></span>+Minus key</p>
</td>
<td rowspan="" colspan="">
<p id="par_id5104220" class="tablecontentintable">Delete cells (as in menu Edit - Delete Cells)</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3155825" class="tablecontentintable">Enter (in a selected range)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153935" class="tablecontentintable">Moves the cursor down one cell in a selected range. To specify the direction that the cursor moves, choose <span id="swlnsysidm250" class="switchinline"><span hidden="true" id="MACidm251" class="MAC"><span class="emph">LibreOffice - Preferences</span></span><span hidden="true" id="defaultidm253"><span class="emph">Tools - Options</span></span></span><span class="emph"> - LibreOffice Calc - General</span>.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id5961180" class="tablecontentintable"><span id="swlnsysidm259" class="switchinline"><span hidden="true" id="MACidm260" class="MAC">Command</span><span hidden="true" id="defaultidm261">Ctrl</span></span>+ ` (see note below this table)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id6407055" class="tablecontentintable">Displays or hides the formulas instead of the values in all cells.</p>
</td>
</tr>
</table>
<br>
<div class="note">
<div class="noteicon"><img src="media/icon-themes/res/helpimg/note.svg" alt="Note Icon
" title="Note Icon
" style="width:40px;height:40px;"></div>
<div class="notetext"><p>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.</p></div>
</div>
<br>
<h2 itemprop="articleSection" id="hd_id3148756">Function Keys Used in Spreadsheets</h2>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="" colspan="" class="tableheadcell">
<p id="hd_id3148581" class="tableheadintable">Shortcut Keys</p>
</td>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_id3152790" class="tableheadintable">
<span class="emph">Effect</span>
</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3154809" class="tablecontentintable"><span id="swlnsysidm277" class="switchinline"><span hidden="true" id="MACidm278" class="MAC">Command</span><span hidden="true" id="defaultidm279">Ctrl</span></span>+F1</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3145140" class="tablecontentintable">Displays the comment that is attached to the current cell</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3146142" class="tablecontentintable">F2</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148568" class="tablecontentintable">Switches to Edit mode and places the cursor at the end of the contents of the current cell. Press again to exit Edit mode.</p>
<p id="par_id3153108" class="tablecontentintable">If the cursor is in an input box in a dialog that has a <span class="emph">Minimize </span>button, the dialog is hidden and the input box remains visible. Press F2 again to show the whole dialog.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3146850" class="tablecontentintable"><span id="swlnsysidm292" class="switchinline"><span hidden="true" id="MACidm293" class="MAC">Command</span><span hidden="true" id="defaultidm294">Ctrl</span></span>+F2</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3145162" class="tablecontentintable">Opens the Function Wizard.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3147366" class="tablecontentintable">Shift+<span id="swlnsysidm300" class="switchinline"><span hidden="true" id="MACidm301" class="MAC">Command</span><span hidden="true" id="defaultidm302">Ctrl</span></span>+F2</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155929" class="tablecontentintable">Moves the cursor to the <span class="emph">Input line</span> where you can enter a formula for the current cell.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3153730" class="tablecontentintable"><span id="swlnsysidm309" class="switchinline"><span hidden="true" id="MACidm310" class="MAC">Command</span><span hidden="true" id="defaultidm311">Ctrl</span></span>+F3</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3145245" class="tablecontentintable">Opens the <span class="emph">Define Names</span> dialog.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3148768" class="tablecontentintable">Shift+<span id="swlnsysidm318" class="switchinline"><span hidden="true" id="MACidm319" class="MAC">Command</span><span hidden="true" id="defaultidm320">Ctrl</span></span>+F4</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153047" class="tablecontentintable">Shows or Hides the Database explorer.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3145353" class="tablecontentintable">F4</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155620" class="tablecontentintable">Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input field.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3156063" class="tablecontentintable">F5</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149540" class="tablecontentintable">Shows or hides the <span class="emph">Navigator</span>.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3148392" class="tablecontentintable">Shift+F5</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150268" class="tablecontentintable">Traces dependents.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3148430" class="tablecontentintable">Shift+F7</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153179" class="tablecontentintable">Traces precedents.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3150568" class="tablecontentintable">Shift+<span id="swlnsysidm347" class="switchinline"><span hidden="true" id="MACidm348" class="MAC">Command</span><span hidden="true" id="defaultidm349">Ctrl</span></span>+F5</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153551" class="tablecontentintable">Moves the cursor from the <span class="emph">Input line</span> to the <span class="emph">Sheet area</span> box. You can also use Shift+<span id="swlnsysidm354" class="switchinline"><span hidden="true" id="MACidm355" class="MAC">Command</span><span hidden="true" id="defaultidm356">Ctrl</span></span>+T.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3155368" class="tablecontentintable">F7</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154871" class="tablecontentintable">Checks spelling in the current sheet.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3150688" class="tablecontentintable"><span id="swlnsysidm365" class="switchinline"><span hidden="true" id="MACidm366" class="MAC">Command</span><span hidden="true" id="defaultidm367">Ctrl</span></span>+F7</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149781" class="tablecontentintable">Opens the Thesaurus if the current cell contains text.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3156257" class="tablecontentintable">F8</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3147482" class="tablecontentintable">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.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3154313" class="tablecontentintable"><span id="swlnsysidm378" class="switchinline"><span hidden="true" id="MACidm379" class="MAC">Command</span><span hidden="true" id="defaultidm380">Ctrl</span></span>+F8</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150385" class="tablecontentintable">Highlights cells containing values.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3152479" class="tablecontentintable">F9</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3163827" class="tablecontentintable">Recalculates changed formulas in the current sheet.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id9027069" class="tablecontentintable"><span id="swlnsysidm391" class="switchinline"><span hidden="true" id="MACidm392" class="MAC">Command</span><span hidden="true" id="defaultidm393">Ctrl</span></span>+Shift+F9</p>
</td>
<td rowspan="" colspan="">
<p id="par_id1729178" class="tablecontentintable">Recalculates all formulas in all sheets.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3156300" class="tablecontentintable"><span id="swlnsysidm399" class="switchinline"><span hidden="true" id="MACidm400" class="MAC">Command</span><span hidden="true" id="defaultidm401">Ctrl</span></span>+F9</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154817" class="tablecontentintable">Updates the selected chart.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149279" class="tablecontentintable"><span id="swlnsysidm407" class="switchinline"><span hidden="true" id="MACidm408" class="MAC">Command+T</span><span hidden="true" id="defaultidm409">F11</span></span></p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150967" class="tablecontentintable">Opens the <span class="emph">Styles</span> window where you can apply a formatting style to the contents of the cell or to the current sheet.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3156308" class="tablecontentintable">Shift+F11</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3145209" class="tablecontentintable">Creates a document template.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3147622" class="tablecontentintable">Shift<span id="swlnsysidm421" class="switchinline"><span hidden="true" id="MACidm422" class="MAC">+Command</span><span hidden="true" id="defaultidm423">+Ctrl</span></span>+F11</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153215" class="tablecontentintable">Updates the templates.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3150760" class="tablecontentintable">F12</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3156321" class="tablecontentintable">Groups the selected data range.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3146859" class="tablecontentintable"><span id="swlnsysidm434" class="switchinline"><span hidden="true" id="MACidm435" class="MAC">Command</span><span hidden="true" id="defaultidm436">Ctrl</span></span>+F12</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3156128" class="tablecontentintable">Ungroups the selected data range.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3151264" class="tablecontentintable"><span id="swlnsysidm442" class="switchinline"><span hidden="true" id="MACidm443" class="MAC">Option
</span><span hidden="true" id="defaultidm444">Alt</span></span>+Down Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153155" class="tablecontentintable">Increases the height of current row (only in <a target="_top" href="en-US/text/shared/optionen/01060800.html">OpenOffice.org legacy compatibility mode</a>).</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3151297" class="tablecontentintable"><span id="swlnsysidm451" class="switchinline"><span hidden="true" id="MACidm452" class="MAC">Option
</span><span hidden="true" id="defaultidm453">Alt</span></span>+Up Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155849" class="tablecontentintable">Decreases the height of current row (only in <a target="_top" href="en-US/text/shared/optionen/01060800.html">OpenOffice.org legacy compatibility mode</a>).</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3155997" class="tablecontentintable"><span id="swlnsysidm460" class="switchinline"><span hidden="true" id="MACidm461" class="MAC">Option
</span><span hidden="true" id="defaultidm462">Alt</span></span>+Right Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150256" class="tablecontentintable">Increases the width of the current column.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3154046" class="tablecontentintable"><span id="swlnsysidm468" class="switchinline"><span hidden="true" id="MACidm469" class="MAC">Option
</span><span hidden="true" id="defaultidm470">Alt</span></span>+Left Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150155" class="tablecontentintable">Decreases the width of the current column.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149293" class="tablecontentintable"><span id="swlnsysidm476" class="switchinline"><span hidden="true" id="MACidm477" class="MAC">Option</span><span hidden="true" id="defaultidm478">Alt</span></span>+Shift+Arrow Key</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3159180" class="tablecontentintable">Optimizes the column width or row height based on the current cell.</p>
</td>
</tr>
</table>
<br>
<h2 itemprop="articleSection" id="hd_id3156013">Formatting Cells Using Shortcut Keys</h2>
<p id="par_id3153979" class="paragraph">The following cell formats can be applied with the keyboard:</p>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="" colspan="" class="tableheadcell">
<p id="hd_id3147492" class="tableheadintable">Shortcut Keys</p>
</td>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_id3154305" class="tableheadintable">
<span class="emph">Effect</span>
</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3145669" class="tablecontentintable"><span id="swlnsysidm493" class="switchinline"><span hidden="true" id="MACidm494" class="MAC">Command</span><span hidden="true" id="defaultidm495">Ctrl</span></span>+1 (not on the number pad)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149197" class="tablecontentintable">Open Format Cells dialog</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3145668" class="tablecontentintable"><span id="swlnsysidm501" class="switchinline"><span hidden="true" id="MACidm502" class="MAC">Command</span><span hidden="true" id="defaultidm503">Ctrl</span></span>+Shift+1 (not on the number pad)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149196" class="tablecontentintable">Two decimal places, thousands separator</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3155331" class="tablecontentintable"><span id="swlnsysidm509" class="switchinline"><span hidden="true" id="MACidm510" class="MAC">Command</span><span hidden="true" id="defaultidm511">Ctrl</span></span>+Shift+2 (not on the number pad)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150120" class="tablecontentintable">Standard exponential format</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3154932" class="tablecontentintable"><span id="swlnsysidm517" class="switchinline"><span hidden="true" id="MACidm518" class="MAC">Command</span><span hidden="true" id="defaultidm519">Ctrl</span></span>+Shift+3 (not on the number pad)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148822" class="tablecontentintable">Standard date format</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3148829" class="tablecontentintable"><span id="swlnsysidm525" class="switchinline"><span hidden="true" id="MACidm526" class="MAC">Command</span><span hidden="true" id="defaultidm527">Ctrl</span></span>+Shift+4 (not on the number pad)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3159152" class="tablecontentintable">Standard currency format</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3150776" class="tablecontentintable"><span id="swlnsysidm533" class="switchinline"><span hidden="true" id="MACidm534" class="MAC">Command</span><span hidden="true" id="defaultidm535">Ctrl</span></span>+Shift+5 (not on the number pad)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148800" class="tablecontentintable">Standard percentage format (two decimal places)</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3158407" class="tablecontentintable"><span id="swlnsysidm541" class="switchinline"><span hidden="true" id="MACidm542" class="MAC">Command</span><span hidden="true" id="defaultidm543">Ctrl</span></span>+Shift+6 (not on the number pad)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148444" class="tablecontentintable">Standard format</p>
</td>
</tr>
</table>
<br>
<a name="datenpiloten"></a>
<h2 itemprop="articleSection" id="hd_id3154205">Using the pivot table</h2>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_idN11326" class="tableheadintable">Keys</p>
</td>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_idN1132C" class="tableheadintable">Effect</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3153577" class="tablecontentintable">Tab</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3147511" class="tablecontentintable">Changes the focus by moving forwards through the areas and buttons of the dialog.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3154266" class="tablecontentintable">Shift+Tab</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155362" class="tablecontentintable">Changes the focus by moving backwards through the areas and buttons of the dialog.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3148484" class="tablecontentintable">Up Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149152" class="tablecontentintable">Moves the focus up one item in the current dialog area.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3154273" class="tablecontentintable">Down Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3158424" class="tablecontentintable">Moves the focus down one item in the current dialog area.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3148912" class="tablecontentintable">Left Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153238" class="tablecontentintable">Moves the focus one item to the left in the current dialog area.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3150712" class="tablecontentintable">Right Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3166458" class="tablecontentintable">Moves the focus one item to the right in the current dialog area.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3146947" class="tablecontentintable">Home</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153742" class="tablecontentintable">Selects the first item in the current dialog area.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3153387" class="tablecontentintable">End</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153684" class="tablecontentintable">Selects the last item in the current dialog area.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3155584" class="tablecontentintable"><span id="swlnsysidm597" class="switchinline"><span hidden="true" id="MACidm598" class="MAC">Option</span><span hidden="true" id="defaultidm599">Alt</span></span> and the underlined character in the word "Row"</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3152949" class="tablecontentintable">Copies or moves the current field into the "Row" area.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3159269" class="tablecontentintable"><span id="swlnsysidm605" class="switchinline"><span hidden="true" id="MACidm606" class="MAC">Option</span><span hidden="true" id="defaultidm607">Alt</span></span> and the underlined character in the word "Column"</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149968" class="tablecontentintable">Copies or moves the current field into the "Column" area.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149923" class="tablecontentintable"><span id="swlnsysidm613" class="switchinline"><span hidden="true" id="MACidm614" class="MAC">Option</span><span hidden="true" id="defaultidm615">Alt</span></span> and the underlined character in the word "Data"</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148649" class="tablecontentintable">Copies or moves the current field into the "Data" area.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149418" class="tablecontentintable"><span id="swlnsysidm621" class="switchinline"><span hidden="true" id="MACidm622" class="MAC">Command</span><span hidden="true" id="defaultidm623">Ctrl</span></span>+Up Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154335" class="tablecontentintable">Moves the current field up one place.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3148462" class="tablecontentintable"><span id="swlnsysidm629" class="switchinline"><span hidden="true" id="MACidm630" class="MAC">Command</span><span hidden="true" id="defaultidm631">Ctrl</span></span>+Down Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154603" class="tablecontentintable">Moves the current field down one place.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3145373" class="tablecontentintable"><span id="swlnsysidm637" class="switchinline"><span hidden="true" id="MACidm638" class="MAC">Command</span><span hidden="true" id="defaultidm639">Ctrl</span></span>+Left Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3151125" class="tablecontentintable">Moves the current field one place to the left.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3150423" class="tablecontentintable"><span id="swlnsysidm645" class="switchinline"><span hidden="true" id="MACidm646" class="MAC">Command</span><span hidden="true" id="defaultidm647">Ctrl</span></span>+Right Arrow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153316" class="tablecontentintable">Moves the current field one place to the right.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149519" class="tablecontentintable"><span id="swlnsysidm653" class="switchinline"><span hidden="true" id="MACidm654" class="MAC">Command</span><span hidden="true" id="defaultidm655">Ctrl</span></span>+Home</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149237" class="tablecontentintable">Moves the current field to the first place.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3145310" class="tablecontentintable"><span id="swlnsysidm661" class="switchinline"><span hidden="true" id="MACidm662" class="MAC">Command</span><span hidden="true" id="defaultidm663">Ctrl</span></span>+End</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153942" class="tablecontentintable">Moves the current field to the last place.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3149933" class="tablecontentintable"><span id="swlnsysidm669" class="switchinline"><span hidden="true" id="MACidm670" class="MAC">Option</span><span hidden="true" id="defaultidm671">Alt</span></span>+O</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154798" class="tablecontentintable">Displays the options for the current field.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="hd_id3148418" class="tablecontentintable">Delete</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3159251" class="tablecontentintable">Removes the current field from the area.</p>
</td>
</tr>
</table>
<br>
<a name="relatedtopics"></a><div class="relatedtopics">
<p class="related" itemprop="mentions"><a name="related"></a><span class="emph">Related Topics</span>
</p>
<div class="relatedbody" itemprop="mentions">
<div class="embedded"><p class="embedded"><a name="keyboard"></a><a target="_top" href="en-US/text/scalc/guide/keyboard.html">Shortcut Keys (<span class="productname">LibreOffice</span> Calc Accessibility)</a>
</p></div>
<div class="embedded"><p class="embedded"><a name="keyboard"></a><a target="_top" href="en-US/text/shared/guide/keyboard.html">Shortcuts (<span class="productname">LibreOffice</span> Accessibility)</a>
</p></div>
<p id="par_id3150630" class="paragraph"><a target="_top" href="en-US/text/shared/04/01010000.html">Shortcut keys in LibreOffice</a></p>
</div>
</div>
</div>
<div class="search-frame"></div>
<div class="donation-frame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p>This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/scalc/04/01020000.xhp" target="_blank">/text/scalc/04/01020000.xhp</a></p>
<p>Title is: Shortcut Keys for Spreadsheets</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>