Microsoft Office Tutorials and References

In Depth Information

**Formula Checking**

2

•
Click the Hide button

on the Ribbon to hide

the Braden Mortgage

workbook.

Unhide

button

workbook

hidden

3

•
Click the Unhide

button on the

Ribbon.

Unhide

dialog box

•
When Excel displays

the Unhide dialog

box, if necessary, click

Braden Mortgage

Loan Payment

Calculator in the

Unhide workbook list

(Figure 4–63).

name of

hidden

workbook

OK button

What else can I hide?

You can hide most

window elements

in order to display

more rows of

worksheet data.

These window

elements include

the Ribbon, formula

bar, and status bar.

The Excel window

elements can be

hidden by using the

Full Screen button

on the View tab on

the Ribbon (Figure 4–62

on the previous page).

These elements remain hidden only as long as the workbook is open. They redisplay when

you close the workbook and open it again.

Figure 4–63

4

•
Click the OK button to unhide the Braden Mortgage Loan Payment Calculator workbook as

it was shown in Figure 4–62 on the previous page.

Similar to the spell checker, Excel has a
formula checker
that checks formulas in a worksheet

for rule violations. You invoke the formula checker by clicking the Error Checking command

on the Tools menu. Each time Excel encounters a cell with a formula that violates one of

its rules, it displays a dialog box containing information about the formula and a suggestion

on how to ﬁ x the formula. Table 4–4 lists Excel’s error checking rules. You can choose

which rules you want Excel to use by enabling and disabling them in the Formulas area in

the Excel Options dialog box shown in Figure 4–64 on page EX 320.