1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski<helpdocument version="1.0"> 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski<!--*********************************************************** 5*b1cdbd2cSJim Jagielski * 6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 7*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 8*b1cdbd2cSJim Jagielski * distributed with this work for additional information 9*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 12*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 13*b1cdbd2cSJim Jagielski * 14*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 15*b1cdbd2cSJim Jagielski * 16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 21*b1cdbd2cSJim Jagielski * under the License. 22*b1cdbd2cSJim Jagielski * 23*b1cdbd2cSJim Jagielski ***********************************************************--> 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski<meta> 29*b1cdbd2cSJim Jagielski <topic id="textscalcguidecell_enterxml" indexer="include" status="PUBLISH"> 30*b1cdbd2cSJim Jagielski <title xml-lang="en-US" id="tit">Entering Values</title> 31*b1cdbd2cSJim Jagielski <filename>/text/scalc/guide/cell_enter.xhp</filename> 32*b1cdbd2cSJim Jagielski </topic> 33*b1cdbd2cSJim Jagielski </meta> 34*b1cdbd2cSJim Jagielski <body> 35*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3150868"><bookmark_value>values; inserting in multiple cells</bookmark_value> 36*b1cdbd2cSJim Jagielski <bookmark_value>inserting;values</bookmark_value> 37*b1cdbd2cSJim Jagielski <bookmark_value>cell ranges;selecting for data entries</bookmark_value> 38*b1cdbd2cSJim Jagielski <bookmark_value>areas, see also cell ranges</bookmark_value> 39*b1cdbd2cSJim Jagielski</bookmark> 40*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3405255" role="heading" level="1" l10n="NEW"><variable id="cell_enter"><link href="text/scalc/guide/cell_enter.xhp">Entering Values</link> 41*b1cdbd2cSJim Jagielski</variable></paragraph> 42*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id7147129" role="paragraph" l10n="NEW">Calc can simplify entering data and values into multiple cells. You can change some settings to conform to your preferences.</paragraph> 43*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id5621509" role="heading" level="2" l10n="NEW">To Enter Values Into a Range of Cells Manually</paragraph> 44*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8200018" role="paragraph" l10n="NEW">There are two features that assist you when you enter a block of data manually.</paragraph> 45*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id1867427" role="heading" level="3" l10n="NEW">Area Detection for New Rows</paragraph> 46*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id7908871" role="paragraph" l10n="NEW">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> 47*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id6196783" role="paragraph" l10n="NEW"> 48*b1cdbd2cSJim Jagielski<image id="img_id6473586" src="res/helpimg/area1.png" width="4.8335in" height="1.5937in"><alt xml-lang="en-US" id="alt_id6473586">area detection</alt> 49*b1cdbd2cSJim Jagielski </image></paragraph> 50*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8118839" role="paragraph" l10n="NEW">In row 3, press Tab to advance from cell B3 to C3, D3, and E3. Then press Enter to advance to B4.</paragraph> 51*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3583788" role="heading" level="3" l10n="NEW">Area Selection</paragraph> 52*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id2011780" role="paragraph" l10n="NEW">Use drag-and-drop to select the area where you want to input values. But start dragging from the last cell of the area and release the mouse button when you have selected the first cell. Now you can start to input values. Always press the Tab key to advance to the next cell. You will not leave the selected area.</paragraph> 53*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id7044282" role="paragraph" l10n="NEW"> 54*b1cdbd2cSJim Jagielski<image id="img_id2811365" src="res/helpimg/area2.png" width="4.8335in" height="1.5937in"><alt xml-lang="en-US" id="alt_id2811365">area selection</alt> 55*b1cdbd2cSJim Jagielski </image></paragraph> 56*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3232520" role="paragraph" l10n="NEW">Select the area from E7 to B3. Now B3 is waiting for your input. Press Tab to advance to the next cell within the selected area.</paragraph> 57*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id8950163" role="heading" level="2" l10n="NEW">To Enter Values to a Range of Cells Automatically</paragraph> 58*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id633869" role="paragraph" l10n="NEW">See <link href="text/scalc/guide/calc_series.xhp">Automatically Filling in Data Based on Adjacent Cells</link>.</paragraph> 59*b1cdbd2cSJim Jagielski <section id="relatedtopics"> 60*b1cdbd2cSJim Jagielski <embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/> 61*b1cdbd2cSJim Jagielski <embed href="text/scalc/guide/multitables.xhp#multitables"/> 62*b1cdbd2cSJim Jagielski <embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/> 63*b1cdbd2cSJim Jagielski </section> 64*b1cdbd2cSJim Jagielski </body> 65*b1cdbd2cSJim Jagielski</helpdocument> 66
