Microsoft Office Tutorials and References
In Depth Information
The Status Bar
A Tour of the Excel
You can use the formula bar to enter and edit data, instead of editing directly in your
worksheet. This approach is particularly useful when a cell contains a formula or a
large amount of information. That’s because the formula bar gives you more work
room than a typical cell. Just as with in-cell edits, you press Enter to confirm your
changes or Esc to cancel them. Or you can use the mouse: When you start tying in
the formula bar, a checkmark and an “X” icon appear just to the left of the box where
you’re typing. Click the checkmark to confirm your entry or “X” to roll it back.
Note: You can hide (or show) the formula bar by choosing View➝Show➝Formula Bar. But the formula
bar is such a basic part of Excel that you’d be unwise to get rid of it. Instead, keep it around until Chapter
17, when you’ll learn how to build formulas.
Ordinarily, the formula bar is a single line. If you have a really long entry in a cell (like
a paragraph’s worth of text), you need to scroll from one side to the other. However,
there’s another option—you can resize the formula bar so it fits more information, as
shown in Figure 14-11.
Drag here to resize the formula bar
Figure 14-11:
To enlarge the formula
bar, click the bottom
edge and pull down.
You can make it two,
three, four, or many
more lines large. Best
of all, once you get
the size you want, you
can use the expand/
collapse button on
the right side of the
formula bar to quickly
expand it to your
preferred size and
collapse it back to the
single-line view.
(or expand)
the formula
Scroll the
contents of
the formula
The Status Bar
Though people often overlook it, the status bar (Figure 14-12) is a good way to keep
on top of Excel’s current state. For example, if you save or print a document, the
status bar shows the progress of the printing process. If you’re performing a quick
action, the progress indicator may disappear before you have a chance to even notice
it. But if you’re performing a time-consuming operation—say, printing out an 87-
page table of the airline silverware you happen to own—you can look to the status
bar to see how things are coming along.
Search JabSto ::

Custom Search