Microsoft Office Tutorials and References
In Depth Information
Setting worksheet options
You can display all comments on the worksheet by clicking the Show All Comments
button on the Review tab on the ribbon. This gives you an idea of how the worksheet
will look when printed if you select the As Displayed On Sheet option in the Comments
drop-down list on the Sheet tab of the Page Setup dialog box.
The drop-down list cryptically labeled Cell Errors As on the Sheet tab in the Page Setup
dialog box gives you options for how error codes displayed on the worksheet should be
printed. Ordinarily, error codes such as #NAME? are printed just as they appear on your
screen, but you can change this so that cells containing error codes print as blank cells or
with a double hyphen (--) or #NA displayed instead of the error code.
For more about creating comments, see “Adding comments to cells” in Chapter 8, “Work-
sheet editing techniques.” For more about error codes, see “Understanding error values” in
Chap ter 12.
If your printer offers a draft-quality mode, you can obtain a quicker, though less attractive,
printout by selecting the Draft Quality check box on the Sheet tab in the Page Setup dialog
box. This option has no effect if your printer has no draft-quality mode.
Translating screen colors to black and white
If you assigned colors and patterns to your worksheet, but you want to see what it will look
like when it’s printed on a black-and-white printer, select the Black And White check box
on the Sheet tab in the Page Setup dialog box, which tells Excel to use only black and white
when printing and previewing. You can see the results by clicking the Print Preview button
in the Page Setup dialog box, which is just a handy way of getting to the Print screen in
Backstage view—the same place you go by clicking the File tab on the ribbon and clicking
Setting the printing order of large print ranges
When you print a large report, Excel breaks the report into page-size sections based on
the current margin and page-size settings. If the print range is both too wide and too deep
to it on a single page, Excel ordinarily works in “down and then over” order. For example,
suppose your print range measures 120 rows by 20 columns and that Excel can it 40 rows
and 10 columns on a page. Excel prints the first 40 rows and first 10 columns on page 1, the
second 40 rows and first 10 columns on page 2, and so on, until it prints all the rows and
starts at the top of the next 10 columns. If you prefer to have Excel print each horizontal