Microsoft Office Tutorials and References
In Depth Information
This shows the Page Setup dialog box (Figure 14-38), which holds a few of
Excel’s more specialized print settings. The Page Setup dialog box is organized
into several tabs. The Page and Margins tabs duplicate settings that are provided
elsewhere in Backstage view. The Header/Footer tab isn’t the most convenient
way to add a header or footer (instead, see page 407). However, the Sheet tab has
a number of options you won’t find anywhere else:
— Print area lets you specify the range of cells you want to print. While this
tool definitely gets the job done, it’s easier to use the Print Area tool (de-
scribed in the box on page 404). And some people find that the Print
dialog box’s Selection setting (step 4) is an easier approach to printing small
groups of cells.
— Print titles lets you print specific rows at the top of every page, or specific
columns on the left side of every page (see Figure 14-39). For example, you
could use this setting to print column titles on the top of every page.
— Gridlines prints the grid of lines separating columns and rows that you see
on your worksheet.
— Row and column headings prints the column headers (which contain the
column letters) at the top of each page and the row headers (with the row
numbers) on the left side of each page.
— Black and white tells Excel to render all colors as a shade of gray, regardless
of your printer settings.
— Draft quality tells Excel to use lower-quality printer settings to save toner
and speed up printing, assuming your printer has these features, of course.
— Comments lets you print any comments that you’ve added to a worksheet.
Excel can either append them to the cells in the printout or add them at the
end of the printout, depending on the option you select.
— Cell errors lets you configure how Excel should print a cell if it contains a
formula with an error. You can choose to print the error that’s shown (the
standard option), or replace the error with a blank value, two dashes (--),
or the error code #N/A (meaning not available). You’ll learn much more
about formulas in Chapter 17.
— Page order sets the way Excel handles a large worksheet that’s too wide
and too long for the printed page’s boundaries. When you choose “Down,
then over” (the standard option), Excel starts by printing all the rows in the
first batch of columns. Once it’s finished this batch, Excel then moves on to
the next set of columns, and prints those columns for all the rows in your
worksheet, and so on. When you chose “Over, then down,” Excel moves
across your worksheet first. That means it prints all the columns in the first
set of rows. After it’s printed these pages, it moves to the next set of rows,
and so on.