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.