Specific print output - page with frozen panes

Imh0tep

New Member
Joined
Feb 7, 2019
Messages
14
Hello,


I would like to print attached sheet with frozen panes (two rows + five columns) on one A4 as follows.


I have set print titles according to instructions on this page.

https://excel.tips.net/T002702_Printing_Just_the_Visible_Data.html

Afterthat I select range F3:AC10 and then print selection (selected area).


The output looks like this




I select by analogy range AD3:AS10 and then print selection...

This output looks like this




Is there any way (for example with help of VBA commandbutton?) how to print both outputs on one page as follows? (I have used graphic editor to join both pictures in one page in order to show how the output should look).



It would be really great if you can help me with this issue.


here is the link for download

https://wetransfer.com/downloads/a15747408a65d80c33db055fd4a2792320191010120340/aded4f


Thank you very much


Miroslav
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,099,386
Messages
5,468,298
Members
406,579
Latest member
lollypop1389

This Week's Hot Topics

Top