Microsoft Office Tutorials and References
In Depth Information
Checking for Errors
Chapter 12
Setting Security and Printing Options
When users attempt to open the password-protect-
ed file, they see the Password dialog box shown in
Figure 12-9. Type the password, and then click OK.
If prompted, type the password to allow
modifications and click OK. The protected file opens.
Read-Only Recommendation
Optionally, check the Read-Only
Recommended option to recommend (not
require) that the users open the file as
readonly, which means before they can save the
file, they must assign it a different file name
or folder.
5. Click OK.
Figure 12-9
Enter the password to access the file.
6. Retype the password to open, and then click
OK. Retype the password to modify, and then
click OK.
7. Click Save and then click Yes if you're
prompted to overwrite the file.
Checking for Errors
Before you print or give your Excel file
to someone else, you should check it for
spelling errors. You want to eliminate typos
that can scream out to the world, “I can’t spell.”
Excel includes a built-in dictionary you can use to
check your workbooks for misspellings; however, it
can’t read your mind, so if you type too instead of
two, Excel probably won’t indicate that as an error.
But, combine the spell check with careful
proofreading on your part, and you’ll find it becomes a
very helpful tool.
Spell Check
Spell Check reviews all cell values,
comments, embedded charts, text boxes, buttons,
and headers and footers, but it does not
check protected worksheets, formulas, or text
that results from a formula.
Search JabSto ::




Custom Search