Microsoft Office Tutorials and References
In Depth Information
Exploring the Excel Window
Creating a Basic Worksheet
Selection indicator: Shows the address or
name of the currently selected cell. You can
also use this area to create or use a range
name. (See “Working with Range Names”
later in this chapter).
Horizontal scroll bar Vertical scroll bar
Insert Function button: Provides a means
to insert Excel functions. (See Chapter 9,
“Working with Formulas and Functions”).
Formula bar: Displays the contents of the
currently selected cell.
The worksheet scrollbars.
Scroll bars: The screen has both horizontal
and vertical scroll bars.
Sheet tabs: Each Excel file begins with
Also, by default, Excel displays three worksheets,
labeled Sheet1, Sheet2, and Sheet3. Clicking any
worksheet tab makes that Sheet appear on top of
the other worksheets (see Figure 8-3). You’ll learn
more about working with multiple worksheets in
Chapter 11, “Managing Large Amounts of Data.”
Moving Around the Screen
Each worksheet has 16,384 columns, beginning at
column A and extending to column XFD, and
1,048,576 rows. That gives you over seventeen
billion cells in a single worksheet in which you can
enter information! Because of the large size of an
Excel worksheet, you need ways to move around
quickly. You can use your mouse or keyboard to
move around a worksheet.
Using the Keyboard
As you have just discovered, you can use your
mouse to move around an Excel worksheet;
however, you may like using the keyboard better.
Table 8-1 describes keyboard methods for moving
around a worksheet.
Using the Mouse
Because there are over 17 billion possible cells in a
single worksheet, you may find that using the mouse
is an easy way to move around in the worksheet.
Click the mouse pointer on any cell to move the
active cell location to that cell. You can use the
scroll bars to see more of the worksheet. Both the
horizontal and vertical scroll bars have arrows at
each end to extend the worksheet scroll amount
(see Figure 8-2).