Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-05-2014, 12:47 PM
whatsup whatsup is offline changing dpi affects excel pages Windows 7 64bit changing dpi affects excel pages Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Julia, are you sure the resolution of your monitor is set right? Depending the type of monitor you can change the resolution to a minor setting (via control panel --> Adjust screen resolution), which results in bigger textsize.



If you want to increase temporarly the size of text you can use the magnifier tool. Ask windows help if you don't know where to look for it.

... no other idea on this

I had a look at your file:
I guess you do adjust your pages to the pagebreaks excel is offering. This suggestions are merely done by the type of paper the printer is set to in order to observe the margins you set.
Now depending the computer I'm using here, the printout will vary:
Windows XP, Excel 2002 won't print your Pg.3 and 4 on one page
Windows 7 (dpi 100%, 96 ppi), Excel 2010 only won't print Pg. 4 on one paper, the others are fine
... but well that was using format A4 in the printer. What type of paper you are using?

Maybe you can try to setup printarea manually. Save a copy of your file before following this steps:
Have a look at
Menue ---> Insert ---> Names ---> define
In the dialog you will find a name (like) "printarea" refering to a range (probably):
=Sheets1!$B$1:$G$220
Mark this formula and replace it by:
=Sheet1!$B$1:$G$50,Sheet1!$B$52:$G$93,Sheet1!$B$95 :$G$138,Sheet1!$B$140:$G$179,Sheet1!$B$181:$G$218
Afterwards you set the margins of right and bottom to 0 (zero).

Have a look at the print preview to check if anything has changed. Still, only a printout will proove if the printer can handle it the way preview it shows.

I know that's quite a job, and probably only the start if you intend to send the whole file to other people. But unless you don't change the outlay I can't think of another way to get it right.

Edit:
Wrong formula, of course you have to replace it by:
=Sheet1!$B$1:$G$50,Sheet1!$B$53:$G$93,Sheet1!$B$96 :$G$138,Sheet1!$B$141:$G$179,Sheet1!$B$182:$G$218

Last edited by whatsup; 06-05-2014 at 04:36 PM.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Print selected pages as per excel value DingDang Word 0 03-17-2014 02:14 AM
changing dpi affects excel pages Reading Pane affects Outlook 2003 bhaza Outlook 2 01-12-2011 03:01 PM
Word 2003 affects on Browser viewing Xandr Word 0 01-09-2010 11:24 AM
Bulletizing one paragraph affects all paragraphs GoodWebby Word 0 10-10-2009 12:09 PM
How Do I Create Excel Web Pages With Java highbids Office 0 04-13-2006 06:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft