There are several ways to print your Excel files. You can print all or part of a worksheet, select the orientation (portrait or landscape), set margins and line breaks, etc..
However, a valuable feature spreadsheets software is the ability to scale the document to be printed, so that all your data (tables) hold on a single page or a predefined number of pages, simply by defining the magnification ratio:
Under Excel go to the File menu, click Page Setup, and then click the Page tab > Scaling section.
Reduce/enlarge to ...% of normal size and select the number of pages you want to use to display your data.
Most spreadsheets can also print the hidden contents of your spreadsheets, such as formulas, which can be valuable in certain situations.