<HTML
><HEAD
><TITLE
>Selecting Cells While Entering Formulas.</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="Cell Referencing"
HREF="cell-referencing.html"><LINK
REL="NEXT"
TITLE="Copying and moving cells"
HREF="x222.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="cell-referencing.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="x222.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="AEN176"
>Selecting Cells While Entering Formulas.</A
></H1
><P
>When entering a formula into a cell, it is possible to use the
    mouse and the keyboard cursor keys to quickly enter data.</P
><P
>There are several ways to enter a cell range into a formula. Cell
    ranges and references can be entered into a formula simply by typing in
    the proper syntax (see <A
HREF="cell-referencing.html"
>the section called <I
>Cell Referencing</I
></A
> for more details).
    But manually entering in cell ranges is slow and cumbersome. </P
><P
>When entering data into a cell, and the cursor is at a point
    where a cell reference is appropriate, it is possible to define a cell
    reference by selecting a cell via the mouse or keyboard. This selection
    is a little different from the ordinary selection. It is highlighted
    by a "marching ants" border. </P
><DIV
CLASS="FIGURE"
><A
NAME="EDITING-CELL-SELECTION"
></A
><P
><B
>Figure 1-2. The highlighted selection</B
></P
><P
><IMG
SRC="images/editing-cell-selection-1.jpg"></P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN186"
>Entering data into a formula with the mouse</A
></H2
><P
>When entering a formula, if the cursor is at a point
      where a cell reference may be appropriate, the user just needs
      to click on a cell to automatically enter its cell reference 
      into the formula. Then finish the formula as normal.</P
><DIV
CLASS="PROCEDURE"
><P
><B
>Using the mouse to enter a cell reference into a formula</B
></P
><OL
TYPE="1"
><LI
><P
>	  Select a cell to enter a formula into. For example A1.
	</P
></LI
><LI
><P
>Enter a formula, but stop the cursor at a point
	  where a cell reference is appropriate. For this example,
	  =exp( 
	</P
></LI
><LI
><P
>	  Now use the mouse to click on another cell to reference. For example,
	  just click on the Cell B1. Its reference will be entered into the formula
	  in cell A1.
	</P
></LI
><LI
><P
>	  To finish the formula, just type in the closing parenthesis. This will
	  also "unselect" the region.
	</P
></LI
></OL
></DIV
><P
>This can be used to select a range of cells just like regular selections. </P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN200"
>Entering data into a formula with the keyboard.</A
></H2
><P
>If entering lots of formulas or even just entering a few formulas, it is
      often quickest to use the keyboard to select cells and ranges of cells for use
      in formulas. Just as reaching a input point allows the user to select cells 
      with the mouse, it is possible to use the keyboard to select cells. Just use 
      the cursor keys and selection modifiers to create a selection.</P
><DIV
CLASS="PROCEDURE"
><P
><B
>Using the keyboard to enter data into a formula.</B
></P
><OL
TYPE="1"
><LI
><P
>	  Select a cell to enter a formula into. For example A1.
	</P
></LI
><LI
><P
>Enter a formula, but stop the cursor at a point
	  where a cell reference is appropriate. For this example,
	  =SUM( 
	</P
></LI
><LI
><P
>	  Move the selection around with the cursor keys. Move the selection
	  cursor to cell B1 to start the selection.
	</P
></LI
><LI
><P
>	  Hold down <B
CLASS="KEYCAP"
>Shift</B
> and move the selection one cell
	over and one cell down. Cells B1,B2,C1,C2 should now be selected and
	the formula should show =sum(B1:C2 
	</P
></LI
><LI
><P
>	  To finish the function, close the parenthesis. The cell should
	  now show =sum(B1:C2). Press enter and the formula is entered.
	</P
></LI
></OL
></DIV
><P
>To select a range of cell, hold <B
CLASS="KEYCAP"
>Shift</B
> and  move over the desired area.</P
><P
>To stop entering a selection or to start over, press <B
CLASS="KEYCAP"
>Shift</B
>-<B
CLASS="KEYCAP"
>Backspace</B
></P
></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="cell-referencing.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="x222.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Cell Referencing</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="editing.html"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Copying and moving cells</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>