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.
Formula Checking
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 fi 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.
 
 
Search JabSto ::




Custom Search