Microsoft Office Tutorials and References
In Depth Information
Handling Special Printing Needs
3. Click the Printer Properties link under your
selected printer. Excel displays a dialog box
for your printer.
4. Click the Finishing tab and set the number
of pages you want to print on a single page
in the Pages Per Sheet drop-down menu, as
shown in Figure 10-4.
5. Click OK to close the Properties dialog box.
6. Print the document as usual.
Both sheets must be formatted with
the same page orientation.
Making Comments Visible
With Excel you can add comments to provide
context to the data in your worksheet; think of
them as an asterisk added to a data table you see
in a newspaper. For instance, you might want to
add a comment to your worksheet to explain
that sales were low in a given month because
the store had to be closed for a week during a
The Finishing tab.
Normally comments are visible on the
worksheet only as a small red triangle in the
upperright corner of the cell. As you move the mouse
pointer over a cell with a comment, a small
pop-up window displays the comment (see
Figure 10-6). You can learn more about adding
comments to a cell in Chapter 14, “Collaborating
Figure 10-5 illustrates an example with two
worksheets printed on a single page. A chart and its
associated data are presented together. Notice
that both worksheets are printed in a portrait
orientation. When printing multiple pages on
a single sheet, you will need to keep the same
page orientation for all worksheets.