Microsoft Office Tutorials and References
In Depth Information
Learning Selection Techniques
Chapter 8
Creating a Basic Worksheet
Learning Selection Techniques
To move, copy, delete, or change
the formatting of data in a worksheet, you
must first select the cells you want to modify.
Selected cells appear darker onscreen—just the
reverse of unselected text, with the exception of
the first cell. The first cell does not appear darker;
it just has a dark border around it.
Look at the Mouse
Make sure the mouse pointer is a white cross
before attempting to select cells.
Figure 8-9
Selecting multiple rows.
To select more than one cell, perform one of the
following actions:
To select contiguous cells, click the first
cell, hold down the Shift key and select
the last cell you want to select. Excel
designates a contiguous cell range with a
colon dividing the beginning and end. For
example, B1:C3 means cells B1, B2, B3,C1,
C2 and C3 are included.
To select a single entire row, click the
row number. As the mouse is on the row
number it appears as a black arrow pointing
To select multiple rows, drag across
multiple row numbers, as seen in Figure 8-9.
To select a single entire column, click a
column heading. As the mouse is on the
column heading, it appears as a black arrow
pointing down.
Select a Contiguous Area
Optionally, drag the mouse over a group of
cells to select a contiguous area.
To select multiple columns, drag across
multiple column headings.
Search JabSto ::

Custom Search