How to print multiple print areas on one page in Excel?
For example I have set three print areas (A1:B9, E10:E14, and D21:G34) in one worksheet. When I print active worksheet, each print area stays on a separate page. If we need to print all print areas on one page, how can we do? This article will share some solutions to solve it in Excel.
Excel Productivity Tools
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 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
This method will guide you to copy each print area and paste as linked picture in a new worksheet so as to print them on one page. Please do as follows:
1. Create a new worksheet with clicking theor button on the Sheet Tab bar.
2. Go ahead to select one print area and copy it with pressing the Ctrl + C keys in a meanwhile.
3. Go to the new worksheet, select a blank cell, right click and select Paste Special > Linked Picture (I). See screenshot:
Note: If you are using Excel 2007, please click Home > Paste > As Picture > Paste Picture Link.
4. Repeat Step 2 and Step 3 to copy and paste other print areas as linked pictures in the new worksheet.
5. Keep staying in the new worksheet, and click File (or Office button) > Print to print these print areas.
Kutools for Excel’s Print Multiple Selection Wizard will greatly simplify your work to print multiple print areas on one page easily. Please do as follows:
Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel
1. Go to the worksheet with the print areas, and press F5 key to open the Go To dialog box.
2. In the Go To dialog box, click to select the Print_Area in the Go to box, and click the OK button.
Now all print areas are selected in active worksheet.
3. Click Enterprise > Printing > Print Multiple Selection Wizard to open the Print Multiple Selection Wizard.
4. In the Print Multiple Selection Wizard, click Finish button.
(1) All selected ranges are added to the Ranges to print list automatically.
(2) Click Add button to add other selections; select a selection in the Ranges to print list, and click the Delete button to remove it from the list.
5. Now all print areas are copied and pasted as pictures in a new worksheet. Keep staying in the new worksheet, and click File (or Office button) > Print to print these print areas.
Kutools for Excel's Print Multiple Selections Wizard can help Excel users to print multiple selections from different sheets together without page breaks (on one page).