Forum Discussion
Print a table on one page as multiple kolums.
Hello
What you need to do is a bit different that what I understood from the original question!!
You need to set MULTIPLE print areas and then print them side by side.
You my be able to do that in one of the following techniques:
Method One:
This post talks about the same issue:
https://excel.tips.net/T002779_Multiple_Print_Areas_on_a_Single_Printed_Page.html
Method Two:
Use the "Camera Tool" it's a hidden tool that you need to add to quick Access Toolbar. It will help you take a dynamic screenshot of the Four Ranges, put them side by side on another sheet, resize them the way you like then print the worksheet.
Alternatively you can copy each range and Paste Special AS LINKED PICTURE, then do the same as with the Camera tool.
Hope that helps
Nabil Mourad
Hi Both, agree with Nabil. I finally understand your requirements.
Try the following:
- Right-click a worksheet tab at the bottom of the window and click “Select All Sheets.” Or, hold down the Ctrl key and click individual sheets that you want to include in the printing.
- Click the small arrow to the bottom right of the Page Layout tab, which will default to the Page tab.
- Select the Fit To option under Scaling, and set it to 1 page wide by 1 page tall.
- Click the Print button this box.
- Select the Print Active Sheets button under the Setting header, then select Print Entire Workbook.
- Click Print.
Hope that helps
