<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert Cells</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="zelleneinfuegen"></a>
<a name="bm_id3150275"></a><meta itemprop="keywords" content="inserting, cells, toolbar icon">
<a name="bm_id3156329"></a>
<h1 itemprop="articleSection" id="hd_id3150275">Insert Cells</h1>
<p id="par_id3156024" class="paragraph"><span class="avis">Click the arrow next to the icon to open the <span class="emph">Insert Cells </span>toolbar, where you can insert cells, rows, and columns into the current sheet.</span></p>
<p id="par_id3150398" class="paragraph">Tools bar icon:</p>
<div class="embedded">
<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>
</div>
<p id="par_id3150767" class="paragraph">You can select the following icons:</p>
<h2 itemprop="articleSection" id="hd_id3150439"><a target="_top" href="en-US/text/scalc/01/04020000.html">Insert Cells Down</a></h2>
<div class="embedded"><p class="embedded"><a name="zellenuntentext"></a>Moves the contents of the selected range downward when cells are inserted.
</p></div>
<div class="embedded">
<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>
</div>
<h2 itemprop="articleSection" id="hd_id3146119"><a target="_top" href="en-US/text/scalc/01/04020000.html">Insert Cells Right</a></h2>
<div class="embedded"><p class="embedded"><a name="zellenrechtstext"></a>Moves the contents of the selected range to the right when cells are inserted.
</p></div>
<div class="embedded">
<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>
</div>
<h2 itemprop="articleSection" id="hd_id3153190"><a target="_top" href="en-US/text/scalc/01/04020000.html">Rows</a></h2>
<div class="embedded"><p class="embedded"><a name="zeilenganzetext"></a>Inserts an entire row. The position of the row is determined by the selection on the sheet.
</p></div>
<div class="embedded">
<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>
</div>
<h2 itemprop="articleSection" id="hd_id3153726"><a target="_top" href="en-US/text/scalc/01/04020000.html">Columns</a></h2>
<div class="embedded"><p class="embedded"><a name="spaltenganzetext"></a>Inserts an entire column. The number of columns to be inserted is determined by the selected number of columns.
</p></div>
<div class="embedded">
<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>
</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/02/18020000.xhp" target="_blank">/text/scalc/02/18020000.xhp</a></p>
<p>Title is: Insert Cells</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>