ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   When printing using Excel the text does not fit in the cell (https://www.excelbanter.com/excel-discussion-misc-queries/19231-when-printing-using-excel-text-does-not-fit-cell.html)

MSUbully

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!!

Myrna Larson

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!!



MSUbully

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