Microsoft Office Tutorials and References
In Depth Information
Worksheet Window EX 9
Worksheet Window
The Worksheet Size
and Window
Excel’s 16,384 columns
and 1,048,576 rows
make for a huge
worksheet that – if you
could imagine – takes
up the entire side of a
building to display in its
entirety. Your computer
screen, by comparison,
is a small window that
allows you to view only
a minute area of the
worksheet at one time.
While you cannot see the
entire worksheet, you
can move the window
over the worksheet to
view any part of it.
You view the portion of the worksheet displayed on the screen through a worksheet
window (Figure 1–6). The default (preset) view is normal view . Below and to the right of
the worksheet window are scroll bars , scroll arrows , and scroll boxes that you can use
to move the worksheet window around to view different parts of the active worksheet. To
the right of the sheet tabs at the bottom of the screen is the tab split box. You can drag the
tab split box to increase or decrease the view of the sheet tabs (Figure 1–6). When you
decrease the view of the sheet tabs, you increase the length of the horizontal scroll bar,
and vice versa.
Status Bar
The status bar is located immediately above the Windows taskbar at the bottom
of the screen (Figure 1–6). The status bar presents information about the worksheet,
the function of the button the mouse pointer is pointing to, or the mode of Excel. Mode
indicators , such as Enter and Ready, appear on the status bar and specify the current
mode of Excel. When the mode is Ready , Excel is ready to accept the next command or
data entry. When the mode indicator reads Enter , Excel is in the process of accepting
data through the keyboard into the active cell.
Keyboard indicators , such as Scroll Lock, show which toggle keys are engaged.
Keyboard indicators appear to the right of the mode indicator. Toward the right edge of
the status bar are buttons and controls you can use to change the view of a document and
adjust the size of the displayed document.
Increasing the
Viewing Area
You can increase the size
of the Excel window or
viewing area to show
more of the worksheet.
Two ways exist to
increase what you can
see in the viewing area:
(1) on the View tab on
the Ribbon, click Full
Screen; and (2) change
to a higher resolution.
See Appendix E for
information about how
to change to a higher
The Ribbon , located near the top of the Excel window, is the control center in
Excel (Figure 1–7a). The Ribbon provides easy, central access to the tasks you perform
while creating a worksheet. The Ribbon consists of tabs, groups, and commands. Each tab
surrounds a collection of groups, and each group contains related commands.
formula bar
Home tab
top-level tabs
Name box
formula bar
sizing handle
formula bar
expand button
(a) The Excel Ribbon
top-level tabs
(b) The Excel Ribbon Minimized
Figure 1–7
Search JabSto ::

Custom Search