blob: 20865323072748e40b8b5b6590d90ef6ac97bc84 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
<?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="textscalcguidecell_enterxml" indexer="include" status="PUBLISH">
<title xml-lang="en-US" id="tit">Entering Values</title>
<filename>/text/scalc/guide/cell_enter.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150868"><bookmark_value>values; inserting in multiple cells</bookmark_value>
<bookmark_value>inserting;values</bookmark_value>
<bookmark_value>cell ranges;selecting for data entries</bookmark_value>
<bookmark_value>areas, see also cell ranges</bookmark_value>
</bookmark>
<h1 id="hd_id3405255"><variable id="cell_enter"><link href="text/scalc/guide/cell_enter.xhp">Entering Values</link>
</variable></h1>
<paragraph xml-lang="en-US" id="par_id7147129" role="paragraph">Calc can simplify entering data and values into multiple cells. You can change some settings to conform to your preferences.</paragraph>
<h2 id="hd_id5621509">To Enter Values Into a Range of Cells Manually</h2>
<paragraph xml-lang="en-US" id="par_id8200018" role="paragraph">There are two features that assist you when you enter a block of data manually.</paragraph>
<h3 id="hd_id1867427">Area Detection for New Rows</h3>
<paragraph xml-lang="en-US" id="par_id7908871" role="paragraph">In the row below a heading row, you can advance from one cell to the next with the Tab key. After you enter the value into the last cell in the current row, press Enter. Calc positions the cursor below the first cell of the current block.</paragraph>
<paragraph xml-lang="en-US" id="par_id6196783" role="paragraph">
<image id="img_id6473586" src="media/helpimg/area1.png" width="4.8335in" height="1.5937in"><alt xml-lang="en-US" id="alt_id6473586">area detection</alt>
</image></paragraph>
<paragraph xml-lang="en-US" id="par_id8118839" role="paragraph">In row 3, press Tab to advance from cell B3 to C3, D3, and E3. Then press Enter to advance to B4.</paragraph>
<h3 id="hd_id3583788">Area Selection</h3>
<paragraph xml-lang="en-US" id="par_id2011780" role="paragraph">Select the area where you want to input values. Now you can start to input values from the cursor position in the selected area. Press the <keycode>Tab</keycode> key to advance to the next cell or <keycode>Shift</keycode> + <keycode>Tab</keycode> to move backward. At the edges of the selected area the tab key jumps inside the selected area. You will not leave the selected area.</paragraph>
<paragraph xml-lang="en-US" id="par_id7044282" role="paragraph">
<image id="img_id2811365" src="media/helpimg/area2.png" width="4.8335in" height="1.5937in"><alt xml-lang="en-US" id="alt_id2811365">area selection</alt>
</image></paragraph>
<paragraph xml-lang="en-US" id="par_id3232520" role="paragraph">Select the area from B3 to E7. Now B3 is waiting for your input. Press <keycode>Tab</keycode> to advance to the next cell within the selected area.</paragraph>
<h2 id="hd_id8950163">To Enter Values to a Range of Cells Automatically</h2>
<paragraph xml-lang="en-US" id="par_id633869" role="paragraph">See <link href="text/scalc/guide/calc_series.xhp">Automatically Filling in Data Based on Adjacent Cells</link>.</paragraph>
<section id="relatedtopics">
<embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/>
<embed href="text/scalc/guide/multitables.xhp#multitables"/>
<embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/>
</section>
</body>
</helpdocument>
|
