If all 4.2 million cells on a spreadsheet were to be printed out, they would take up hundreds of pages. Although Excel can detect the used and unused areas of a spreadsheet and print out only the necessary sections, it is important to use the PAGE SETUP under the File menu to set up your spreadsheet. The Page Setup has 4 tabs at the top of it, referring to different items to configure.
At any time, you can get an idea of how your spreadsheet would look on paper by
clicking on the Print Preview button.
This will show the page(s) on which would the spreadsheet would
print. In print preview, you have the ability to zoom in on certain sections of your
spreadsheet so they can be inspected, and you can instantly go to Page Setup to make any
necessary changes.