Printing issues - When try to print all column on one page

popinz

New Member
Joined
Dec 29, 2011
Messages
23
Hi,

I'm not sure how this happens but sometime when I try to print an excel spreadsheet and I select print all column on one page it would print super tiny because it would include blank cells.

I have check the following to ensure this was not causing the issue:
Make sure there is no white background ( like when someone select a full row or column instead of selected the needed one only... )
Remove print areas
remove page break

I know this is something being done because these spreadsheetwith issues ALWAYS come from the same person ...
anyone has any clue what could cause this so I can properly train the person and avoid these issues...
FYI what I usually do to fix this is select all and copy paste it in a blank page...

Thanks a bunch for the help and have a great day!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

jamtay317

Well-known Member
Joined
Mar 6, 2013
Messages
769
do not select the entire row, just select the range that you want to print and then under page layout choose set print area.
 

popinz

New Member
Joined
Dec 29, 2011
Messages
23
Yes I sure know that and I am used to fix this issue but like I said I did verify to ensure that was not what happen... I just can't explain that :( ... but thanks for the reply :)
 

Forum statistics

Threads
1,137,060
Messages
5,679,382
Members
419,824
Latest member
Mercy kiara

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
Top