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

Snap1.jpg



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

This output looks like this

Snap2.jpg



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).

complet.jpg


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
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top