Dragging and Dropping a Cell Range

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 22:32, 27 February 2008 (edit)
( | contribs)
m (→Moving a single cell)
← Previous diff		 Revision as of 19:13, 28 February 2008 (edit) (undo)
Jgd (Talk | contribs)
(translate the changes from the French version)
Next diff →
Line 1: Line 1:
 +Dragging and Dropping a Cell Range
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 exactly a range reduced to 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 in two different sheets==
-This method is slightly different.+'''Note''': the two sheets may belong to two different documents.
-*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.+
-The cell is moved to the chosen location and the original one is deleted.+
- +
===Copying a cell range=== ===Copying a cell range===
-* Select the range you want to copy 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+
-*Whilst holding down 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.+
- +
-===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 to paste a copy of the selected cell.<br>+
-The original cell is copied into the new location without being deleted.+
- +
-==Dragging and Dropping between 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 36:
*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.
 +
 +===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>
 +The original range is deleted.
 +
 +'''Note''': you can, of course, use the usual copy/past or cut/past methods to copy or move a cell range. In each case, the range is copied in the clipboard, overwriting its contents.
{{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]]

Revision as of 19:13, 28 February 2008

Dragging and Dropping a Cell Range 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 exactly a range reduced to 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 in two different sheets

Note: the two sheets may belong to two different documents.

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.

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.

The original range is deleted.

Note: you can, of course, use the usual copy/past or cut/past methods to copy or move a cell range. In each case, the range is copied in the clipboard, overwriting its contents.


This article in other languages: Français
Retrieved from "https://neowiki.neooffice.org/index.php/Dragging_and_Dropping_a_Cell_Range"
Personal tools