1 <?xml version=
"1.0" encoding=
"UTF-8"?>
5 ***********************************************************************
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9 * Copyright 2008 by Sun Microsystems, Inc.
11 * OpenOffice.org - a multi-platform office productivity suite
13 * $RCSfile: mark_cells.xhp,v $
14 * $Revision: 1.7.4.1 $
16 * This file is part of OpenOffice.org.
18 * OpenOffice.org is free software: you can redistribute it and/or modify
19 * it under the terms of the GNU Lesser General Public License version 3
20 * only, as published by the Free Software Foundation.
22 * OpenOffice.org is distributed in the hope that it will be useful,
23 * but WITHOUT ANY WARRANTY; without even the implied warranty of
24 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
25 * GNU Lesser General Public License version 3 for more details
26 * (a copy is included in the LICENSE file that accompanied this code).
28 * You should have received a copy of the GNU Lesser General Public License
29 * version 3 along with OpenOffice.org. If not, see
30 * <http://www.openoffice.org/license.html>
31 * for a copy of the LGPLv3 License.
33 ************************************************************************
36 <helpdocument version=
"1.0">
38 <topic id=
"textscalcguidemark_cellsxml" indexer=
"include" status=
"PUBLISH">
39 <title id=
"tit" xml-lang=
"en-US">Selecting Multiple Cells
</title>
40 <filename>/text/scalc/guide/mark_cells.xhp
</filename>
43 <created date=
"2003-10-31T00:00:00">Sun Microsystems, Inc.
</created>
44 <lastedited date=
"2006-03-21T12:48:20">converted from old format - fpe
</lastedited>
48 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3153361"><bookmark_value>cells; selecting
</bookmark_value>
49 <bookmark_value>marking cells
</bookmark_value>
50 <bookmark_value>selecting;cells
</bookmark_value>
51 <bookmark_value>multiple cells selection
</bookmark_value>
52 <bookmark_value>selection modes in spreadsheets
</bookmark_value>
53 <bookmark_value>tables; selecting ranges
</bookmark_value>
54 </bookmark><comment>mw changed
"selection modes..."</comment>
55 <paragraph role=
"heading" id=
"hd_id3153361" xml-lang=
"en-US" 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>
56 </variable></paragraph>
57 <paragraph role=
"heading" id=
"hd_id3145272" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"2">Select a rectangular range
</paragraph>
58 <paragraph role=
"paragraph" id=
"par_id3149261" xml-lang=
"en-US" l10n=
"U" oldref=
"3">With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range.
</paragraph>
59 <paragraph role=
"heading" id=
"hd_id3151119" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"4">Mark a single cell
</paragraph>
60 <paragraph role=
"paragraph" id=
"par_id3146975" xml-lang=
"en-US" l10n=
"U" oldref=
"19">Do one of the following:
</paragraph>
61 <list type=
"unordered">
63 <paragraph role=
"listitem" id=
"par_id3163710" xml-lang=
"en-US" l10n=
"U" oldref=
"20">Click, then Shift-click the cell.
</paragraph>
66 <paragraph role=
"listitem" id=
"par_id3149959" xml-lang=
"en-US" l10n=
"U" 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. You can now move the individual cell by drag and drop.
</paragraph>
69 <paragraph role=
"heading" id=
"hd_id3154942" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"6">Select various dispersed cells
</paragraph>
70 <paragraph role=
"paragraph" id=
"par_id3156284" xml-lang=
"en-US" l10n=
"U" oldref=
"7">Mark at least one cell. Then while pressing
<switchinline select=
"sys"><caseinline select=
"MAC">Command
</caseinline><defaultinline>Ctrl
</defaultinline></switchinline>, click each of the additional cells.
</paragraph>
71 <paragraph role=
"heading" id=
"hd_id3146971" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"8">Switch marking mode
</paragraph>
72 <paragraph role=
"paragraph" id=
"par_id3155064" xml-lang=
"en-US" l10n=
"U" oldref=
"9">On the status bar, click the box with the legend STD / EXT / ADD to switch the marking mode:
</paragraph>
73 <table id=
"tbl_id3145643">
75 <tablecell colspan=
"" rowspan=
"">
76 <paragraph role=
"paragraph" id=
"par_id3159264" xml-lang=
"en-US" l10n=
"U" oldref=
"10">Field contents
</paragraph>
78 <tablecell colspan=
"" rowspan=
"">
79 <paragraph role=
"paragraph" id=
"par_id3155337" xml-lang=
"en-US" l10n=
"U" oldref=
"11">Effect of clicking the mouse
</paragraph>
83 <tablecell colspan=
"" rowspan=
"">
84 <paragraph role=
"paragraph" id=
"par_id3149568" xml-lang=
"en-US" l10n=
"U" oldref=
"12">STD
</paragraph>
86 <tablecell colspan=
"" rowspan=
"">
87 <paragraph role=
"paragraph" id=
"par_id3148486" xml-lang=
"en-US" l10n=
"U" oldref=
"13">A mouse click selects the cell you have clicked on. Unmarks all marked cells.
</paragraph>
91 <tablecell colspan=
"" rowspan=
"">
92 <paragraph role=
"paragraph" id=
"par_id3150090" xml-lang=
"en-US" l10n=
"U" oldref=
"14">EXT
</paragraph>
94 <tablecell colspan=
"" rowspan=
"">
95 <paragraph role=
"paragraph" id=
"par_id3150305" xml-lang=
"en-US" l10n=
"U" oldref=
"15">A mouse click marks a rectangular range from the current cell to the cell you clicked.
</paragraph>
99 <tablecell colspan=
"" rowspan=
"">
100 <paragraph role=
"paragraph" id=
"par_id3145587" xml-lang=
"en-US" l10n=
"U" oldref=
"16">ADD
</paragraph>
102 <tablecell colspan=
"" rowspan=
"">
103 <paragraph role=
"paragraph" id=
"par_id3154368" xml-lang=
"en-US" 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
</caseinline><defaultinline>Ctrl
</defaultinline></switchinline>-click the cells.
</paragraph>
108 <section id=
"relatedtopics">
109 <paragraph role=
"paragraph" id=
"par_id3154487" xml-lang=
"en-US" l10n=
"U" oldref=
"18"><link href=
"text/scalc/main0208.xhp" name=
"Status bar">Status bar
</link></paragraph>