Dragging and Dropping a Cell Range

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 22:07, 27 February 2008 (edit)
( | contribs)
m (Copying a single cell)
← Previous diff
Current revision (08:43, 29 February 2008) (edit) (undo)
Jgd (Talk | contribs)
m (delete useless (forgotten) title)
 
(16 intermediate revisions not shown.)
Line 1: Line 1:
In Calc it is possible to drag and drop a cell range by using only the mouse. You get the same result as if you were using the copy-paste or cut-paste functionality, but nothing is put in the clipboard. In Calc it is possible to drag and drop a cell range by using only the mouse. You get the same result as if you were using the copy-paste or cut-paste functionality, but nothing is put in the clipboard.
 +
 +==Selecting a Cell Range or a Single Cell==
 +*To select a cell range drag the cursor on it, or click on the first cell at the top left, then press on the {{key|Shift}} key and click on the last cell at the bottom right.
 +*To select a single cell, click once on it, then click on it again whilst pressing the {{key|Shift}} key.
 +
 +As a single cell is technically just a range consisting of one cell, in the following the term ''cell range'' will refer equally to a range made up of one or more cells.
==Dragging and Dropping in the same sheet == ==Dragging and Dropping in the same sheet ==
 +
 +===Copying a cell range===
 +* Select the range you want to copy.
 +*Release the mouse button.
 +*Whilst holding the {{key|Opt}} key, click in the first cell in the range where you want to paste a copy of the selected range.<br>
 +The original range is copied into the new location without being deleted.
 +
===Moving a cell range=== ===Moving a cell range===
-*Select the range you want to move by dragging the cursor, or by clicking on the first cell at the top left, then pressing on the {{key|Shift}} key and clicking on the last cell at the bottom right.+*Select the range you want to move.
*Release the mouse button. *Release the mouse button.
*Click on any cell in the selected range, then start to drag the pointer. It takes the appearance of a hand. *Click on any cell in the selected range, then start to drag the pointer. It takes the appearance of a hand.
-*Drag the pointer to the desired location (a frame will follow the cursor showing you where the cells will be moved to) and release the mouse button.<br>+*Drag the pointer to the desired location and release the mouse button.<br>
The cell range is moved to the chosen location and the original one is deleted. The cell range is moved to the chosen location and the original one is deleted.
-===Moving a single cell===+==Dragging and Dropping between two different sheets==
-This method is slightly different.+
-*Select the cell you want to move by clicking once on the cell, and then clicking on it again whilst pressing the {{key|Shift}} key.+
-*Click again on this cell, then start to drag the pointer. It takes the appearance of a hand.+
-*Drag the pointer to the desired location and release the mouse button.+
===Copying a cell range=== ===Copying a cell range===
-* Select the range you want to move without deleting it by dragging the cursor, or by clicking on the first cell at the left side top, then pressing on the {{key|Shift}} key and clicking on the last cell at the right side bottom.+*Select the range you want to copy.
-*Release the mouse button+
-*Press the {{key|Opt}} key.+
-*Click in the first cell in the range where you want to copy the selected range.<br>+
-The original range is copied into the new location without being deleted. +
- +
-===Copying a single cell===+
-*Select the cell you want to copy by clicking once on the cell, and then clicking on it again whilst pressing the {{key|Shift}} key.+
-*Whilst holding down the {{key|Opt}} key, click on the cell where you want the selected cell to be copied.<br>+
-The original cell is copied into the new location without being deleted.+
- +
-==Dragging and Dropping in two different sheets==+
-*Select the range you want to copy. It may consist of a single cell.+
*Go to the {{menu| Data}} menu and choose {{menu|Define Range…}}. *Go to the {{menu| Data}} menu and choose {{menu|Define Range…}}.
*Give this range a name, for example ''' CopyTest''' and click on {{button|Add}}. Click on {{button|OK}}. *Give this range a name, for example ''' CopyTest''' and click on {{button|Add}}. Click on {{button|OK}}.
 +
 +This range is listed in the {{window|Navigator}}. To copy it afterwards, as often as you want, apply the following method:
