| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wrap Text Not Visible
Have wrap text turned on in a cell but can't seem to get the last line of
what I've written to show up in the cell no matter how much I expand the cell. It's visible in the formula bar but not in the cell itself. Thanks, Randy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wrap Text Not Visible
How large is your text? Only 1,024 display in a cell; up to 32,767 display in the formula bar. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wrap Text Not Visible
At some point in the text prior to it not being visible press Alt-Enter
Randy wrote: Have wrap text turned on in a cell but can't seem to get the last line of what I've written to show up in the cell no matter how much I expand the cell. It's visible in the formula bar but not in the cell itself. Thanks, Randy |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wrap Text Not Visible
If you add alt-enters to force new lines within the cell, then you can see lots
more than the documented 1024 characters. Randy wrote: Have wrap text turned on in a cell but can't seem to get the last line of what I've written to show up in the cell no matter how much I expand the cell. It's visible in the formula bar but not in the cell itself. Thanks, Randy -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wrap Text Not Visible
Dave, I so wish I'd known that six months ago!
"Dave Peterson" wrote: If you add alt-enters to force new lines within the cell, then you can see lots more than the documented 1024 characters. Randy wrote: Have wrap text turned on in a cell but can't seem to get the last line of what I've written to show up in the cell no matter how much I expand the cell. It's visible in the formula bar but not in the cell itself. Thanks, Randy -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wrap Text Not Visible
You've got to hang around the excel newsgroups more often <bg. This question
is asked lots of times per week! Sian wrote: Dave, I so wish I'd known that six months ago! "Dave Peterson" wrote: If you add alt-enters to force new lines within the cell, then you can see lots more than the documented 1024 characters. Randy wrote: Have wrap text turned on in a cell but can't seem to get the last line of what I've written to show up in the cell no matter how much I expand the cell. It's visible in the formula bar but not in the cell itself. Thanks, Randy -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make visible all text in cell with word wrap on | Excel Discussion (Misc queries) | |||
| Wrap text doesn't wrap | Excel Worksheet Functions | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| contents in cells are not visible when word wrap is selected | Excel Discussion (Misc queries) | |||
| text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
Linear Mode
