1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir<helpdocument version="1.0"> 3cdf0e10cSrcweir 4*02dbb15cSAndrew Rist<!--*********************************************************** 5cdf0e10cSrcweir * 6*02dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 7*02dbb15cSAndrew Rist * or more contributor license agreements. See the NOTICE file 8*02dbb15cSAndrew Rist * distributed with this work for additional information 9*02dbb15cSAndrew Rist * regarding copyright ownership. The ASF licenses this file 10*02dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the 11*02dbb15cSAndrew Rist * "License"); you may not use this file except in compliance 12*02dbb15cSAndrew Rist * with the License. You may obtain a copy of the License at 13*02dbb15cSAndrew Rist * 14*02dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 15*02dbb15cSAndrew Rist * 16*02dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing, 17*02dbb15cSAndrew Rist * software distributed under the License is distributed on an 18*02dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*02dbb15cSAndrew Rist * KIND, either express or implied. See the License for the 20*02dbb15cSAndrew Rist * specific language governing permissions and limitations 21*02dbb15cSAndrew Rist * under the License. 22*02dbb15cSAndrew Rist * 23*02dbb15cSAndrew Rist ***********************************************************--> 24*02dbb15cSAndrew Rist 25*02dbb15cSAndrew Rist 26cdf0e10cSrcweir 27cdf0e10cSrcweir 28cdf0e10cSrcweir<meta> 29cdf0e10cSrcweir <topic id="textscalcguidecell_enterxml" indexer="include" status="PUBLISH"> 30cdf0e10cSrcweir <title xml-lang="en-US" id="tit">Entering Values</title> 31cdf0e10cSrcweir <filename>/text/scalc/guide/cell_enter.xhp</filename> 32cdf0e10cSrcweir </topic> 33cdf0e10cSrcweir </meta> 34cdf0e10cSrcweir <body> 35cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3150868"><bookmark_value>values; inserting in multiple cells</bookmark_value> 36cdf0e10cSrcweir <bookmark_value>inserting;values</bookmark_value> 37cdf0e10cSrcweir <bookmark_value>cell ranges;selecting for data entries</bookmark_value> 38cdf0e10cSrcweir <bookmark_value>areas, see also cell ranges</bookmark_value> 39cdf0e10cSrcweir</bookmark> 40cdf0e10cSrcweir<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> 41cdf0e10cSrcweir</variable></paragraph> 42cdf0e10cSrcweir <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> 43cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id5621509" role="heading" level="2" l10n="NEW">To Enter Values Into a Range of Cells Manually</paragraph> 44cdf0e10cSrcweir <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> 45cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id1867427" role="heading" level="3" l10n="NEW">Area Detection for New Rows</paragraph> 46cdf0e10cSrcweir <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> 47cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id6196783" role="paragraph" l10n="NEW"> 48cdf0e10cSrcweir<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> 49cdf0e10cSrcweir </image></paragraph> 50cdf0e10cSrcweir <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> 51cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3583788" role="heading" level="3" l10n="NEW">Area Selection</paragraph> 52cdf0e10cSrcweir <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> 53cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id7044282" role="paragraph" l10n="NEW"> 54cdf0e10cSrcweir<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> 55cdf0e10cSrcweir </image></paragraph> 56cdf0e10cSrcweir <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> 57cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id8950163" role="heading" level="2" l10n="NEW">To Enter Values to a Range of Cells Automatically</paragraph> 58cdf0e10cSrcweir <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> 59cdf0e10cSrcweir <section id="relatedtopics"> 60cdf0e10cSrcweir <embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/> 61cdf0e10cSrcweir <embed href="text/scalc/guide/multitables.xhp#multitables"/> 62cdf0e10cSrcweir <embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/> 63cdf0e10cSrcweir </section> 64cdf0e10cSrcweir </body> 65cdf0e10cSrcweir</helpdocument> 66
