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 file so that all of the information
fits onto one page
Note that the three practice problems at the end of this chapter require you to sort
random numbers when the files contain 63 test tubes, 114 steel samples, and 75 field
mice, respectively. These files will be “too big” to fit onto one page when you print them
unless you format these files so that they fit onto a single page when you print them.
Let’s create a situation where the file does not fit onto one printed page unless
you format it first to do that.
Go back to the file you just created, Random 33, and enter the name: Jennifer
into cell: A52.
If you printed this file now, the name, Jennifer , would be printed onto a second
page because it “dribbles over” outside of the page rage for this file in its current
format.
So, you would need to change the page format so that all of the information,
including the name, Jennifer, fits onto just one page when you print this file 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 ::




Custom Search