Printing in a workbook.

cyruschan

New Member
Joined
Aug 11, 2014
Messages
7
Hello all,

When I am trying to print, the pages contains too much white space and doesn't take up the entire page or have my data too small.

Please advise what I can do.

For the first tab, I am trying to print the data onto 3 pages(portrait) but there is too much white space.
How can I have the text take up most of the page. I have chosen 3 pages and the page breaks are where I would like the data to be divided.

For my second tab, when I go into print preview, there is a big white space to the data. I want Column S to be the last column to be included and my print area to display what I have set in the page break view . 1 page(landscape)

For my third tab, I would like to have the info take up almost a whole page(landscape).

Any pointers would be greatly appreciated and I would to apply this going forward.

Thank you all in advance and have a great day!
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Re: Help! Printing in a workbook. Please advise.

If you press ctrl+P there's a scaling option, fit to page, fit columns to page etc.

Hard to say what you're looking at exactly, but between playing with that and the column and row heights and widths you should be able to sort out something that suits your needs.
 
Upvote 0
Re: Help! Printing in a workbook. Please advise.

Hi, I have tried that but no luck, is there a way I can show it to you?

Thanks.
 
Upvote 0
Re: Help! Printing in a workbook. Please advise.

Too much space here shown. [FONT=&quot]https://imgur.com/gLv4qAo[/FONT]
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,988
Members
448,538
Latest member
alex78

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