<HTML
><HEAD
><TITLE
>Editing cells using the selection</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="Copying and moving cells"
HREF="x222.html"><LINK
REL="NEXT"
TITLE="Autofill"
HREF="autofill.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="x222.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="autofill.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="EDITING-SELECTIONS"
>Editing cells using the selection</A
></H1
><P
>There are various ways of using the selection to ease the
    edition of the cells in the spreadsheet. </P
><P
>For instance, given a selection of cells (contiguous, or
    non-contiguous), data can be entered.  The <B
CLASS="KEYCAP"
>Enter</B
> key will accept
    the data and move the cursor to the next cell in the selection
     down the selection.  The <B
CLASS="KEYCAP"
>tab</B
> key will move the
    cursor to the rightmost cell (or it will scroll if you have
    reached the edge of the selection).</P
><P
><B
CLASS="KEYCAP"
>Control</B
>-<B
CLASS="KEYCAP"
>Enter</B
>
    does the inverse of <B
CLASS="KEYCAP"
>Enter</B
> (it moves to the
    previous cell in the selection, moving towards the top), while
    <B
CLASS="KEYCAP"
>Ctrl</B
>-<B
CLASS="KEYCAP"
>Tab</B
>
    moves the cursor to the left.</P
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN296"
>Simple Selections</A
></H2
><P
>The active cell is indicated by a dark double line with a small
      square in the bottom right corner. The active cell is the the one 
      that is currently in focus and will take any input for the keyboard.</P
><DIV
CLASS="FIGURE"
><A
NAME="ACTIVECELL"
></A
><P
><B
>Figure 1-4. An Active cell.</B
></P
><P
><IMG
SRC="images/selection-2.jpg"></P
></DIV
><P
>To make a cell become the active selected cell, simply move the white-cross cursor
      over the cell and press the <SPAN
CLASS="MOUSEBUTTON"
>MB1</SPAN
>.</P
><DIV
CLASS="FIGURE"
><A
NAME="ACTIVECELLCURSOR"
></A
><P
><B
>Figure 1-5. The active cell with the cursor.</B
></P
><P
><IMG
SRC="images/selection-1.jpg"></P
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN309"
>Selecting multiple cells</A
></H2
><P
>A selection of multiple cells is indicated by a dark double line around
      the extents of the selection. The top-left cell appears much like a single
      selected cell while the rest of the selection is the inverse color.</P
><DIV
CLASS="FIGURE"
><A
NAME="MULTICELLSELECT"
></A
><P
><B
>Figure 1-6. A multi-cell selection</B
></P
><P
><IMG
SRC="images/selection-3.jpg"></P
></DIV
><P
>To make a continuous selection of cells, click on the cell with
      the white_cross cursor and drag the extents of the selection until
      it comprises the area you wish to select, and release.</P
><DIV
CLASS="FIGURE"
><A
NAME="MULTICELLSECT2"
></A
><P
><B
>Figure 1-7. Multiple cells being selected with the cursor.</B
></P
><P
><IMG
SRC="images/selection-4.jpg"></P
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN321"
>Discontinuous selections</A
></H2
><P
>To select a set of cells that may not be continuous,
      use <B
CLASS="KEYCAP"
>ctrl</B
>+<SPAN
CLASS="MOUSEBUTTON"
>MB1</SPAN
> and 
	drag to argument an existing selection. 
	The cells can be added individually or as parts of other selections.</P
><DIV
CLASS="FIGURE"
><A
NAME="DICONTSELECT"
></A
><P
><B
>Figure 1-8. A discontinuous selection of cells.</B
></P
><P
><IMG
SRC="images/selection-5.jpg"></P
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN331"
>Keyboard Shortcuts</A
></H2
><P
>The quickest way to make large selections, especially when your 
      already using the keyboard is to just use the keyboard selection tools.
      The basic use is to press <B
CLASS="KEYCAP"
>Shift</B
>-<B
CLASS="KEYCAP"
>arrow</B
>
      keys to make a new selection.</P
><P
>To select an entire row of cells, press Shift+space. This is equivalent 
      to pressing the row label button on the left side of the sheet.</P
><DIV
CLASS="FIGURE"
><A
NAME="SELECTROW"
></A
><P
><B
>Figure 1-9. An entire row being selected.</B
></P
><P
><IMG
SRC="images/selection-8.jpg"></P
></DIV
><P
>To select an entire column of cells, press <B
CLASS="KEYCAP"
>Ctrl</B
>-<B
CLASS="KEYCAP"
>	  Space</B
>
      . This is equivalent 
      to pressing the column label button on the top of the sheet.</P
><DIV
CLASS="FIGURE"
><A
NAME="SELECTCOL"
></A
><P
><B
>Figure 1-10. An entire column being selected.</B
></P
><P
><IMG
SRC="images/selection-9.jpg"></P
></DIV
><P
>To select the entire sheet, press 
      <B
CLASS="KEYCAP"
>Ctrl</B
>-<B
CLASS="KEYCAP"
>A</B
>. This is equivalent  to
      pressing the button in the top left corner of the sheet.</P
><DIV
CLASS="FIGURE"
><A
NAME="SELECTALL"
></A
><P
><B
>Figure 1-11. The entire worksheet being selected.</B
></P
><P
><IMG
SRC="images/selection-10.jpg"></P
></DIV
><P
></P
><UL
><LI
><P
>	  <B
CLASS="KEYCAP"
>Shift</B
>-<B
CLASS="KEYCAP"
>Arrow</B
>
	  : Define selection with cursor keys.</P
></LI
><LI
><P
>	  <B
CLASS="KEYCAP"
>Shift</B
>-<B
CLASS="KEYCAP"
>Space</B
>
	  : Select current row. </P
></LI
><LI
><P
>	  <B
CLASS="KEYCAP"
>Ctrl</B
>-<B
CLASS="KEYCAP"
>Space</B
>
	  : Select current column.</P
></LI
><LI
><P
>	  <B
CLASS="KEYCAP"
>Ctrl</B
>-<B
CLASS="KEYCAP"
>A</B
>
	  : Select the entire sheet.</P
></LI
></UL
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN379"
>Filling a region with the same text or value.</A
></H2
><P
> For a set of cells that need to get filled with the same value,
      the easiest way is to make a selection using one of the above mentioned, then
      enter the value into one of the cells like normal, but instead of pressing
      enter, press <B
CLASS="KEYCAP"
>Ctrl</B
>-<B
CLASS="KEYCAP"
>enter</B
>
      instead. The selection will fill with the value entered 
      for that cell.</P
><P
>For cases where you want to fill with number sequences, or dates, or other 
      sorted data, you may want to use the autofill option.</P
><DIV
CLASS="FIGURE"
><A
NAME="CELLSELECTFILLBEFORE"
></A
><P
><B
>Figure 1-12. A selection of several cells.</B
></P
><P
><IMG
SRC="images/selection-6.jpg"></P
></DIV
><DIV
CLASS="FIGURE"
><A
NAME="CELLSELECTFILLAFTER"
></A
><P
><B
>Figure 1-13. A selection of several cells, filled with the same values.</B
></P
><P
><IMG
SRC="images/selection-7.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="x222.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="autofill.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Copying and moving cells</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="editing.html"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Autofill</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>