Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in a cell
I am putting a lot of text into a cell, but all of my text will not show.
The text is wrapped and I have clicked on Row Auto-fit, but I still cannot see all of my text. I have even manually made the row bigger and it still will not fit. Is there a certain character limit for a cell or is there something else I'm just not doing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in a cell
hi
cells can contain 32736 characters but only 1024 show in the cell. the rest show in the formula bar. in excel help type the word specifications for specs and limits on your version of excel. see this site for 2007 specs http://office.microsoft.com/en-us/ex....aspx?pid=CH10 regards FSt1 "angikb" wrote: I am putting a lot of text into a cell, but all of my text will not show. The text is wrapped and I have clicked on Row Auto-fit, but I still cannot see all of my text. I have even manually made the row bigger and it still will not fit. Is there a certain character limit for a cell or is there something else I'm just not doing? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in a cell
As an addendum to FSt1's comment, you might be able to see more than 32,736
characters by inserting manual line breaks instead of having the cell word wrap. To insert a manual line break move to the position on the line where you want to break to the next line and press <Alt + <Enter -- Kevin Backmann "angikb" wrote: I am putting a lot of text into a cell, but all of my text will not show. The text is wrapped and I have clicked on Row Auto-fit, but I still cannot see all of my text. I have even manually made the row bigger and it still will not fit. Is there a certain character limit for a cell or is there something else I'm just not doing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter text in a cell to return a text value in same cell | Excel Discussion (Misc queries) | |||
Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
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 |