Microsoft Office Tutorials and References
In Depth Information
Selecting Cells on a Spreadsheet
Now that you know how to enter data
into a spreadsheet, you will need to know how
to select cells. You already know that you can use
the mouse to click on a specific cell, the active
cell, so you already know a little something about
selecting cells on a spreadsheet. However, what
do you do if you want to select more than one
cell? Selected cells are called cell ranges. A cell
range can be a single cell, which is also called
the active cell, or an entire spreadsheet, and
anything in between.
Using the Mouse
By far the most common method for selecting
cell ranges in Excel is to click one cell and then
drag the mouse over the rest of the desired cells.
Try these other methods for selecting cell ranges
with the mouse:
Select an entire row by clicking the row
Select multiple adjacent rows by dragging
the mouse over several row numbers, as
shown in Figure 1-16.
Mouse Pointer Shape
Select an entire column by clicking the
Make sure that the mouse pointer is shaped
like a white cross before trying to select cells.
Select multiple adjacent columns by
dragging the mouse over several column
Select non-adjacent cells by clicking the
first cell, then holding down the Ctrl
key while you click each addition cell,
or range of cells, you want to include in
Excel indicates a cell range has been selected by
highlighting it, as illustrated in Figure 1-15. As
you can see, the selected cells do not have to be
adjacent to each other to be selected.
Mouse Pointer Shape, Part II
The mouse pointer will change from a white
cross to a black arrow whenever the mouse
is positioned over a row or column heading.
This change indicates that the action will
affect the entire row or column.
Several cell ranges selected in Excel 2010.