1<?xml version="1.0" encoding="UTF-8"?> 2 3 4<!--*********************************************************** 5 * 6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information 9 * regarding copyright ownership. The ASF licenses this file 10 * to you under the Apache License, Version 2.0 (the 11 * "License"); you may not use this file except in compliance 12 * with the License. You may obtain a copy of the License at 13 * 14 * http://www.apache.org/licenses/LICENSE-2.0 15 * 16 * Unless required by applicable law or agreed to in writing, 17 * software distributed under the License is distributed on an 18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19 * KIND, either express or implied. See the License for the 20 * specific language governing permissions and limitations 21 * under the License. 22 * 23 ***********************************************************--> 24 25 26 27 28 29<helpdocument version="1.0"> 30<meta> 31<topic id="textscalc0000000404xml" indexer="exclude" status="PUBLISH"> 32<title id="tit" xml-lang="en-US">Insert Menu</title> 33<filename>/text/scalc/00/00000404.xhp</filename> 34</topic> 35<history> 36<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 37<lastedited date="2005-11-10T14:06:38">converted from old format - fpe</lastedited> 38</history> 39</meta> 40<body> 41<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="1" l10n="U" oldref="1">Insert Menu</paragraph> 42<paragraph role="paragraph" id="par_id3149095" xml-lang="en-US" l10n="U" oldref="36"><variable id="eimaum">Choose <emph>Insert - Manual Break</emph> 43</variable></paragraph> 44<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> 45</variable></paragraph> 46<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> 47</variable></paragraph> 48<section id="eize"> 49<paragraph role="paragraph" id="par_id3149784" xml-lang="en-US" l10n="U" oldref="4">Choose <emph>Insert - Cells</emph> 50</paragraph> 51<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US" l10n="U" oldref="5">Open <emph>Insert Cells</emph> toolbar from Tools bar:</paragraph> 52<section id="syzelleneinfuegen"> 53<table id="tbl_id3148550"> 54<tablerow> 55<tablecell colspan="" rowspan=""> 56<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US" l10n="E"> 57<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> 58 </image></paragraph> 59</tablecell> 60<tablecell colspan="" rowspan=""> 61<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US" l10n="U" oldref="6">Insert Cells</paragraph> 62</tablecell> 63</tablerow> 64</table> 65 66</section> 67</section> 68<section id="syzellenunten"> 69<table id="tbl_id3159486"> 70<tablerow> 71<tablecell colspan="" rowspan=""> 72<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="E"> 73<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> 74 </image></paragraph> 75</tablecell> 76<tablecell colspan="" rowspan=""> 77<paragraph role="paragraph" id="par_id3146985" xml-lang="en-US" l10n="U" oldref="7">Insert Cells Down</paragraph> 78</tablecell> 79</tablerow> 80</table> 81 82</section> 83<section id="syzellenrechts"> 84<table id="tbl_id3148575"> 85<tablerow> 86<tablecell colspan="" rowspan=""> 87<paragraph role="paragraph" id="par_id3144766" xml-lang="en-US" l10n="E"> 88<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> 89 </image></paragraph> 90</tablecell> 91<tablecell colspan="" rowspan=""> 92<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US" l10n="U" oldref="8">Insert Cells Right</paragraph> 93</tablecell> 94</tablerow> 95</table> 96 97</section> 98<section id="syzeilenganze"> 99<table id="tbl_id3154015"> 100<tablerow> 101<tablecell colspan="" rowspan=""> 102<paragraph role="paragraph" id="par_id3153838" xml-lang="en-US" l10n="E"> 103<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> 104 </image></paragraph> 105</tablecell> 106<tablecell colspan="" rowspan=""> 107<paragraph role="paragraph" id="par_id3150324" xml-lang="en-US" l10n="U" oldref="9">Insert Rows</paragraph> 108</tablecell> 109</tablerow> 110</table> 111 112</section> 113<section id="syspaltenganze"> 114<table id="tbl_id3147338"> 115<tablerow> 116<tablecell colspan="" rowspan=""> 117<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US" l10n="E"> 118<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> 119 </image></paragraph> 120</tablecell> 121<tablecell colspan="" rowspan=""> 122<paragraph role="paragraph" id="par_id3155334" xml-lang="en-US" l10n="U" oldref="10">Insert Columns</paragraph> 123</tablecell> 124</tablerow> 125</table> 126 127</section> 128<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="U" oldref="11"><variable id="eizei">Choose <emph>Insert - Rows</emph> 129</variable></paragraph> 130<paragraph role="paragraph" id="par_id3153200" xml-lang="en-US" l10n="U" oldref="12"><variable id="eispa">Choose <emph>Insert - Columns</emph> 131</variable></paragraph> 132<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US" l10n="U" oldref="13"><variable id="eitab">Choose <emph>Insert - Sheet</emph> 133</variable></paragraph> 134<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US" l10n="NEW"><variable id="eitabfile">Choose <emph>Insert - Sheet from file</emph> 135</variable></paragraph> 136<section id="eifu"> 137<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US" l10n="U" oldref="14">Choose <emph>Insert - Function</emph> 138</paragraph> 139<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> 140<paragraph role="paragraph" id="par_id3153269" xml-lang="en-US" l10n="U" oldref="15">On <emph>Formula Bar</emph>, click</paragraph> 141<section id="syfunktionsautopilot"> 142<table id="tbl_id3145258"> 143<tablerow> 144<tablecell colspan="" rowspan=""> 145<paragraph role="paragraph" id="par_id3150515" xml-lang="en-US" l10n="E"> 146<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> 147 </image></paragraph> 148</tablecell> 149<tablecell colspan="" rowspan=""> 150<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US" l10n="CHG" oldref="16">Function Wizard</paragraph> 151</tablecell> 152</tablerow> 153</table> 154 155</section> 156</section> 157<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> 158</variable></paragraph> 159<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> 160</variable></paragraph> 161<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> 162</variable></paragraph> 163<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> 164</variable></paragraph> 165<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> 166</variable></paragraph> 167<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> 168</variable></paragraph> 169<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> 170</variable></paragraph> 171<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> 172</variable></paragraph> 173<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> 174</variable></paragraph> 175<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> 176</variable></paragraph> 177<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> 178</variable></paragraph> 179<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> 180</variable></paragraph> 181<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U" oldref="33"><variable id="funktionsliste">Choose <emph>Insert - Function List</emph> 182</variable></paragraph> 183<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US" l10n="U" oldref="28"><variable id="einamen">Choose <emph>Insert - Names</emph> 184</variable></paragraph> 185<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> 186</variable></paragraph> 187<section id="einafe"> 188<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="29">Choose <emph>Insert - Names - Define</emph> 189</paragraph> 190<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> 191</section> 192<paragraph role="paragraph" id="par_id3145214" xml-lang="en-US" l10n="U" oldref="30"><variable id="einaei">Choose <emph>Insert - Names - Insert</emph> 193</variable></paragraph> 194<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US" l10n="U" oldref="31"><variable id="einaueb">Choose <emph>Insert - Names - Create</emph> 195</variable></paragraph> 196<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US" l10n="U" oldref="32"><variable id="einabesch">Choose <emph>Insert - Names - Labels</emph> 197</variable></paragraph> 198</body> 199</helpdocument> 200