![]() |
When printing using Excel the text does not fit in the cell
The text fits in a cell on the screen, but when I print part of it is omitted
because the cell box doesn't seem to be large enough. I can add a blank line by using Alt-enter, but sometimes I need to add two lines. My text varies from a few words to as many as 30. There has got to be a better way than trying to guess if an additional line is needed an add it manually. Sometimes worksheets have over 300 lines!! |
Have you set the alignment for these cells to Wrap Text and the row height to
Auto? On Fri, 25 Mar 2005 07:33:04 -0800, "MSUbully" wrote: The text fits in a cell on the screen, but when I print part of it is omitted because the cell box doesn't seem to be large enough. I can add a blank line by using Alt-enter, but sometimes I need to add two lines. My text varies from a few words to as many as 30. There has got to be a better way than trying to guess if an additional line is needed an add it manually. Sometimes worksheets have over 300 lines!! |
Thanks for responding. I have struggeled with this problem for years!! Yes,
I have set the cells to Wrap Text and the row height to AutoFit. "Myrna Larson" wrote: Have you set the alignment for these cells to Wrap Text and the row height to Auto? On Fri, 25 Mar 2005 07:33:04 -0800, "MSUbully" wrote: The text fits in a cell on the screen, but when I print part of it is omitted because the cell box doesn't seem to be large enough. I can add a blank line by using Alt-enter, but sometimes I need to add two lines. My text varies from a few words to as many as 30. There has got to be a better way than trying to guess if an additional line is needed an add it manually. Sometimes worksheets have over 300 lines!! |
All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com