Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INCREASING THE # OF TEXT ALLOWED IN A CELL?
Hi, I would love to know how you can increase the number of text allowed in a
cell when using Excel. I use excel a lot and put in a lot of text in colums but what I find is when the number of text increases to greater than 250 the text is not visible on the cell even after I increase the size so it is not visible when I print the data. Any help on this would be great. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
INCREASING THE # OF TEXT ALLOWED IN A CELL?
Try adding alt-enters to force newlines within the cell. Depending on the
amount of text in those cells, you may have to adjust the rowheight manually. And if that doesn't help... Are you using multiple monitors? ullas wrote: Hi, I would love to know how you can increase the number of text allowed in a cell when using Excel. I use excel a lot and put in a lot of text in colums but what I find is when the number of text increases to greater than 250 the text is not visible on the cell even after I increase the size so it is not visible when I print the data. Any help on this would be great. Thank you. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
INCREASING THE # OF TEXT ALLOWED IN A CELL?
Thanks for your response Dave. I know about the Alt-enters which I use quite
a bit, but what seems to happen is when I enter more than a certain number of text I think it is about 250 it does not display on the column it seems to right indent and is not visible when you print. I think excel has a limit on the number of text you can view. Do you know if that can be increased? "Dave Peterson" wrote: Try adding alt-enters to force newlines within the cell. Depending on the amount of text in those cells, you may have to adjust the rowheight manually. And if that doesn't help... Are you using multiple monitors? ullas wrote: Hi, I would love to know how you can increase the number of text allowed in a cell when using Excel. I use excel a lot and put in a lot of text in colums but what I find is when the number of text increases to greater than 250 the text is not visible on the cell even after I increase the size so it is not visible when I print the data. Any help on this would be great. Thank you. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
INCREASING THE # OF TEXT ALLOWED IN A CELL?
Without the manual linefeeds, XL's limit (see "Specifications" in XL
Help) is 1024 characters displayed or printed. That limit cannot be changed. In article , ullas wrote: I think excel has a limit on the number of text you can view. Do you know if that can be increased? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
INCREASING THE # OF TEXT ALLOWED IN A CELL?
xl97-xl2003's help shows that it'll display about 1000 characters in a cell. By
using alt-enters and a small font, I've seen 5k to 15k characters in the cell. You can use =len(a1) to show the number of characters in A1. You didn't answer my question. ullas wrote: Thanks for your response Dave. I know about the Alt-enters which I use quite a bit, but what seems to happen is when I enter more than a certain number of text I think it is about 250 it does not display on the column it seems to right indent and is not visible when you print. I think excel has a limit on the number of text you can view. Do you know if that can be increased? "Dave Peterson" wrote: Try adding alt-enters to force newlines within the cell. Depending on the amount of text in those cells, you may have to adjust the rowheight manually. And if that doesn't help... Are you using multiple monitors? ullas wrote: Hi, I would love to know how you can increase the number of text allowed in a cell when using Excel. I use excel a lot and put in a lot of text in colums but what I find is when the number of text increases to greater than 250 the text is not visible on the cell even after I increase the size so it is not visible when I print the data. Any help on this would be great. Thank you. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text exceeds allowed number of characters per cell | Excel Worksheet Functions | |||
how many character are allowed in a cell | Excel Discussion (Misc queries) | |||
Prevent Row Height from increasing when Pasting lenghthy text into Cell. | Excel Worksheet Functions | |||
how many if statements are allowed per cell? | Excel Worksheet Functions | |||
Increasing the size of text in a Drop Down box | Excel Discussion (Misc queries) |