How to print each sheet on separate page?
Imagine that you have a lot of worksheets within a workbook, and the content in each sheet is a little more than one page. But now, you want to print each sheet just on separate one page to save the paper. Do you have any good ideas to deal with this problem?
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Excel provides us with a feature to solve this job quickly and easily, please do with following steps:
1. Click one sheet tab and right click to choose Select All Sheets from the context menu, see screenshot:
2. After selecting all sheet tabs, then click Page Layout > Page Setup icon, see screenshot:
Tip: You also can go to File > Print > Page Setup to open the Page Setup dialog.
3. In the Page Setup dialog box, under Page tab, check Fit to from the Scaling section, and then make sure that it is set to 1 page(s) wide by 1 tall, see screenshot:
4. Then you can click Print Preview button to view the result as you want. When you print them, all pages within one sheet will be printed on only one page.