Table of Contents
Advertisement
Like individual
cells, ranges
have
addresses.
A range
address
consists
of the
address
of the upper
left cell, followed
by a colon
(:), followed
by the
address
of the lower
right cell. In the illustration
on the previous
page,
the address
for the selected
range is B3:D13.
Todeselect a cell,
selectsomething else.
When an area is locked
with the L'ockTittes
command (rows or
columns),you cannot
change any information
or format of the cells in
the locked area. See
page 118in this chapter.
• To select a single cell:
Click on the cell you want
to select.
OR
Double-click
on the cell address
that appears
in the Edit bar, type the address
of the cell you want
to select,
and then
press
ENTER.
OR
Select
Go to Cell from
the View menu,
type the address
of the cell you want
to select,
and then
click on Go To.
• To select a range of cells:
Drag from the first cell to the last cell of the range you want to select.
OR
If you attempt to
enter the locked
area via the View/Go_
1_ Cell menu item,
the following
message appears:
The selected cell is
located in the locked
area. Unlock the
titles and try the
operation again.
Select Go to Cell from the View menu, type the address of the cells you want
to select
(for example,
AI:H10),
and then
click on Go To.
• To select an entire row or column:
Click on the row or column
header.
• To select multiple
rows or columns:
Drag from the first row
or column
header
to the last row or column
header.
Spreadsheet
highlights
the rows or columns
as you drag.
Spreadsheet
70
Advertisement
Table of Contents
