1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file 9 * to you under the Apache License, Version 2.0 (the 10 * "License"); you may not use this file except in compliance 11 * with the License. You may obtain a copy of the License at 12 * 13 * http://www.apache.org/licenses/LICENSE-2.0 14 * 15 * Unless required by applicable law or agreed to in writing, 16 * software distributed under the License is distributed on an 17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18 * KIND, either express or implied. See the License for the 19 * specific language governing permissions and limitations 20 * under the License. 21 * 22 ***********************************************************--> 23 24<helpdocument version="1.0"> 25<meta> 26<topic id="textscalc0000000404xml" indexer="exclude" status="PUBLISH"> 27<title id="tit" xml-lang="en-US">Insert Menu</title> 28<filename>/text/scalc/00/00000404.xhp</filename> 29</topic> 30</meta> 31<body> 32<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="1" l10n="U" oldref="1">Insert Menu</paragraph> 33<paragraph role="paragraph" id="par_id3149095" xml-lang="en-US" l10n="U" oldref="36"><variable id="eimaum">Choose <emph>Insert - Manual Break</emph> 34</variable></paragraph> 35<paragraph role="paragraph" id="par_id3149398" xml-lang="en-US" l10n="U" oldref="2"><variable id="eimaumze">Choose <emph>Insert - Manual Break - Row Break</emph> 36</variable></paragraph> 37<paragraph role="paragraph" id="par_id3150084" xml-lang="en-US" l10n="U" oldref="3"><variable id="eimaumsp">Choose <emph>Insert - Manual Break - Column Break</emph> 38</variable></paragraph> 39<section id="eize"> 40<paragraph role="paragraph" id="par_id3149784" xml-lang="en-US" l10n="U" oldref="4">Choose <emph>Insert - Cells</emph> 41</paragraph> 42<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US" l10n="U" oldref="5">Open <emph>Insert Cells</emph> toolbar from Tools bar:</paragraph> 43<section id="syzelleneinfuegen"> 44<table id="tbl_id3148550"> 45<tablerow> 46<tablecell colspan="" rowspan=""> 47<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US" l10n="E"> 48<image id="img_id3154365" src="res/commandimagelist/sc_inscellsctrl.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154365" xml-lang="en-US">Icon</alt> 49</image></paragraph> 50</tablecell> 51<tablecell colspan="" rowspan=""> 52<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US" l10n="U" oldref="6">Insert Cells</paragraph> 53</tablecell> 54</tablerow> 55</table> 56</section> 57</section> 58<section id="syzellenunten"> 59<table id="tbl_id3159486"> 60<tablerow> 61<tablecell colspan="" rowspan=""> 62<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="E"> 63<image id="img_id3145364" src="res/commandimagelist/sc_insertcellsdown.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145364" xml-lang="en-US">Icon</alt> 64</image></paragraph> 65</tablecell> 66<tablecell colspan="" rowspan=""> 67<paragraph role="paragraph" id="par_id3146985" xml-lang="en-US" l10n="U" oldref="7">Insert Cells Down</paragraph> 68</tablecell> 69</tablerow> 70</table> 71</section> 72<section id="syzellenrechts"> 73<table id="tbl_id3148575"> 74<tablerow> 75<tablecell colspan="" rowspan=""> 76<paragraph role="paragraph" id="par_id3144766" xml-lang="en-US" l10n="E"> 77<image id="img_id3154942" src="res/commandimagelist/sc_insertcellsright.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154942" xml-lang="en-US">Icon</alt> 78</image></paragraph> 79</tablecell> 80<tablecell colspan="" rowspan=""> 81<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US" l10n="U" oldref="8">Insert Cells Right</paragraph> 82</tablecell> 83</tablerow> 84</table> 85</section> 86<section id="syzeilenganze"> 87<table id="tbl_id3154015"> 88<tablerow> 89<tablecell colspan="" rowspan=""> 90<paragraph role="paragraph" id="par_id3153838" xml-lang="en-US" l10n="E"> 91<image id="img_id3153710" src="res/commandimagelist/sc_insertrows.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153710" xml-lang="en-US">Icon</alt> 92</image></paragraph> 93</tablecell> 94<tablecell colspan="" rowspan=""> 95<paragraph role="paragraph" id="par_id3150324" xml-lang="en-US" l10n="U" oldref="9">Insert Rows</paragraph> 96</tablecell> 97</tablerow> 98</table> 99</section> 100<section id="syspaltenganze"> 101<table id="tbl_id3147338"> 102<tablerow> 103<tablecell colspan="" rowspan=""> 104<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US" l10n="E"> 105<image id="img_id3145232" src="res/commandimagelist/sc_insertcolumns.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145232" xml-lang="en-US">Icon</alt> 106</image></paragraph> 107</tablecell> 108<tablecell colspan="" rowspan=""> 109<paragraph role="paragraph" id="par_id3155334" xml-lang="en-US" l10n="U" oldref="10">Insert Columns</paragraph> 110</tablecell> 111</tablerow> 112</table> 113</section> 114<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="U" oldref="11"><variable id="eizei">Choose <emph>Insert - Rows</emph> 115</variable></paragraph> 116<paragraph role="paragraph" id="par_id3153200" xml-lang="en-US" l10n="U" oldref="12"><variable id="eispa">Choose <emph>Insert - Columns</emph> 117</variable></paragraph> 118<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US" l10n="U" oldref="13"><variable id="eitab">Choose <emph>Insert - Sheet</emph> 119</variable></paragraph> 120<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US" l10n="NEW"><variable id="eitabfile">Choose <emph>Insert - Sheet from file</emph> 121</variable></paragraph> 122<section id="eifu"> 123<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US" l10n="U" oldref="14">Choose <emph>Insert - Function</emph> 124</paragraph> 125<paragraph role="paragraph" id="par_id3152582" xml-lang="en-US" l10n="U" oldref="34"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph> 126<paragraph role="paragraph" id="par_id3153269" xml-lang="en-US" l10n="U" oldref="15">On <emph>Formula Bar</emph>, click</paragraph> 127<section id="syfunktionsautopilot"> 128<table id="tbl_id3145258"> 129<tablerow> 130<tablecell colspan="" rowspan=""> 131<paragraph role="paragraph" id="par_id3150515" xml-lang="en-US" l10n="E"> 132<image id="img_id3150884" src="sw/imglst/sc20556.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150884" xml-lang="en-US">Icon</alt> 133</image></paragraph> 134</tablecell> 135<tablecell colspan="" rowspan=""> 136<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US" l10n="CHG" oldref="16">Function Wizard</paragraph> 137</tablecell> 138</tablerow> 139</table> 140</section> 141</section> 142<paragraph role="paragraph" id="par_id3156288" xml-lang="en-US" l10n="CHG" oldref="17"><variable id="eikada"><emph>Insert - Function</emph> - Category <emph>Database</emph> 143</variable></paragraph> 144<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US" l10n="CHG" oldref="18"><variable id="eikadaze"><emph>Insert - Function</emph> - Category <emph>Date&Time</emph> 145</variable></paragraph> 146<paragraph role="paragraph" id="par_id3151334" xml-lang="en-US" l10n="CHG" oldref="19"><variable id="eikafi"><emph>Insert - Function</emph> - Category <emph>Financial</emph> 147</variable></paragraph> 148<paragraph role="paragraph" id="par_id3159222" xml-lang="en-US" l10n="CHG" oldref="20"><variable id="eikain"><emph>Insert - Function</emph> - Category <emph>Information</emph> 149</variable></paragraph> 150<paragraph role="paragraph" id="par_id3159173" xml-lang="en-US" l10n="CHG" oldref="21"><variable id="eikalo"><emph>Insert - Function</emph> - Category <emph>Logical</emph> 151</variable></paragraph> 152<paragraph role="paragraph" id="par_id3153914" xml-lang="en-US" l10n="CHG" oldref="22"><variable id="eikama"><emph>Insert - Function</emph> - Category <emph>Mathematical</emph> 153</variable></paragraph> 154<paragraph role="paragraph" id="par_id3150109" xml-lang="en-US" l10n="CHG" oldref="23"><variable id="eikamatrix"><emph>Insert - Function</emph> - Category <emph>Array</emph> 155</variable></paragraph> 156<paragraph role="paragraph" id="par_id3157978" xml-lang="en-US" l10n="CHG" oldref="24"><variable id="eikasta"><emph>Insert - Function</emph> - Category <emph>Statistical</emph> 157</variable></paragraph> 158<paragraph role="paragraph" id="par_id3156016" xml-lang="en-US" l10n="CHG" oldref="25"><variable id="eikatext"><emph>Insert - Function</emph> - Category <emph>Text</emph> 159</variable></paragraph> 160<paragraph role="paragraph" id="par_id3147075" xml-lang="en-US" l10n="U" oldref="26"><variable id="efefft"><emph>Insert - Function</emph> - Category <emph>Spreadsheet</emph> 161</variable></paragraph> 162<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US" l10n="CHG" oldref="27"><variable id="addin"><emph>Insert - Function</emph> - Category <emph>Add-In</emph> 163</variable></paragraph> 164<paragraph role="paragraph" id="par_id3154059" xml-lang="en-US" l10n="CHG" oldref="38"><variable id="addinana"><emph>Insert - Function</emph> - Category <emph>Add-In</emph> 165</variable></paragraph> 166<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U" oldref="33"><variable id="funktionsliste">Choose <emph>Insert - Function List</emph> 167</variable></paragraph> 168<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US" l10n="U" oldref="28"><variable id="einamen">Choose <emph>Insert - Names</emph> 169</variable></paragraph> 170<paragraph role="paragraph" id="par_id3146776" xml-lang="en-US" l10n="CHG" oldref="37"><variable id="eiextdata">Choose <emph>Insert - Link to External data</emph> 171</variable></paragraph> 172<section id="einafe"> 173<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="29">Choose <emph>Insert - Names - Define</emph> 174</paragraph> 175<paragraph role="paragraph" id="par_id3149385" xml-lang="en-US" l10n="U" oldref="35"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph> 176</section> 177<paragraph role="paragraph" id="par_id3145214" xml-lang="en-US" l10n="U" oldref="30"><variable id="einaei">Choose <emph>Insert - Names - Insert</emph> 178</variable></paragraph> 179<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US" l10n="U" oldref="31"><variable id="einaueb">Choose <emph>Insert - Names - Create</emph> 180</variable></paragraph> 181<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US" l10n="U" oldref="32"><variable id="einabesch">Choose <emph>Insert - Names - Labels</emph> 182</variable></paragraph> 183</body> 184</helpdocument> 185
