Display ALL text contents in cell

[Flipper1067]

I am having trouble displaying all the contents in the cell. It is som
lengthy information in the cell. I have made the row height as high a
it will go, but it still won't display all the information. I canno
make the column width any wider than I have it set, because then th
other columns will not fit on the page. Does anyone know how t
overcome this problem? :

 

[Morrigan]

1. Change the font size
2. Use "fit to page" when printing, you can then adjust column widt
accordingly


Hope it helps.

 

[Flipper1067]

1. Change the font size
2. Use "fit to page" when printing, you can then adjust column widt
accordingly


Hope it helps.

I tried changing the font. It doesn't help. My computer does not hav
fit to page, it has fit to ? pages wide and ? pages long

 

[Morrigan]

That is what I meant by "fit to page".

I tried changing the font. It doesn't help. My computer does not hav
fit to page, it has fit to ? pages wide and ? pages long

 

[Flipper1067]

Ok, the fit to page did not work. It still isnt printing all th
contents. :confused

 

[Morrigan]

What's the reason that it does not print all the contents? Is i
because of a word being too long?

 

[Flipper1067]

I dont know why it wont print it. It wont even display it all for me o
my computer screen. But when I click on the Formula bar, all the word
are there. It is a lengthy paragraph, however. Does it just have
max of 17 lines it will display

 

[Morrigan]

If it's a paragraph, can you use text box instead?

 

[Dave Peterson]

What do you see in the cell (not the formula bar)?

If you see ####, then format the cell as General (not Text).

If your text just seems to dropoff in the middle of a sentence, you can add
alt-enters (every 80-100 characters) to force new lines within the cell.

 

[Flipper1067]

Wow, that seemed to help, sorta. I put in hard returns and now all th
paragraph fits on my screen, but it wont print it out nor show it al
on print preview though. Any suggestions

 

[Flipper1067]

Ok, nevermind. I got it to print. I moved the bottom line down som
more. I guess that is all it took! Thanks for all your help
everyone