<HTML
><HEAD
><TITLE
>Copying and moving cells</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.54"><LINK
REL="HOME"
TITLE="Gnumeric's user manual"
HREF="gnumeric.html"><LINK
REL="UP"
TITLE="Entering data."
HREF="editing.html"><LINK
REL="PREVIOUS"
TITLE="Selecting Cells While Entering Formulas."
HREF="x176.html"><LINK
REL="NEXT"
TITLE="Editing cells using the selection"
HREF="editing-selections.html"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Gnumeric's user manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="x176.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Chapter 1. Entering data.</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="editing-selections.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="AEN222"
>Copying and moving cells</A
></H1
><P
>There are two ways of moving and copying cells in Gnumeric:</P
><P
></P
><UL
><LI
><P
>Using copy/cut/paste operations</P
></LI
><LI
><P
>Using the mouse to drag the selection</P
></LI
></UL
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN230"
>Using the mouse to drag the selection</A
></H2
><P
>Gnumeric allows the user to move and copy cells
      and their contents by simply dragging and dropping the
      cell to its new location. </P
><P
>The basic procedure to quickly drag and drop a cell to
      a new location is to click on the border, and drag the cell
      to its new location and release. The contents of the cell
      will be moved to the new cell.</P
><DIV
CLASS="PROCEDURE"
><OL
TYPE="1"
><LI
><P
>Click <SPAN
CLASS="MOUSEBUTTON"
>(MB1)</SPAN
> on the border (anywhere, except the autofill square in
	    the bottom right corner).<B
CLASS="KEYCAP"
>Ctrl</B
>+<SPAN
CLASS="MOUSEBUTTON"
>MB1</SPAN
> 
	    copies the cell, why a plain
	    click just moves the cell.
	  </P
></LI
><LI
><P
>Drag the cell to the new cell location.</P
></LI
><LI
><P
>Release the selection.</P
></LI
></OL
></DIV
><P
>This is the simplest method and most common use the drag and drop
      cell moving and copying. The key bindings give you a good set of options
      for quick moving and copying.</P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN245"
>Right Click Options</A
></H2
><P
>The other more extensive option to moving and copying cells is the 
	right click options. This presents a menu of options that is more extensive
	that can be easily done with the normal key bindings</P
><DIV
CLASS="PROCEDURE"
><OL
TYPE="1"
><LI
><P
>Right Click <SPAN
CLASS="MOUSEBUTTON"
>(MB3)</SPAN
> on the border (anywhere, except the autofill square in
	    the bottom right corner).
	  </P
></LI
><LI
><P
>Drag the cell to the new cell location.
	  </P
></LI
><LI
><P
>Release the selection. An options menu should pop-up.
	  </P
></LI
><LI
><P
>Select the appropriate option from the menu and click again. The new
	    cell should have the new info.
	  </P
></LI
></OL
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN258"
>Move and copy right click menu options</A
></H2
><P
></P
><UL
><LI
><P
>	  Copy: Same effect as the normal Copy operations. It
	  copies the value, the format, and the formula. Equivalent  to Ctrl+MB1.
	</P
></LI
><LI
><P
>	  Move: Same effect as the normal Move operations. It
	  moves the value, the format, and the formula. Equivalent  to MB1.
	</P
></LI
><LI
><P
>	    Copy Formats: Copies the formatting info of the source cell. This
	    includes number format, color, font, fill type, etc.
	  </P
></LI
><LI
><P
>	    Copy Values: Copies the value in the source cell to the destination
	    cell.
	  </P
></LI
><LI
><P
>Shift Cells Down and Copy: not implemented yet</P
></LI
><LI
><P
>Shift Cells Right and Copy: not implemented yet</P
></LI
><LI
><P
>Shift Cells Down and Move: not implemented yet</P
></LI
><LI
><P
>Shift Cells Right and Move: not implemented yet</P
></LI
></UL
><DIV
CLASS="FIGURE"
><A
NAME="RIGHTCLICKMOVE"
></A
><P
><B
>Figure 1-3. The option menu for  dragging a cell with right click <SPAN
CLASS="MOUSEBUTTON"
>(MB3)</SPAN
>.</B
></P
><P
><IMG
SRC="images/dndselection-1.jpg"></P
></DIV
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="x176.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="gnumeric.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="editing-selections.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Selecting Cells While Entering Formulas.</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="editing.html"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Editing cells using the selection</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>