Microsoft Office Tutorials and References
In Depth Information
6.8 Printing Only Part of a Spreadsheet Instead of the Entire
Objective: To print part of a spreadsheet separately instead of printing the entire
There will be many occasions when your spreadsheet is so large in the number
of cells used for your data and charts that you only want to print part of the
spreadsheet separately so that the print will not be so small that you cannot read it
We will now explain how to print only part of a spreadsheet onto a separate
page by using three examples of how to do that using the ﬁle, eggs37, that you
created in Sect. 6.6 : (1) printing only the table and the chart on a separate page, (2)
printing only the chart on a separate page, and (3) printing only the SUMMARY
OUTPUT of the regression analysis on a separate page.
Note: If the ﬁle: eggs37 is not open on your screen, you need to open it now.
Let’s describe how to do these three goals with three separate objectives:
6.8.1 Printing Only the Table and the Chart on a Separate Page
Objective: To print only the table and the chart on a separate page
1. Left-click your mouse starting at the top left of the table in cell A3 and drag the
mouse down and to the right so that all of the table and all of the chart are
highlighted in light blue on your computer screen from cell A3 to cell H48 (the
light blue cells are called the ‘‘selection’’ cells).
Print Active Sheet (hit the down arrow on the right)
The resulting printout should contain only the table of the data and the chart
resulting from the data.
Then, click on any empty cell in your spreadsheet to deselect the table and
6.8.2 Printing Only the Chart on a Separate Page
Objective: To print only the chart on a separate page
Search JabSto ::