Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting more data into an excel cell?
When I type too many characters, I can see them when I click in the cell but
they will not show in any view or print. I've tried minimizing the font size, and that helps some, but does not fix it. I've tried all types of formatting, alignment, merging cells, and extending the size of the cells manually. Are there just a minimum number of letters you can type in a cell and no options to extend/increase it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting more data into an excel cell?
Have you tried FormatCells...Wrap Cells?
This is the limit from help 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "ediet" wrote in message ... When I type too many characters, I can see them when I click in the cell but they will not show in any view or print. I've tried minimizing the font size, and that helps some, but does not fix it. I've tried all types of formatting, alignment, merging cells, and extending the size of the cells manually. Are there just a minimum number of letters you can type in a cell and no options to extend/increase it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting more data into an excel cell?
Hi
There is a limit but you can extend that limiit by inserting cariage returns (Alt+Enter) in the cell every 4 lines or so. Try that and see if it helps! HTH Jean-Guy "ediet" wrote: When I type too many characters, I can see them when I click in the cell but they will not show in any view or print. I've tried minimizing the font size, and that helps some, but does not fix it. I've tried all types of formatting, alignment, merging cells, and extending the size of the cells manually. Are there just a minimum number of letters you can type in a cell and no options to extend/increase it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions |