Excel cell contents cut off on right of cell when printing

behest
behest used Ask the Experts™
on
I'm just drawing a big blank here...this is a recurring issue (Office 2007, 2003, and I think even before that) that must be documented somewhere but apparently my search language differs from the normal language of frustration. Essentially, a cell with approx. 30-50 characters (no text wrap needed) can be entered into a cell and appears just fine on the screen and in print preview. I think that the font is normally Times New Roman or Times...but can't verify that now. But when you actually print (to pdf or live printer), a couple of letters on the right side of the cell disappear/don't print. The immediate answer is to either extend the cell beyond where it appears to end (even though it doesn't appear to need it onscreen) OR to add a few spaces to end (right side) of the cell.

So....

Does anyone know what causes this phenomenon? OR... can you give me some language that would detect the end of a cell's contents and add a few spaces to the end to make the problem go away. Keep in mind that if one cell in a column is affected, all of the others will be, too. So it would need to review all cells within a column of text...never seen it with numbers.

As always, your assistance is most definitely appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2008

Commented:
Excel is notoriously bad with regard to formatting and WYSIWYG from screen to printer to PDF. Not much you can do but add a few spaces here and make the column wider there. It's pretty much a trial and error deal.

Kevin
First of all, when ive run into that problem ive found that my Zoom wasn't at 100%.
Check this first.
if everything is visible at 100% the print/PDF should be fine to.

Can you verify?

Author

Commented:
Bromy...yes. been thru all of that...this is definitely column/cell related.
Kevin...so nice of you to help out again. What are both of you doing up this late?
Being the stubborn gal that I am...well, I think there has to be an answer. I'm aware of cell widths being dependent upon font settings and stuff like that. I'm wondering if this could possibly be a "legacy" issue... meaning that an Excel file created in a prior version then updated to a new version of Excel might be the issue. a lot of what I work with is updated stuff. as an fyi, I've gone thru the testing of different printers (pdf, factory pro...different laserjets and the like).
If not, couldn't I use something like at end of cell contents...add three spaces or something similar?
I'm looking for a good example right now.
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Top Expert 2008
Commented:
Late? It's only 10 PM at my house. I'll be up for a while. Where are you?

>Being the stubborn gal that I am...well, I think there has to be an answer.

Ha! You haven't spent a few hours with the Excel development team then!

>meaning that an Excel file created in a prior version then updated to a new version of Excel might be the issue.

Not likely. One thing is fairly constant: bugs and issues remain in place for a long, long time.

>I've gone thru the testing of different printers (pdf, factory pro...different laserjets and the like).

I used to product manage Mac products that relied heavily on printing - the testing department was huge and spent most of their time printing. What a pain in the rear. I had the engineers build special tables to handle offset and scaling discrepancies for as many printers as we could get our hands on.

>If not, couldn't I use something like at end of cell contents...add three spaces or something similar?

Here:

Public Sub AddSpaces()
    Dim Cell As Range
    For Each Cell In Selection
        Cell = Trim(Cell) & "    "
    Next Cell
End Sub

Kevin

Author

Commented:
Gosh golly gee...Kevin...I'm one of those Dallas gals...no, not the "blonde."  I'm the determined redhead on a mission. Unfortunately, it is after midnight here in the land of cowboys, oil and cutlery. And I've just plain worked on too many files in the last two days to recall which one has this issue. But I know that tomorrow morning, I'll have one. After all...tomorrow is another day.
I'd be ever so grateful if you'd check back with me in your a.m. (how's that for a southern damsel in distress?) Your previous code answers have been ever so helpful.
ps, they only let me test the really hard stuff 'cause I have an attitude and I'm good at finding issues...lol. Thanks again for being here!
 
Top Expert 2008

Commented:
:-)

Author

Commented:
Figures...the files that were exhibiting this issue a few days ago have all decided to behave today. At least on my computer. But I tested your solution and it works. Of course, I'd still like to know what the real issue is...but I'll save that puzzle for some day when I've got time on my hands...
Kevin, thank you again. Hope you had a lovely evening!
Top Expert 2008

Commented:
I did!

And I am having a good day today...the sun has returned, my kitties are purring, and I'm going for a run!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial