Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I increase viewable cell character count limit in Excel?
I am using Excel 2003 and want to increase the number of characters that can
be viewed in a cell when the cell is "not active", and by not active I mean that the user is not currently clicked in the cell. Lets say that I have 600 characters of info saved in a cell. When I print out the spreadsheet I want the contents of that cell to be viewable. However, what currently happens is that only a portion of the cell contents are shown, with the remainder of the cell content truncated from sight. And by the way, I do have the character wrap option enabled for this cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I increase viewable cell character count limit in Excel?
Try adding alt-enters (to force new lines within the cell) every 80-100
characters. Surfcaster wrote: I am using Excel 2003 and want to increase the number of characters that can be viewed in a cell when the cell is "not active", and by not active I mean that the user is not currently clicked in the cell. Lets say that I have 600 characters of info saved in a cell. When I print out the spreadsheet I want the contents of that cell to be viewable. However, what currently happens is that only a portion of the cell contents are shown, with the remainder of the cell content truncated from sight. And by the way, I do have the character wrap option enabled for this cell. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I increase viewable cell character count limit in Excel?
You can enter 32767 characters into a cell and you should be able to see and
print up to 1024 characters. You have wrap text enabled and manipulated row height and column width so's you can see the 600 chars on the sheet? Are you saying 600 characters won't print out properly? Maybe you have more than 1024? If so, see Dave's reply. Gord Dibben MS Excel MVP On Tue, 15 Dec 2009 12:59:02 -0800, Surfcaster wrote: I am using Excel 2003 and want to increase the number of characters that can be viewed in a cell when the cell is "not active", and by not active I mean that the user is not currently clicked in the cell. Lets say that I have 600 characters of info saved in a cell. When I print out the spreadsheet I want the contents of that cell to be viewable. However, what currently happens is that only a portion of the cell contents are shown, with the remainder of the cell content truncated from sight. And by the way, I do have the character wrap option enabled for this cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit number of character per cell to 26 in excel | Excel Worksheet Functions | |||
Limit character count in cell from left | Excel Discussion (Misc queries) | |||
Character limit in cell | Excel Discussion (Misc queries) | |||
How can I increase the character capcity of an Excel cell? | Excel Discussion (Misc queries) | |||
increase cell 255 limit in excel2000 help or way round it? | Excel Discussion (Misc queries) |