Print Selection - text running off page?

Posted on 2011-09-28
Last Modified: 2013-11-05
I have a user with a fresh install of Office 2010. More specifically, no matter what excel file they open and try to select a certain block of text to print Excel shows the print preview of text running off the end of the page at the bottom. Also note they are using the "Print Selection" instead of the "Active Sheet". When they print the entire active sheet, the print preview looks normal - the problem only occurs when printing a selection. On my own PC Excel will simply put the overflowed text on to a new page to be printed on.

I've tried re-installing Office and going over all relevant settings for printing. It doesn't matter what printer is used either they all do the same. When the document actually is sent to the printer it looks exactly like the print preview as well - text running off the bottom.

The text is set to 95% and fits within the margins as well. I'm stumped as to why this happening only for this user.

Windows XP SP3
Office 2010

Any help is appreciated! Thanks
Question by:DickJansen
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5

Expert Comment

by:Leo Torres
ID: 36812916

Have you tried to set the print area as well...
I have seen this before I but don't remember how i solved it or if I did at all

try also open the run window and type  
excel /s
hit enter and see if you can also replicate this error in safe more

Author Comment

ID: 36815931
The print area defines a selection. That setting is grayed out in the print dialog when selecting "Print Selection" - it only applies when printing the "Active Worksheet".

I also tried running excel in safe mode but the problem still persists. I've tried removing one of the printers and adding it back in, but the same results still appear.

Thanks for the input.

Expert Comment

by:Leo Torres
ID: 36816275
Can we try selecting this area in question on the active page and just look at print preview to see if.. this still happens.

Another test can you save this particular file and try it on another PC runing the same version of office..

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.


Author Comment

ID: 36816456
Yes, it happens on print preview as pointed out above. I took the file and opened it up on my own PC w/ Office 2010 (same version on user's PC) and print preview/printing all works normally when printing the selection. I don't think it has anything to do with the file. The user can replicate the issue on any excel file.

Expert Comment

by:Leo Torres
ID: 36816865

I am not talking about pring preview.. I want you to set the Print Area and see if that still happens
You can do this by Select the region to be printed  and going to Page Layout-->print Area--> Set Print Area

If Still giving you issues go to View-->Select page break Preview
This will tell you how the print pages are broken up that should help

I was not asking to replicate same error with another file. I want to see if you can replicate the same error with the same file on another PC

Author Comment

ID: 36893743
I have done everything you requested as my post above stated:

"The print area defines a selection. That setting is grayed out in the print dialog when selecting "Print Selection" - it only applies when printing the "Active Worksheet"."

Setting the print area had zero effect on the outcome of how the document would print in this case.


"I took the file and opened it up on my own PC w/ Office 2010 (same version on user's PC) and print preview/printing all works normally when printing the selection. I don't think it has anything to do with the file."

The page breaks are set by default, never been modified, and look at be fine.

Thank you...

Expert Comment

by:Leo Torres
ID: 36893794

Have you tried to see if some other program has the same issue on the same problematic computer..
I  would assume no or you may not have another program that can recreate this error.. but worth a try asking

Have you tried fooling around with the print drivers on the pc with issues. I see you tried to re-install office how about re-installing the drivers This seems to be a setting the pc has with the printer that may becausing this problem..

Author Comment

ID: 36893826
I have narrowed it down a little more:

My personal PC has Windows 7 64bit w/ Office 2010 32-bit SP1 - it displays the print selection perfectly.

The user with issues has Windows XP 32-bit w/ Office 2010 32-bit (NO SERVICE PACK). I tried replicating the problem on another identical setup and it did indeed happen again.

The problem seems to be Windows XP or Office 2010 SP1 related. I am now installing Office 2010 SP1 to see if that clears the issue up on my user's PC.

Expert Comment

by:Leo Torres
ID: 36893871

Oh I was under the impression that the PC were the same..

Hopefully The service pack update will fix this ..

Guess the next question is mine.. how the heck did you get office 2010 on XP??? I tried that and failed miserably..

Maybe this was becasue I had a 64 bit version.. :) hope that helps

Author Comment

ID: 36893882
The only prerequisite I know of for an XP install is that you must have XP SP3 installed. After updating it should install no problem!

Accepted Solution

DickJansen earned 0 total points
ID: 36893893
Installing Office 2010 SP1 fixed this issue!

Author Closing Comment

ID: 36915528

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question