Printing in a workbook.

[cyruschan]

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!

 

[mrshl9898]

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.

 

[cyruschan]

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.

 

[Little_Clubber]

Re: Help! Printing in a workbook. Please advise.

Attachments are not allowed. Can you post an image online and then link it to your post like this:

https://www.mrexcel.com/forum/misc.php?do=bbcode#imgcode

 

[cyruschan]

Re: Help! Printing in a workbook. Please advise.

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

 

[cyruschan]

Re: Help! Printing in a workbook. Please advise.

https://imgur.com/a/AxlGGDW