| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
########### error
I have a fresh cell created (no formulas) - When i type in a line or two of
text, it does not wrap the text, or increase the size of the cell. I can see everything written on the command line at the top, but not in the cell. If I try to type in 2-3 lines of text, all text in the cell dissapears and is replaced with an entire rows of "########"'s. Wrap text is ON, Auto Fit is ON, no multiple montiors in use. Anyoone have any idea on how to fix this? ThankS! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
########### error
Make the column wider
Enter ALT+ENTER wherever you want the text to wrap Put the text in a text box, not in a cell best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "tre" wrote in message ... I have a fresh cell created (no formulas) - When i type in a line or two of text, it does not wrap the text, or increase the size of the cell. I can see everything written on the command line at the top, but not in the cell. If I try to type in 2-3 lines of text, all text in the cell dissapears and is replaced with an entire rows of "########"'s. Wrap text is ON, Auto Fit is ON, no multiple montiors in use. Anyoone have any idea on how to fix this? ThankS! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
########### error
try changing the format-cells-number to general
"tre" wrote: I have a fresh cell created (no formulas) - When i type in a line or two of text, it does not wrap the text, or increase the size of the cell. I can see everything written on the command line at the top, but not in the cell. If I try to type in 2-3 lines of text, all text in the cell dissapears and is replaced with an entire rows of "########"'s. Wrap text is ON, Auto Fit is ON, no multiple montiors in use. Anyoone have any idea on how to fix this? ThankS! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
########### error
You need to manually expand the cell on the worksheet. Not enough space has
been allocated. -- Thanks for your help Dyn "tre" wrote: I have a fresh cell created (no formulas) - When i type in a line or two of text, it does not wrap the text, or increase the size of the cell. I can see everything written on the command line at the top, but not in the cell. If I try to type in 2-3 lines of text, all text in the cell dissapears and is replaced with an entire rows of "########"'s. Wrap text is ON, Auto Fit is ON, no multiple montiors in use. Anyoone have any idea on how to fix this? ThankS! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Linear Mode
