Forum Discussion
Seeing wrapped text in cell but cut off when printed
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
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.
OK, now, please forgive me for being a bit like a dog with a bone. IF Excel is not the data source, if data are coming from all over the place, that even seems to make it more reasonable to abandon Excel--with its formatting eccentricities--in favor of Word. Especially if you are "manually" entering the data from those disparate sources into each unique output.
I do view our role here (those of us who occasionally answer questions such as you've posed) as including challenging unquestioned assumptions, and that's all I'm trying to do; if we were sitting down face-to-face, I'd be asking the same questions. You haven't convinced me--and, as I said, forgive me for pressing the point--that Excel is a necessary part of this, other than the "we've always done it this way" defense. I realize I could well be missing something, perhaps something that you're taking for granted.