<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert 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_id3149346">Insert Menu</h1>
<a name="eize"></a>
<p id="par_id3149784" class="paragraph">Choose <span class="emph">Sheet - Insert Cells</span>.</p>
<p id="par_id3154514" class="paragraph">Choose <span class="emph">View - Toolbars</span> and select <span class="emph">Insert Cells</span> toolbar:</p>
<a name="syzelleneinfuegen"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3149656" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_inserttable.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3151041" class="paragraphintable">Insert Cells</p>
</div>
</div>
<a name="syzellenunten"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3145273" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_insertcellsdown.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3146985" class="paragraphintable">Insert Cells Down</p>
</div>
</div>
<a name="syzellenrechts"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3144766" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_insertcellsright.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3145646" class="paragraphintable">Insert Cells Right</p>
</div>
</div>
<a name="syzeilenganze"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3153838" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_insertrows.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3150324" class="paragraphintable">Insert Rows</p>
</div>
</div>
<a name="syspaltenganze"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3147363" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_insertcolumns.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3155334" class="paragraphintable">Insert Columns</p>
</div>
</div>
<p id="par_id3149033" class="paragraph"><a name="eitab"></a>Choose <span class="emph">Sheet - Insert Sheet</span>.</p>
<p id="par_idN1082F" class="paragraph"><a name="eitabfile"></a>Choose <span class="emph">Sheet - Insert Sheet from File</span>.</p>
<a name="eifu"></a>
<p id="par_id3155115" class="paragraph">Choose <span class="emph">Insert - Function</span>.</p>
<p id="par_id3152582" class="paragraph"><span id="swlnsysidm71" class="switchinline"><span hidden="true" id="MACidm72" class="MAC">Command</span><span hidden="true" id="defaultidm73">Ctrl</span></span>+F2</p>
<p id="par_id3153269" class="paragraph">On <span class="emph">Formula Bar</span>, click</p>
<a name="syfunktionsautopilot"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3150515" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_dbviewfunctions.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3154370" class="paragraphintable">Function Wizard</p>
</div>
</div>
<p id="par_id3156288" class="paragraph"><a name="eikada"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Database</span>
</p>
<p id="par_id3155809" class="paragraph"><a name="eikadaze"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Date & Time</span>
</p>
<p id="par_id3151334" class="paragraph"><a name="eikafi"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Financial</span>
</p>
<p id="par_id3159222" class="paragraph"><a name="eikain"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Information</span>
</p>
<p id="par_id3159173" class="paragraph"><a name="eikalo"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Logical</span>
</p>
<p id="par_id3153914" class="paragraph"><a name="eikama"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Mathematical</span>
</p>
<p id="par_id3150109" class="paragraph"><a name="eikamatrix"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Array</span>
</p>
<p id="par_id3157978" class="paragraph"><a name="eikasta"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Statistical</span>
</p>
<p id="par_id3156016" class="paragraph"><a name="eikatext"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Text</span>
</p>
<p id="par_id3147075" class="paragraph"><a name="efefft"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Spreadsheet</span>
</p>
<p id="par_id3154618" class="paragraph"><a name="addin"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Add-In</span>
</p>
<p id="par_id3154059" class="paragraph"><a name="addinana"></a><span class="emph">Insert - Function</span> - Category <span class="emph">Add-In</span>
</p>
<p id="par_id3155383" class="paragraph"><a name="funktionsliste"></a>Choose <span class="emph">Insert - Function List</span>.</p>
<p id="par_id3153250" class="paragraph"><a name="einamen"></a>Choose <span class="emph">Insert - Named Range or Expression</span>.</p>
<p id="par_id3146776" class="paragraph"><a name="eiextdata"></a>Choose <span class="emph">Sheet - Link to External data</span>.</p>
<a name="einafe"></a>
<p id="par_id3143222" class="paragraph">Choose <span class="emph">Sheet - Named Ranges and Expressions - Define</span>.</p>
<p id="par_id3149385" class="paragraph"><span id="swlnsysidm146" class="switchinline"><span hidden="true" id="MACidm147" class="MAC">Command</span><span hidden="true" id="defaultidm148">Ctrl</span></span>+F3</p>
<p id="par_id3145214" class="paragraph"><a name="einaei"></a>Choose <span class="emph">Sheet - Named Ranges and Expressions - Insert</span>.</p>
<p id="par_id3153558" class="paragraph"><a name="einaueb"></a>Choose <span class="emph">Sheet - Named Ranges and Expressions - Create</span>.</p>
<p id="par_id3153483" class="paragraph"><a name="einabesch"></a>Choose <span class="emph">Sheet - Named Ranges and Expressions - Labels</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/00000404.xhp" target="_blank">/text/scalc/00/00000404.xhp</a></p>
<p>Title is: Insert Menu</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>