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&amp;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