Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a way to view more than 255 characters in a cell? You can see all
the characters in the edit bar at the top, but in the field, you can't see anything voer 255. Is there a way around this limitation?? Using Excel 2000 or 2003 |
#2
![]() |
|||
|
|||
![]()
XL00 and XL03 both allow 1024 characters to be displayed in a cell. Try
expanding your cell height or width. To view more, you'll have to insert line breaks (OPT-ENTER) at least every 1024 characters. In article , Claire wrote: Is there a way to view more than 255 characters in a cell? You can see all the characters in the edit bar at the top, but in the field, you can't see anything voer 255. Is there a way around this limitation?? Using Excel 2000 or 2003 |
#3
![]() |
|||
|
|||
![]()
hi John
do you mean ALT & ENTER for linebreaks? Cheers JulieD "JE McGimpsey" wrote in message ... XL00 and XL03 both allow 1024 characters to be displayed in a cell. Try expanding your cell height or width. To view more, you'll have to insert line breaks (OPT-ENTER) at least every 1024 characters. In article , Claire wrote: Is there a way to view more than 255 characters in a cell? You can see all the characters in the edit bar at the top, but in the field, you can't see anything voer 255. Is there a way around this limitation?? Using Excel 2000 or 2003 |
#4
![]() |
|||
|
|||
![]()
What about XL02. I have the same limitation in XL02. Alt-Enter helps but
not that much. "JulieD" wrote: hi John do you mean ALT & ENTER for linebreaks? Cheers JulieD "JE McGimpsey" wrote in message ... XL00 and XL03 both allow 1024 characters to be displayed in a cell. Try expanding your cell height or width. To view more, you'll have to insert line breaks (OPT-ENTER) at least every 1024 characters. In article , Claire wrote: Is there a way to view more than 255 characters in a cell? You can see all the characters in the edit bar at the top, but in the field, you can't see anything voer 255. Is there a way around this limitation?? Using Excel 2000 or 2003 |
#5
![]() |
|||
|
|||
![]()
Nope. I use OPT-ENTER.
Those stuck with WinXL should use ALT, tho' <g In article , "JulieD" wrote: do you mean ALT & ENTER for linebreaks? |
#6
![]() |
|||
|
|||
![]()
I've seen at least 15,000 characters by using lots of alt-enters and a small
enough font. TimMc wrote: What about XL02. I have the same limitation in XL02. Alt-Enter helps but not that much. "JulieD" wrote: hi John do you mean ALT & ENTER for linebreaks? Cheers JulieD "JE McGimpsey" wrote in message ... XL00 and XL03 both allow 1024 characters to be displayed in a cell. Try expanding your cell height or width. To view more, you'll have to insert line breaks (OPT-ENTER) at least every 1024 characters. In article , Claire wrote: Is there a way to view more than 255 characters in a cell? You can see all the characters in the edit bar at the top, but in the field, you can't see anything voer 255. Is there a way around this limitation?? Using Excel 2000 or 2003 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Can I limit a cell to 72 characters? How? | Excel Discussion (Misc queries) | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
#### error if cell has more than 255 characters | Excel Discussion (Misc queries) |