<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Tools Menu</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">
<h1 itemprop="articleSection" id="hd_id3147264">Tools Menu</h1>
<p id="par_id3150541" class="paragraph"><a name="exdektv"></a>Choose <span class="emph">Tools - Detective</span>.</p>
<a name="exdszv"></a>
<p id="par_id3153194" class="paragraph">Choose <span class="emph">Tools - Detective - Trace Precedents</span>.</p>
<p id="par_id3150447" class="paragraph">Shift+F7</p>
<p id="par_id3154123" class="paragraph"><a name="silbentrennungc"></a>Menu <span class="emph">Tools - Language - Hyphenation</span>.</p>
<p id="par_id3145785" class="paragraph"><a name="exdvore"></a>Choose <span class="emph">Tools - Detective - Remove Precedents</span>.</p>
<a name="exdsznf"></a>
<p id="par_id3155411" class="paragraph">Choose <span class="emph">Tools - Detective - Trace Dependents</span>.</p>
<p id="par_id3153363" class="paragraph">Shift+F5</p>
<p id="par_id3146984" class="paragraph"><a name="exdszne"></a>Choose <span class="emph">Tools - Detective - Remove Dependents</span>.</p>
<p id="par_id3154014" class="paragraph"><a name="exdase"></a>Choose <span class="emph">Tools - Detective - Remove All Traces</span>.</p>
<p id="par_id3153188" class="paragraph"><a name="exdszfe"></a>Choose <span class="emph">Tools - Detective - Trace Error</span>.</p>
<p id="par_id3149410" class="paragraph"><a name="fuellmodus"></a>Choose <span class="emph">Tools - Detective - Fill Mode</span>.</p>
<p id="par_id3156284" class="paragraph"><a name="dateneinkreisen"></a>Choose <span class="emph">Tools - Detective - Mark Invalid Data</span>.</p>
<p id="par_id3153159" class="paragraph"><a name="spurenaktualisieren"></a>Choose <span class="emph">Tools - Detective - Refresh Traces</span>.</p>
<p id="par_id3147397" class="paragraph"><a name="automatisch"></a>Choose <span class="emph">Tools - Detective - AutoRefresh</span>.</p>
<p id="par_id3154018" class="paragraph"><a name="exzws"></a>Choose <span class="emph">Tools - Goal Seek</span>.</p>
<p id="par_id3269142" class="paragraph"><a name="solver"></a>Choose <span class="emph">Tools - Solver</span>.</p>
<p id="par_id8554338" class="paragraph"><a name="solver_options"></a>Choose <span class="emph">Tools - Solver</span>, click <span class="emph">Options</span> button.</p>
<p id="par_id3156277" class="paragraph"><a name="exsze"></a>Choose <span class="emph">Tools - Scenarios</span>.</p>
<p id="par_id3149020" class="paragraph"><a name="protect_sheet"></a>Choose <span class="emph">Tools - Protect Sheet</span>.</p>
<p id="par_id3154256" class="paragraph"><a name="protect_spreadsheet"></a>Choose <span class="emph">Tools - Protect Spreadsheet Structure</span>.</p>
<a name="exnb"></a>
<p id="par_id3146919" class="paragraph">Choose <span class="emph">Data - Calculate - Recalculate</span>.</p>
<p id="par_id3149257" class="paragraph">F9</p>
<a name="exnbr"></a>
<p id="par_id3146919a" class="paragraph">Choose <span id="swlnsysidm71" class="switchinline"><span hidden="true" id="MACidm72" class="MAC"><span class="emph">LibreOffice - Preferences</span></span><span hidden="true" id="defaultidm74"><span class="emph">Tools - Options</span></span></span><span class="emph"> - LibreOffice Calc - Formula</span>.</p>
<p id="par_id3150941" class="paragraph"><a name="exatmb"></a>Choose <span class="emph">Data - Calculate - AutoCalculate</span>.</p>
<p id="par_id3151276" class="paragraph"><a name="autoeingabe"></a>Choose <span class="emph">Tools - AutoInput</span>.</p>
</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/00/00000406.xhp" target="_blank">/text/scalc/00/00000406.xhp</a></p>
<p>Title is: Tools Menu</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>