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="textscalcguidemove_dragdropxml" indexer="include"> 30*b1cdbd2cSJim Jagielski<title id="tit" xml-lang="en-US">Moving Cells by Drag-and-Drop </title> 31*b1cdbd2cSJim Jagielski<filename>/text/scalc/guide/move_dragdrop.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_id3155686"><bookmark_value>drag and drop; moving cells</bookmark_value> 36*b1cdbd2cSJim Jagielski<bookmark_value>cells; moving by drag and drop </bookmark_value> 37*b1cdbd2cSJim Jagielski<bookmark_value>columns;moving by drag and drop</bookmark_value> 38*b1cdbd2cSJim Jagielski<bookmark_value>moving;cells by drag and drop</bookmark_value> 39*b1cdbd2cSJim Jagielski<bookmark_value>inserting;cells, by drag and drop</bookmark_value> 40*b1cdbd2cSJim Jagielski</bookmark><comment>mw added "columns;"</comment> 41*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id986358" xml-lang="en-US" level="1" l10n="NEW"><variable id="move_dragdrop"><link href="text/scalc/guide/move_dragdrop.xhp">Moving Cells by Drag-and-Drop</link> 42*b1cdbd2cSJim Jagielski</variable></paragraph> 43*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id2760093" xml-lang="en-US" l10n="NEW">When you drag-and-drop a selection of cells on a Calc sheet, the cells normally overwrite the existing cells in the area where you drop. This is the normal <emph>overwrite mode</emph>.</paragraph> 44*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9527268" xml-lang="en-US" l10n="NEW">When you hold down the <switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> key while releasing the mouse button, you enter the <emph>insert mode</emph>.</paragraph> 45*b1cdbd2cSJim Jagielski<list type="ordered"> 46*b1cdbd2cSJim Jagielski<listitem> 47*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id79653" xml-lang="en-US" l10n="NEW">In insert mode, the existing cells where you drop will be shifted to the right or to the bottom, and the dropped cells are inserted into the now empty positions without overwriting. </paragraph> 48*b1cdbd2cSJim Jagielski</listitem> 49*b1cdbd2cSJim Jagielski<listitem> 50*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id8676717" xml-lang="en-US" l10n="NEW">The surrounding box of the moved cells looks different in insert mode. </paragraph> 51*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3968932" xml-lang="en-US" l10n="NEW">In overwrite mode you see all four borders around the selected area. In insert mode you see only the left border when target cells will be shifted to the right. You see only the upper border when target cells will be shifted down. </paragraph> 52*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id7399517" xml-lang="en-US" l10n="NEW">Whether the target area will be shifted to the right or to the bottom depends on the distance between source and target cells, if you move within the same sheet. It depends on the number of horizontal or vertical cells in the moved area, if you move to a different sheet.</paragraph> 53*b1cdbd2cSJim Jagielski</listitem> 54*b1cdbd2cSJim Jagielski<listitem> 55*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id8040406" xml-lang="en-US" l10n="NEW">If you move cells in insert mode within the same row (only horizontally), then after insertion of the cells, all cells will be shifted to the left to fill the source area.</paragraph> 56*b1cdbd2cSJim Jagielski</listitem> 57*b1cdbd2cSJim Jagielski</list> 58*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id2586748" xml-lang="en-US" l10n="NEW">In both modes, you can hold down the <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key, or <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift keys while you release the mouse button to insert a copy or a link, respectively.</paragraph> 59*b1cdbd2cSJim Jagielski<table id="tbl_id1674855"> 60*b1cdbd2cSJim Jagielski<tablerow> 61*b1cdbd2cSJim Jagielski<tablecell> 62*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="par_id5814081" xml-lang="en-US" l10n="NEW">Keys pressed while releasing the mouse button</paragraph> 63*b1cdbd2cSJim Jagielski</tablecell> 64*b1cdbd2cSJim Jagielski<tablecell> 65*b1cdbd2cSJim Jagielski<paragraph role="tablehead" id="par_id6581316" xml-lang="en-US" l10n="NEW">Result</paragraph> 66*b1cdbd2cSJim Jagielski</tablecell> 67*b1cdbd2cSJim Jagielski</tablerow> 68*b1cdbd2cSJim Jagielski<tablerow> 69*b1cdbd2cSJim Jagielski<tablecell> 70*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id9906613" xml-lang="en-US" l10n="NEW">No key</paragraph> 71*b1cdbd2cSJim Jagielski</tablecell> 72*b1cdbd2cSJim Jagielski<tablecell> 73*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id2815637" xml-lang="en-US" l10n="NEW">Cells are moved and overwrite the cells in the target area. Source cells are emptied.</paragraph> 74*b1cdbd2cSJim Jagielski</tablecell> 75*b1cdbd2cSJim Jagielski</tablerow> 76*b1cdbd2cSJim Jagielski<tablerow> 77*b1cdbd2cSJim Jagielski<tablecell> 78*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id6161687" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key</paragraph> 79*b1cdbd2cSJim Jagielski</tablecell> 80*b1cdbd2cSJim Jagielski<tablecell> 81*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id4278389" xml-lang="en-US" l10n="NEW">Cells are copied and overwrite the cells in the target area. Source cells stay as they are.</paragraph> 82*b1cdbd2cSJim Jagielski</tablecell> 83*b1cdbd2cSJim Jagielski</tablerow> 84*b1cdbd2cSJim Jagielski<tablerow> 85*b1cdbd2cSJim Jagielski<tablecell> 86*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id2805566" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift keys</paragraph> 87*b1cdbd2cSJim Jagielski</tablecell> 88*b1cdbd2cSJim Jagielski<tablecell> 89*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id5369121" xml-lang="en-US" l10n="NEW">Links to the source cells are inserted and overwrite the cells in the target area. Source cells stay as they are.</paragraph> 90*b1cdbd2cSJim Jagielski</tablecell> 91*b1cdbd2cSJim Jagielski</tablerow> 92*b1cdbd2cSJim Jagielski<tablerow> 93*b1cdbd2cSJim Jagielski<tablecell> 94*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id9518723" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> key</paragraph> 95*b1cdbd2cSJim Jagielski</tablecell> 96*b1cdbd2cSJim Jagielski<tablecell> 97*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id2926419" xml-lang="en-US" l10n="NEW">Cells are moved and shift the cells in the target area to the right or to the bottom. Source cells are emptied, except if you move within the same rows on the same sheet. </paragraph> 98*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id4021423" xml-lang="en-US" l10n="NEW">If you move within the same rows on the same sheet, the cells in the target area shift to the right, and then the whole row shifts to fill the source area.</paragraph> 99*b1cdbd2cSJim Jagielski</tablecell> 100*b1cdbd2cSJim Jagielski</tablerow> 101*b1cdbd2cSJim Jagielski<tablerow> 102*b1cdbd2cSJim Jagielski<tablecell> 103*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id2783898" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Option+Command </caseinline><defaultinline>Alt+Ctrl </defaultinline></switchinline>keys</paragraph> 104*b1cdbd2cSJim Jagielski</tablecell> 105*b1cdbd2cSJim Jagielski<tablecell> 106*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id2785119" xml-lang="en-US" l10n="NEW">Cells are copied and shift the cells in the target area to the right or to the bottom. Source cells stay as they are.</paragraph> 107*b1cdbd2cSJim Jagielski</tablecell> 108*b1cdbd2cSJim Jagielski</tablerow> 109*b1cdbd2cSJim Jagielski<tablerow> 110*b1cdbd2cSJim Jagielski<tablecell> 111*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id584124" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Option+Command</caseinline><defaultinline>Alt+Ctrl</defaultinline></switchinline>+Shift keys</paragraph> 112*b1cdbd2cSJim Jagielski</tablecell> 113*b1cdbd2cSJim Jagielski<tablecell> 114*b1cdbd2cSJim Jagielski<paragraph role="tablecontent" id="par_id5590990" xml-lang="en-US" l10n="NEW">Links to the source cells are inserted and shift the cells in the target area to the right or to the bottom. Source cells stay as they are.</paragraph> 115*b1cdbd2cSJim Jagielski</tablecell> 116*b1cdbd2cSJim Jagielski</tablerow> 117*b1cdbd2cSJim Jagielski</table> 118*b1cdbd2cSJim Jagielski 119*b1cdbd2cSJim Jagielski<section id="relatedtopics"> 120*b1cdbd2cSJim Jagielski<embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> 121*b1cdbd2cSJim Jagielski<embed href="text/shared/guide/dragdrop.xhp#dragdrop"/> 122*b1cdbd2cSJim Jagielski</section> 123*b1cdbd2cSJim Jagielski</body> 124*b1cdbd2cSJim Jagielski</helpdocument> 125