Microsoft Office Tutorials and References

In Depth Information

**The Status Bar**

A Tour of the Excel

Window

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.

Collapse

(or expand)

the formula

bar

Scroll the

contents of

the formula

bar

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.