Microsoft Office Tutorials and References
In Depth Information
5, 6, 15, 16, 32
Save this ﬁle as: Random33
Remember, your ﬁve ID numbers selected after your random sort will be
different from the ﬁve ID numbers in Fig. 2.9 because Excel assigns a different
random number each time the =RAND() command is given.
Before we leave this chapter, you need to learn how to print a ﬁle so that all of
the information on that ﬁle ﬁts onto a single page without ‘‘dribbling over’’ onto a
second or third page.
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: A50.
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 ::