Display ALL text contents in cell
 

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


--
Flipper1067
------------------------------------------------------------------------
Flipper1067's Profile: http://www.excelforum.com/member.php...o&userid=25619
View this thread: http://www.excelforum.com/showthread...hreadid=390338

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


Hope it helps.


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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390338

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


Hope it helps.

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


--
Flipper1067
------------------------------------------------------------------------
Flipper1067's Profile: http://www.excelforum.com/member.php...o&userid=25619
View this thread: http://www.excelforum.com/showthread...hreadid=390338

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


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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390338

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


--
Flipper1067
------------------------------------------------------------------------
Flipper1067's Profile: http://www.excelforum.com/member.php...o&userid=25619
View this thread: http://www.excelforum.com/showthread...hreadid=390338

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

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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390338

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


--
Flipper1067
------------------------------------------------------------------------
Flipper1067's Profile: http://www.excelforum.com/member.php...o&userid=25619
View this thread: http://www.excelforum.com/showthread...hreadid=390338

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


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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390338

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 wrote:

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

--
Flipper1067
------------------------------------------------------------------------
Flipper1067's Profile: http://www.excelforum.com/member.php...o&userid=25619
View this thread: http://www.excelforum.com/showthread...hreadid=390338

--

Dave Peterson

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


--
Flipper1067
------------------------------------------------------------------------
Flipper1067's Profile: http://www.excelforum.com/member.php...o&userid=25619
View this thread: http://www.excelforum.com/showthread...hreadid=390338

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


--
Flipper1067
------------------------------------------------------------------------
Flipper1067's Profile: http://www.excelforum.com/member.php...o&userid=25619
View this thread: http://www.excelforum.com/showthread...hreadid=390338