It’s not essential to adjust the page setup settings to remove page breaks. Click the Next button to open printing options. You can press the Up and Down buttons to rearrange the cell range references. That opens a Print Multiple Selections Wizard from which you can select the cell ranges to include on the printout.Ĭlick the + button on the dialog box to select the cell ranges to include on the page printout.

Click the Enterprise tab, press the Printing button and select Print Multiple Selections Wizard. When you’ve added Kutools to Excel, you can remove page breaks from multiple printout areas with the Print Multiple Selection Wizard tool.

That’s an add-on with more than 200 additional Excel tools, which is retailing at $39. This wastes paper, but you can print multiple cell ranges onto a single sheet of paper with the Kutools add-on. Consequently, each printout area prints on separate paper. If you select multiple print areas in an Excel spreadsheet, Excel includes page breaks between them. Print Multiple Cell Ranges in One Page with Kutools Now the printed output will include just the chart and the selected empty cells. Then click Print Area and Set Print Area to set up the printing area. Alternatively, select the range of blank cells that include the graph to be the printed area as shown below.

How to print quicken reports to excel