Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a lot of text fit into one cell?
I need to write a lot of information in one particular cell, I have wrapped
text so that it reads downwards, and this has worked thus far, however after a certain point, no more text appears in the cell, even though it appears when I click on the formula bar. I have tried autofit which does not remedy the situation. I need to be able to see all of the text when it has printed out. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a lot of text fit into one cell?
To get all the text to appear in the cell as well as the formula bar, you
need to insert a hard return (ALT-ENTER) every so often. -- Gary''s Student - gsnu200826 "sjlaw85" wrote: I need to write a lot of information in one particular cell, I have wrapped text so that it reads downwards, and this has worked thus far, however after a certain point, no more text appears in the cell, even though it appears when I click on the formula bar. I have tried autofit which does not remedy the situation. I need to be able to see all of the text when it has printed out. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a lot of text fit into one cell?
There is an actual limit to what excel will display, even if you wrap
it, insert a hard return, etc. you need to use an additional cell. On Jan 15, 8:59*am, Gary''s Student wrote: To get all the text to appear in the cell as well as the formula bar, you need to insert a hard return (ALT-ENTER) every so often. -- Gary''s Student - gsnu200826 "sjlaw85" wrote: I need to write a lot of information in one particular cell, I have wrapped text so that it reads downwards, and this has worked thus far, however after a certain point, no more text appears in the cell, even though it appears when I click on the formula bar. I have tried autofit which does not remedy the situation. I need to be able to see all of the text when it has printed out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a cell required if another cell has text in it | New Users to Excel | |||
make text in one cell count as 1 in another cell | Excel Discussion (Misc queries) | |||
How do I make all my text appear in my cell in Excel? | Excel Discussion (Misc queries) | |||
How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
How do I add a make a new paragraph in a text cell? | Excel Discussion (Misc queries) |