Suppressing Page Break

RichSoz

New Member
Joined
May 8, 2002
Messages
2
In Lotus, I had created a macro to print two dis-similar spreadsheets onto
the same page, first over the second.

How do I suppress the page break at the bottom of the first spreadsheet, so that I can do a similar thing in Excel?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Brian:
Thanks for the info, but pasting two to one sheet does not work because the columns are dis-similar.
I just need to print the first sheet and suppress the page feed to "hold the image still" while I print the second sheet.
Kind of - access to printer controls.
Rich
 
Upvote 0
On 2002-05-09 15:51, RichSoz wrote:
In Lotus, I had created a macro to print two dis-similar spreadsheets onto
the same page, first over the second.

How do I suppress the page break at the bottom of the first spreadsheet, so that I can do a similar thing in Excel?

You could try the Repoprt Manager accessed via VIEW|Report_Manager and set up a report consisting of various sections. I am not sure if it will meet your needs regarding different sections on being the same page.

And of course you can always hide the rows you do not want to print, and then print it as a continuous report.

Regards!
 
Upvote 0

Forum statistics

Threads
1,213,530
Messages
6,114,163
Members
448,554
Latest member
Gleisner2

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