<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<meta>
<topic id="textscalc0104030000xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Insert Rows</title>
<filename>/text/scalc/01/04030000.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150541">
<bookmark_value>spreadsheets; inserting rows</bookmark_value>
<bookmark_value>rows; inserting</bookmark_value>
<bookmark_value>inserting; rows</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:InsertRowsBefore" id="bm_id4302477" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:InsertRowsBefore" id="bm_id3154366" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:InsertRowsAfter" id="bm_id4302477" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:InsertRowsAfter" id="bm_id3154366" localize="false"/>
<paragraph id="hd_id3150541" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/04030000.xhp" name="Insert Rows">Insert Rows</link></paragraph>
<paragraph id="par_id160220162210581072" role="paragraph" xml-lang="en-US"><variable id="sheet_insert_rows">Insert rows above or below the active cell.</variable> The number of rows inserted corresponds to the number of rows selected. If no row is selected, one row is inserted. The existing rows are moved downward.</paragraph>
<paragraph id="hd_id160220162131439740" role="heading" level="2" xml-lang="en-US">Rows Above</paragraph>
<paragraph id="par_id3150767" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertRowsBefore">Inserts a new row above the active cell.</ahelp></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/sheet_menu.xhp#insert_rows_above"/>
</section>
<paragraph id="hd_id160220162133372726" role="heading" level="2" xml-lang="en-US">Rows Below</paragraph>
<paragraph id="par_id3150768" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertRowsAfter">Inserts a new row below the active cell.</ahelp></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/sheet_menu.xhp#insert_rows_below"/>
</section>
</body>
</helpdocument>