1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir<helpdocument version="1.0"> 3cdf0e10cSrcweir 4*ce44d6c1SAndrew Rist<!--*********************************************************** 5cdf0e10cSrcweir * 6*ce44d6c1SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 7*ce44d6c1SAndrew Rist * or more contributor license agreements. See the NOTICE file 8*ce44d6c1SAndrew Rist * distributed with this work for additional information 9*ce44d6c1SAndrew Rist * regarding copyright ownership. The ASF licenses this file 10*ce44d6c1SAndrew Rist * to you under the Apache License, Version 2.0 (the 11*ce44d6c1SAndrew Rist * "License"); you may not use this file except in compliance 12*ce44d6c1SAndrew Rist * with the License. You may obtain a copy of the License at 13*ce44d6c1SAndrew Rist * 14*ce44d6c1SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 15*ce44d6c1SAndrew Rist * 16*ce44d6c1SAndrew Rist * Unless required by applicable law or agreed to in writing, 17*ce44d6c1SAndrew Rist * software distributed under the License is distributed on an 18*ce44d6c1SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*ce44d6c1SAndrew Rist * KIND, either express or implied. See the License for the 20*ce44d6c1SAndrew Rist * specific language governing permissions and limitations 21*ce44d6c1SAndrew Rist * under the License. 22*ce44d6c1SAndrew Rist * 23*ce44d6c1SAndrew Rist ***********************************************************--> 24*ce44d6c1SAndrew Rist 25*ce44d6c1SAndrew Rist 26cdf0e10cSrcweir 27cdf0e10cSrcweir 28cdf0e10cSrcweir<meta> 29cdf0e10cSrcweir<topic id="textscalcguidemove_dragdropxml" indexer="include"> 30cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Moving Cells by Drag-and-Drop </title> 31cdf0e10cSrcweir<filename>/text/scalc/guide/move_dragdrop.xhp</filename> 32cdf0e10cSrcweir</topic> 33cdf0e10cSrcweir</meta> 34cdf0e10cSrcweir<body> 35cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3155686"><bookmark_value>drag and drop; moving cells</bookmark_value> 36cdf0e10cSrcweir<bookmark_value>cells; moving by drag and drop </bookmark_value> 37cdf0e10cSrcweir<bookmark_value>columns;moving by drag and drop</bookmark_value> 38cdf0e10cSrcweir<bookmark_value>moving;cells by drag and drop</bookmark_value> 39cdf0e10cSrcweir<bookmark_value>inserting;cells, by drag and drop</bookmark_value> 40cdf0e10cSrcweir</bookmark><comment>mw added "columns;"</comment> 41cdf0e10cSrcweir<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> 42cdf0e10cSrcweir</variable></paragraph> 43cdf0e10cSrcweir<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> 44cdf0e10cSrcweir<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> 45cdf0e10cSrcweir<list type="ordered"> 46cdf0e10cSrcweir<listitem> 47cdf0e10cSrcweir<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> 48cdf0e10cSrcweir</listitem> 49cdf0e10cSrcweir<listitem> 50cdf0e10cSrcweir<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> 51cdf0e10cSrcweir<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> 52cdf0e10cSrcweir<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> 53cdf0e10cSrcweir</listitem> 54cdf0e10cSrcweir<listitem> 55cdf0e10cSrcweir<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> 56cdf0e10cSrcweir</listitem> 57cdf0e10cSrcweir</list> 58cdf0e10cSrcweir<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> 59cdf0e10cSrcweir<table id="tbl_id1674855"> 60cdf0e10cSrcweir<tablerow> 61cdf0e10cSrcweir<tablecell> 62cdf0e10cSrcweir<paragraph role="tablehead" id="par_id5814081" xml-lang="en-US" l10n="NEW">Keys pressed while releasing the mouse button</paragraph> 63cdf0e10cSrcweir</tablecell> 64cdf0e10cSrcweir<tablecell> 65cdf0e10cSrcweir<paragraph role="tablehead" id="par_id6581316" xml-lang="en-US" l10n="NEW">Result</paragraph> 66cdf0e10cSrcweir</tablecell> 67cdf0e10cSrcweir</tablerow> 68cdf0e10cSrcweir<tablerow> 69cdf0e10cSrcweir<tablecell> 70cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id9906613" xml-lang="en-US" l10n="NEW">No key</paragraph> 71cdf0e10cSrcweir</tablecell> 72cdf0e10cSrcweir<tablecell> 73cdf0e10cSrcweir<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> 74cdf0e10cSrcweir</tablecell> 75cdf0e10cSrcweir</tablerow> 76cdf0e10cSrcweir<tablerow> 77cdf0e10cSrcweir<tablecell> 78cdf0e10cSrcweir<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> 79cdf0e10cSrcweir</tablecell> 80cdf0e10cSrcweir<tablecell> 81cdf0e10cSrcweir<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> 82cdf0e10cSrcweir</tablecell> 83cdf0e10cSrcweir</tablerow> 84cdf0e10cSrcweir<tablerow> 85cdf0e10cSrcweir<tablecell> 86cdf0e10cSrcweir<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> 87cdf0e10cSrcweir</tablecell> 88cdf0e10cSrcweir<tablecell> 89cdf0e10cSrcweir<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> 90cdf0e10cSrcweir</tablecell> 91cdf0e10cSrcweir</tablerow> 92cdf0e10cSrcweir<tablerow> 93cdf0e10cSrcweir<tablecell> 94cdf0e10cSrcweir<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> 95cdf0e10cSrcweir</tablecell> 96cdf0e10cSrcweir<tablecell> 97cdf0e10cSrcweir<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> 98cdf0e10cSrcweir<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> 99cdf0e10cSrcweir</tablecell> 100cdf0e10cSrcweir</tablerow> 101cdf0e10cSrcweir<tablerow> 102cdf0e10cSrcweir<tablecell> 103cdf0e10cSrcweir<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> 104cdf0e10cSrcweir</tablecell> 105cdf0e10cSrcweir<tablecell> 106cdf0e10cSrcweir<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> 107cdf0e10cSrcweir</tablecell> 108cdf0e10cSrcweir</tablerow> 109cdf0e10cSrcweir<tablerow> 110cdf0e10cSrcweir<tablecell> 111cdf0e10cSrcweir<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> 112cdf0e10cSrcweir</tablecell> 113cdf0e10cSrcweir<tablecell> 114cdf0e10cSrcweir<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> 115cdf0e10cSrcweir</tablecell> 116cdf0e10cSrcweir</tablerow> 117cdf0e10cSrcweir</table> 118cdf0e10cSrcweir 119cdf0e10cSrcweir<section id="relatedtopics"> 120cdf0e10cSrcweir<embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> 121cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop.xhp#dragdrop"/> 122cdf0e10cSrcweir</section> 123cdf0e10cSrcweir</body> 124cdf0e10cSrcweir</helpdocument> 125