Microsoft Office Tutorials and References
In Depth Information
Selecting Multiple Cells
Remember that when you travel to any cell the current location of the cell pointer is
always recorded in the Name Box.
Selecting Multiple Cells
In the course of your spreadsheet activity you may decide that you need to highlight, or
select , more than one cell at a time. Why? There are several reasons you may want to
do this, including these:
You want to format the data in a group of cells all at the same time.
For example: You want a group of numbers—perhaps a very large
group—to display that currency format we spoke about earlier. By
selecting all those cells simultaneously you can introduce the currency
format to all of them, rather than having to change each cell
individually. (See Chapter 4.)
You may want to copy, or move, or delete, a group of cells at the
same time. (See later this chapter.)
You may want to print some, but not all the cells, in a worksheet. To
carry this out, you’d first need to select just the cells you want to print.
(See Chapter 8.)
You may want to subject a group of cells to a mathematical
operationsay, add the numbers in certain cells. (See Chapter 3.)
Selecting multiple cells, then, is your way of informing Excel exactly which cells you
want to modify or work with.
There are several related ways in which you can select cells, and they’re all pretty easy.
The standard way is simply to click in the first cell you want to select, hold down the left
button, and drag with your mouse across, or down, the other cells. The technique is
very similar to the way you’d select a group of words in Word.
Thus if I wanted to select cells A6 through A19 I’d
1.
Click cell A6.
2.
Hold the left mouse button down.
3.
Drag to cell A19.
4.
Release the mouse.
Carry out this sequence, and again, your screen should look like this:
 
Search JabSto ::




Custom Search