Forum Discussion
Seeing wrapped text in cell but cut off when printed
Help!
I am working with an Excel file set up previously by someone else.
When I enter text into the cell and wrap it - it looks fine on the spreadsheet. (the cells are formatted as text and set up to wrap). It looks perfectly good on the screen.
I print (and during print preview) and some wrapped cells have text cut off. It is random and I never know which ones. Then to get it to look right when printed - I have to make the row height much larger than necessary. The first picture is how it looks on screen and second is how it prints. Ideas? I am not super tech savvy and it is probably a simple fix - I just don't know and not having set up the spreadsheet, I am lost on how to fix this. Sorry the pics are not super clear.
10 Replies
I have no problem on print or generate pdf on my side of Excel Android app.
If possible，share your file instead of screenshot.
I attached my file for your test.
Unfortunately, this problem goes way back, and it has never been corrected by Microsoft. Unlike with Word, the printed output differs from the on-screen display, and I don't know of a good workaround. Fiddling with the row heights appears to be the only way to get the correct printed output.
- Thank you for your help. It is frustrating because I never know which cell will have the issue until after I look at print preview.
HansVogelaarwrote
Unfortunately, this problem goes way back, and it has never been corrected by Microsoft. Unlike with Word, the printed output differs from the on-screen display, and I don't know of a good workaround. Fiddling with the row heights appears to be the only way to get the correct printed output.
ML_Guerriero so although fiddling with row heights may be "the only way" in Excel, as Hans notes, there still is Word (with data populated via Mail Merge from Excel) as a viable option with good control over the appearance of the output. You'd still be using the Excel file as the data source....
We do not use Excel as the data source. Information is taken from tax returns and QB files. The statements were set up in Excel long before me and each one is different and unique. It is unfortunately not just a matter of being able to do a mail merge. I use that for other purposes where the data is stored in Excel. Thank you for the suggestion though.mathetes
Perhaps you may share the file (if necessary removing all information but one which is on the screenshot) ?
This looks like an ideal application for MS Word's MailMerge capability, using Excel as the source. Word gives you much better control over the layout of the text, and Mail Merge enables you to print personalized documents -- reflecting the various interest rates, monthly payments, etc.
If I were you, I'd research how to convert this (which shouldn't be all that hard) to MailMerge via Word. Here are some YouTube videos that explain the process.
- Thank you. I do know how to mail merge. I need to continue using the Excel document. Thank you for the help.
- May I inquire as to Why? Is not the goal to achieve a good personalized document?
