Microsoft Office Tutorials and References
In Depth Information
Fig. 2.10 Dialogue Box for Page Layout / Scale to Fit Commands
2.4 Printing an Excel File So That All of the
Information Fits Onto One Page
Objective : To print a ﬁle so that all of the information
ﬁts onto one page
Note that the three practice problems at the end of this chapter require you to sort
random numbers when the ﬁles contain 63 test tubes, 114 steel samples, and 75 ﬁeld
mice, respectively. These ﬁles will be “too big” to ﬁt onto one page when you print them
unless you format these ﬁles so that they ﬁt onto a single page when you print them.
Let’s create a situation where the ﬁle does not ﬁt onto one printed page unless
you format it ﬁrst to do that.
Go back to the ﬁle you just created, Random 33, and enter the name: Jennifer
into cell: A52.
If you printed this ﬁle now, the name, Jennifer , would be printed onto a second
page because it “dribbles over” outside of the page rage for this ﬁle in its current
So, you would need to change the page format so that all of the information,
including the name, Jennifer, ﬁts onto just one page when you print this ﬁle by using
the following steps:
Page Layout (top left of the computer screen)
(Notice the “Scale to Fit” section in the center of your screen; see Fig. 2.10 )
Search JabSto ::