*Select the sheet in which you want to copy this range. *Select the sheet in which you want to copy this range.
*Open the {{window|Navigator}} by going in the {{menu|Edit}} menu, then selecting {{menu|Navigator}}. *Open the {{window|Navigator}} by going in the {{menu|Edit}} menu, then selecting {{menu|Navigator}}.
Line 36: Line 35:
*Select the '''CopyTest''' range, right click or Control-click on this rectangle. *Select the '''CopyTest''' range, right click or Control-click on this rectangle.
*Choose {{prefName|Drag Mode}} then {{prefName|Insert as Copy}} in the contextual menus. *Choose {{prefName|Drag Mode}} then {{prefName|Insert as Copy}} in the contextual menus.
-*Drag the rectangle '''CopyTest''' from the {{window|Navigator}} window to the location where you want to copy this range.<br>+*Drag the rectangle '''CopyTest''' from the Navigator to the location where you want to copy this range.<br>
-The original range is copied into this location without being deleted.+The original range is copied into this location without being deleted.<br>
 +'''Note''': the two sheets may belong to two different documents.
 + 
 +===Moving a cell range===
 +*Select the range you want to move.
 +*Click on the selected cell(s) and drag the cursor ''quickly'' down to the target sheet tab (the ''quickly'' part fools NeoOffice into not scrolling the page!)
 +*The new sheet will come to the front, and then you can drop the selected-cell frame where you want the cell(s) moved to. <br>
 +If you're working within the same document, the original range is deleted.<br>
 +If the two sheets are in different documents, the original range is copied into the new location without being deleted.
 + 
 +'''Note''': you can, of course, use the usual copy/paste or cut/paste methods to copy or move a cell range. In each case, the range is copied to the clipboard, overwriting its contents (unless you have multiple clipboard capability).
{{botlangbarEN|[[Fr:Glisser-déposer une plage de cellules|Français]]}} {{botlangbarEN|[[Fr:Glisser-déposer une plage de cellules|Français]]}}
[[Category:Tips and Hints]][[Category:NeoOffice]] [[Category:Tips and Hints]][[Category:NeoOffice]]

Current revision

In Calc it is possible to drag and drop a cell range by using only the mouse. You get the same result as if you were using the copy-paste or cut-paste functionality, but nothing is put in the clipboard.

Contents

Selecting a Cell Range or a Single Cell

  • To select a cell range drag the cursor on it, or click on the first cell at the top left, then press on the Shift key and click on the last cell at the bottom right.
  • To select a single cell, click once on it, then click on it again whilst pressing the Shift key.

As a single cell is technically just a range consisting of one cell, in the following the term cell range will refer equally to a range made up of one or more cells.

Dragging and Dropping in the same sheet

Copying a cell range

  • Select the range you want to copy.
  • Release the mouse button.
  • Whilst holding the Opt key, click in the first cell in the range where you want to paste a copy of the selected range.

The original range is copied into the new location without being deleted.

Moving a cell range

  • Select the range you want to move.
  • Release the mouse button.
  • Click on any cell in the selected range, then start to drag the pointer. It takes the appearance of a hand.
  • Drag the pointer to the desired location and release the mouse button.

The cell range is moved to the chosen location and the original one is deleted.

Dragging and Dropping between two different sheets

Copying a cell range

  • Select the range you want to copy.
  • Go to the Data menu and choose Define Range….
  • Give this range a name, for example CopyTest and click on Add. Click on OK.

This range is listed in the Navigator. To copy it afterwards, as often as you want, apply the following method:

  • Select the sheet in which you want to copy this range.
  • Open the Navigator by going in the Edit menu, then selecting Navigator.
  • Click on the little triangle on the left side of Database Ranges.
  • Select the CopyTest range, right click or Control-click on this rectangle.
  • Choose Drag Mode then Insert as Copy in the contextual menus.
  • Drag the rectangle CopyTest from the Navigator to the location where you want to copy this range.

The original range is copied into this location without being deleted.
Note: the two sheets may belong to two different documents.

Moving a cell range

  • Select the range you want to move.
  • Click on the selected cell(s) and drag the cursor quickly down to the target sheet tab (the quickly part fools NeoOffice into not scrolling the page!)
  • The new sheet will come to the front, and then you can drop the selected-cell frame where you want the cell(s) moved to.

If you're working within the same document, the original range is deleted.
If the two sheets are in different documents, the original range is copied into the new location without being deleted.

Note: you can, of course, use the usual copy/paste or cut/paste methods to copy or move a cell range. In each case, the range is copied to the clipboard, overwriting its contents (unless you have multiple clipboard capability).


This article in other languages: Français
Personal tools