Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How see all the text in a cell?
No suitable forum for this so posting it here.
How do I see all the text in a cell? It's hundreds or thousands of characters. Can I expand a cell to be multiple lines? What is the secret? Tried to find out via Help but it's useless. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How see all the text in a cell?
To expand to multiple lines, Format/ Cells/ Alignment: wrap text.
If you are still having trouble, include an "Alt Enter" every so often, which will give a new line. -- David Biddulph "mscertified" wrote in message ... No suitable forum for this so posting it here. How do I see all the text in a cell? It's hundreds or thousands of characters. Can I expand a cell to be multiple lines? What is the secret? Tried to find out via Help but it's useless. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How see all the text in a cell?
In Help ("Specifications") you can discover that each cell can contain
32767 characters, of which the first 1024 characters can be displayed or printed. To work around that, you can insert LFs (alt-enter) every 1024 characters. In article , mscertified wrote: No suitable forum for this so posting it here. How do I see all the text in a cell? It's hundreds or thousands of characters. Can I expand a cell to be multiple lines? What is the secret? Tried to find out via Help but it's useless. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
New text added to cell AFTER current text in same cell | Excel Worksheet Functions |