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="textscalcguidemark_cellsxml" indexer="include" status="PUBLISH"> 30*b1cdbd2cSJim Jagielski <title xml-lang="en-US" id="tit">Selecting Multiple Cells</title> 31*b1cdbd2cSJim Jagielski <filename>/text/scalc/guide/mark_cells.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_id3153361"><bookmark_value>cells; selecting</bookmark_value> 36*b1cdbd2cSJim Jagielski <bookmark_value>marking cells</bookmark_value> 37*b1cdbd2cSJim Jagielski <bookmark_value>selecting;cells</bookmark_value> 38*b1cdbd2cSJim Jagielski <bookmark_value>multiple cells selection</bookmark_value> 39*b1cdbd2cSJim Jagielski <bookmark_value>selection modes in spreadsheets</bookmark_value> 40*b1cdbd2cSJim Jagielski <bookmark_value>tables; selecting ranges</bookmark_value> 41*b1cdbd2cSJim Jagielski</bookmark><comment>mw changed "selection modes..."</comment> 42*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3153361" role="heading" level="1" l10n="U" oldref="1"><variable id="mark_cells"><link href="text/scalc/guide/mark_cells.xhp" name="Selecting Multiple Cells">Selecting Multiple Cells</link> 43*b1cdbd2cSJim Jagielski</variable></paragraph> 44*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3145272" role="heading" level="2" l10n="U" oldref="2">Select a rectangular range</paragraph> 45*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149261" role="paragraph" l10n="U" oldref="3">With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range.</paragraph> 46*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3151119" role="heading" level="2" l10n="U" oldref="4">Mark a single cell</paragraph> 47*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146975" role="paragraph" l10n="U" oldref="19">Do one of the following:</paragraph> 48*b1cdbd2cSJim Jagielski <list type="unordered"> 49*b1cdbd2cSJim Jagielski <listitem> 50*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3163710" role="listitem" l10n="U" oldref="20">Click, then Shift-click the cell.</paragraph> 51*b1cdbd2cSJim Jagielski </listitem> 52*b1cdbd2cSJim Jagielski <listitem> 53*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149959" role="listitem" l10n="CHG" oldref="5">Pressing the mouse button, drag a range across two cells, do not release the mouse button, and then drag back to the first cell. Release the mouse button. You can now move the individual cell by drag and drop.</paragraph> 54*b1cdbd2cSJim Jagielski </listitem> 55*b1cdbd2cSJim Jagielski </list> 56*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3154942" role="heading" level="2" l10n="U" oldref="6">Select various dispersed cells</paragraph> 57*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id1001200901072060" role="paragraph" l10n="NEW">Do one of the following:</paragraph> 58*b1cdbd2cSJim Jagielski <list type="unordered"> 59*b1cdbd2cSJim Jagielski <listitem> 60*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3156284" role="paragraph" l10n="U" oldref="7">Mark at least one cell. Then while pressing <switchinline select="sys"><caseinline select="MAC">Command 61*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, click each of the additional cells.</paragraph> 62*b1cdbd2cSJim Jagielski </listitem> 63*b1cdbd2cSJim Jagielski <listitem> 64*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id1001200901072023" role="paragraph" l10n="NEW">Click the STD / EXT / ADD area in the status bar until it shows ADD. Now click all cells that you want to select.</paragraph> 65*b1cdbd2cSJim Jagielski </listitem> 66*b1cdbd2cSJim Jagielski </list> 67*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3146971" role="heading" level="2" l10n="U" oldref="8">Switch marking mode</paragraph> 68*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155064" role="paragraph" l10n="U" oldref="9">On the status bar, click the box with the legend STD / EXT / ADD to switch the marking mode:</paragraph> 69*b1cdbd2cSJim Jagielski <table id="tbl_id3145643"> 70*b1cdbd2cSJim Jagielski <tablerow> 71*b1cdbd2cSJim Jagielski <tablecell> 72*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3159264" role="paragraph" l10n="U" oldref="10">Field contents</paragraph> 73*b1cdbd2cSJim Jagielski </tablecell> 74*b1cdbd2cSJim Jagielski <tablecell> 75*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155337" role="paragraph" l10n="U" oldref="11">Effect of clicking the mouse</paragraph> 76*b1cdbd2cSJim Jagielski </tablecell> 77*b1cdbd2cSJim Jagielski </tablerow> 78*b1cdbd2cSJim Jagielski <tablerow> 79*b1cdbd2cSJim Jagielski <tablecell> 80*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149568" role="paragraph" l10n="U" oldref="12">STD</paragraph> 81*b1cdbd2cSJim Jagielski </tablecell> 82*b1cdbd2cSJim Jagielski <tablecell> 83*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148486" role="paragraph" l10n="U" oldref="13">A mouse click selects the cell you have clicked on. Unmarks all marked cells.</paragraph> 84*b1cdbd2cSJim Jagielski </tablecell> 85*b1cdbd2cSJim Jagielski </tablerow> 86*b1cdbd2cSJim Jagielski <tablerow> 87*b1cdbd2cSJim Jagielski <tablecell> 88*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150090" role="paragraph" l10n="U" oldref="14">EXT</paragraph> 89*b1cdbd2cSJim Jagielski </tablecell> 90*b1cdbd2cSJim Jagielski <tablecell> 91*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150305" role="paragraph" l10n="CHG" oldref="15">A mouse click marks a rectangular range from the current cell to the cell you clicked. Alternatively, Shift-click a cell.</paragraph> 92*b1cdbd2cSJim Jagielski </tablecell> 93*b1cdbd2cSJim Jagielski </tablerow> 94*b1cdbd2cSJim Jagielski <tablerow> 95*b1cdbd2cSJim Jagielski <tablecell> 96*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3145587" role="paragraph" l10n="U" oldref="16">ADD</paragraph> 97*b1cdbd2cSJim Jagielski </tablecell> 98*b1cdbd2cSJim Jagielski <tablecell> 99*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154368" role="paragraph" l10n="U" oldref="17">A mouse click in a cell adds it to the already marked cells. A mouse click in a marked cell unmarks it. Alternatively, <switchinline select="sys"><caseinline select="MAC">Command 100*b1cdbd2cSJim Jagielski</caseinline><defaultinline>Ctrl</defaultinline></switchinline>-click the cells.</paragraph> 101*b1cdbd2cSJim Jagielski </tablecell> 102*b1cdbd2cSJim Jagielski </tablerow> 103*b1cdbd2cSJim Jagielski </table> 104*b1cdbd2cSJim Jagielski 105*b1cdbd2cSJim Jagielski <section id="relatedtopics"> 106*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154487" role="paragraph" l10n="U" oldref="18"><link href="text/scalc/main0208.xhp" name="Status bar">Status bar</link></paragraph> 107*b1cdbd2cSJim Jagielski </section> 108*b1cdbd2cSJim Jagielski </body> 109*b1cdbd2cSJim Jagielski</helpdocument>