Excel 2003, Level 1 Page 2
September 2005
Section 2 – Navigating Spreadsheets in Excel
U
U
s
s
i
i
n
n
g
g
C
C
o
o
l
l
u
u
m
m
n
n
s
s
a
a
n
n
d
d
R
R
o
o
w
w
s
s
Data are entered in columns (vertical) and rows (horizontal). Columns are
lettered A-Z (then AA-AZ, BA-BZ, and so on, through column IV). Rows
are numbered. There are 256 columns and 65,536 rows in every
spreadsheet. That’s a total of more than 16 million cells per sheet! A cell
is the intersection of a column and a row. (Example, cell A1 is at the
intersection of column A, row 1.)
S
S
c
c
r
r
o
o
l
l
l
l
i
i
n
n
g
g
T
T
h
h
r
r
o
o
u
u
g
g
h
h
t
t
h
h
e
e
S
S
p
p
r
r
e
e
a
a
d
d
s
s
h
h
e
e
e
e
t
t
Clicking on a cell selects that cell. When a cell is selected, the Name Box
indicates which cell is active, and the formula bar displays the contents of
that cell. Note that the formula may be different than what is displaying in
the cell when you look at the spreadsheet.
name box formula bar
Entering and editing text is accomplished by double-clicking the mouse
pointer over the desired place and clicking a fine area in the cell called the
“insertion point.” This is the point at which text will begin to be entered, a
selection will begin, or a graphic or other file will be inserted. The mouse
arrow changes to a text selection pointer called the “I-Beam” pointer.
1. Open the file called
“Introduction.xls” Click on cell B7.
The Name Box indicates that B7 is the
active cell. Click in another location,
and the Name Box changes.
2. To select multiple cells, click in the
middle of on cell, then drag-select the
desired range of cells using the large
white cross pointer (®).
3. Scroll using the scroll bar arrows on the right side of the screen. Note
that as you scroll, the active cell does not change. Also try scrolling by
clicking above or below the scroll button, as well as dragging and
dropping the scroll button itself. Use the horizontal scroll bar to view
additional columns; use the vertical scroll bar to view additional rows.