Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format - wrap text
Hi,
I have cell filled with many numbers (4 digits to 10 digits) and the cell format is general wrap text, but when view/print the content not showing all the numbers, even after increase the row height. I am using Excel 2002. Any setting I missed out or is it limited to certain maximum charactes in one cell? Thanks, Jerry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format - wrap text
Try ...
Select the range. FormatRow/Column/Autofit If this post helps click Yes --------------- Jacob Skaria "Jerry AMK" wrote: Hi, I have cell filled with many numbers (4 digits to 10 digits) and the cell format is general wrap text, but when view/print the content not showing all the numbers, even after increase the row height. I am using Excel 2002. Any setting I missed out or is it limited to certain maximum charactes in one cell? Thanks, Jerry |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format - wrap text
Thanks, but it is not working. The row decreased but some of the numbers are
still "hiding" "Jacob Skaria" wrote: Try ... Select the range. FormatRow/Column/Autofit If this post helps click Yes --------------- Jacob Skaria "Jerry AMK" wrote: Hi, I have cell filled with many numbers (4 digits to 10 digits) and the cell format is general wrap text, but when view/print the content not showing all the numbers, even after increase the row height. I am using Excel 2002. Any setting I missed out or is it limited to certain maximum charactes in one cell? Thanks, Jerry |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format - wrap text
I hope you have selected all rows and did this. OK try this
--Select All. (Ctrl+A). --Point the cursor towards row header (where the rows are numbered) --When you bring the cursor between row header 1 and 2; the cursor will change to a + sign. --Double click. If this post helps click Yes --------------- Jacob Skaria "Jerry AMK" wrote: Thanks, but it is not working. The row decreased but some of the numbers are still "hiding" "Jacob Skaria" wrote: Try ... Select the range. FormatRow/Column/Autofit If this post helps click Yes --------------- Jacob Skaria "Jerry AMK" wrote: Hi, I have cell filled with many numbers (4 digits to 10 digits) and the cell format is general wrap text, but when view/print the content not showing all the numbers, even after increase the row height. I am using Excel 2002. Any setting I missed out or is it limited to certain maximum charactes in one cell? Thanks, Jerry |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format - wrap text
You say "many" numbers in a cell.
Then you say "4 digits to 10 digits" That doesn't seem like many to me and would not require the use of wrap text. Have you misstated what the cell contains? Maybe many groups of numbers with 4 to 10 digits in the cell? Gord Dibben MS Excel MVP On Sat, 13 Jun 2009 01:42:01 -0700, Jerry AMK <Jerry wrote: Hi, I have cell filled with many numbers (4 digits to 10 digits) and the cell format is general wrap text, but when view/print the content not showing all the numbers, even after increase the row height. I am using Excel 2002. Any setting I missed out or is it limited to certain maximum charactes in one cell? Thanks, Jerry |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format - wrap text
Thank you, but is still the same. I set the row was higher try to give some
space but if I double click it will shrink back....I understand I can use Alt+Enter to force break the characters, but it will take some time for adjusting the view. Thanks again Jacob. "Jacob Skaria" wrote: I hope you have selected all rows and did this. OK try this --Select All. (Ctrl+A). --Point the cursor towards row header (where the rows are numbered) --When you bring the cursor between row header 1 and 2; the cursor will change to a + sign. --Double click. If this post helps click Yes --------------- Jacob Skaria "Jerry AMK" wrote: Thanks, but it is not working. The row decreased but some of the numbers are still "hiding" "Jacob Skaria" wrote: Try ... Select the range. FormatRow/Column/Autofit If this post helps click Yes --------------- Jacob Skaria "Jerry AMK" wrote: Hi, I have cell filled with many numbers (4 digits to 10 digits) and the cell format is general wrap text, but when view/print the content not showing all the numbers, even after increase the row height. I am using Excel 2002. Any setting I missed out or is it limited to certain maximum charactes in one cell? Thanks, Jerry |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format - wrap text
Sorry, maybe I describe it wrongly.
I have a cell filled with group of invoice numbers (i.e: 7171, 82426, 827782133007116, 2133007238, ...) and it maybe more than 1000 characters in that cell. I saw your earlier post for other's similar questions and you mentioned about 1024 character limitation. Maybe I have to accept this condition? I also try Alt+Enter but it good if only for few times. Thank you, Jerry "Gord Dibben" wrote: You say "many" numbers in a cell. Then you say "4 digits to 10 digits" That doesn't seem like many to me and would not require the use of wrap text. Have you misstated what the cell contains? Maybe many groups of numbers with 4 to 10 digits in the cell? Gord Dibben MS Excel MVP On Sat, 13 Jun 2009 01:42:01 -0700, Jerry AMK <Jerry wrote: Hi, I have cell filled with many numbers (4 digits to 10 digits) and the cell format is general wrap text, but when view/print the content not showing all the numbers, even after increase the row height. I am using Excel 2002. Any setting I missed out or is it limited to certain maximum charactes in one cell? Thanks, Jerry |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format - wrap text
Jerry
First...............A worksheet has many cells. Why are you pounding so much into one cell? You have eliminated any use of sorting or filtering or just about any other function. Second.................the Alt + Enter should work if you place one every 100 chars. Third................are you dealing with merged cells? These will disable the row autofit and must be dealt with manually or through VBA code. Maybe a textbox would serve you better if you need all that info in one cell. Gord On Sun, 14 Jun 2009 19:27:01 -0700, Jerry AMK wrote: Sorry, maybe I describe it wrongly. I have a cell filled with group of invoice numbers (i.e: 7171, 82426, 827782133007116, 2133007238, ...) and it maybe more than 1000 characters in that cell. I saw your earlier post for other's similar questions and you mentioned about 1024 character limitation. Maybe I have to accept this condition? I also try Alt+Enter but it good if only for few times. Thank you, Jerry "Gord Dibben" wrote: You say "many" numbers in a cell. Then you say "4 digits to 10 digits" That doesn't seem like many to me and would not require the use of wrap text. Have you misstated what the cell contains? Maybe many groups of numbers with 4 to 10 digits in the cell? Gord Dibben MS Excel MVP On Sat, 13 Jun 2009 01:42:01 -0700, Jerry AMK <Jerry wrote: Hi, I have cell filled with many numbers (4 digits to 10 digits) and the cell format is general wrap text, but when view/print the content not showing all the numbers, even after increase the row height. I am using Excel 2002. Any setting I missed out or is it limited to certain maximum charactes in one cell? Thanks, Jerry |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format - wrap text
Thanks Gord,
I may have to distribute the content to few cells. Jerry "Gord Dibben" wrote: Jerry First...............A worksheet has many cells. Why are you pounding so much into one cell? You have eliminated any use of sorting or filtering or just about any other function. Second.................the Alt + Enter should work if you place one every 100 chars. Third................are you dealing with merged cells? These will disable the row autofit and must be dealt with manually or through VBA code. Maybe a textbox would serve you better if you need all that info in one cell. Gord On Sun, 14 Jun 2009 19:27:01 -0700, Jerry AMK wrote: Sorry, maybe I describe it wrongly. I have a cell filled with group of invoice numbers (i.e: 7171, 82426, 827782133007116, 2133007238, ...) and it maybe more than 1000 characters in that cell. I saw your earlier post for other's similar questions and you mentioned about 1024 character limitation. Maybe I have to accept this condition? I also try Alt+Enter but it good if only for few times. Thank you, Jerry "Gord Dibben" wrote: You say "many" numbers in a cell. Then you say "4 digits to 10 digits" That doesn't seem like many to me and would not require the use of wrap text. Have you misstated what the cell contains? Maybe many groups of numbers with 4 to 10 digits in the cell? Gord Dibben MS Excel MVP On Sat, 13 Jun 2009 01:42:01 -0700, Jerry AMK <Jerry wrote: Hi, I have cell filled with many numbers (4 digits to 10 digits) and the cell format is general wrap text, but when view/print the content not showing all the numbers, even after increase the row height. I am using Excel 2002. Any setting I missed out or is it limited to certain maximum charactes in one cell? Thanks, Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
Excel 2007 high cpu usage, format cell, wrap text | Excel Discussion (Misc queries) | |||
Format cell to both Wrap text and shrink to fit | Excel Discussion (Misc queries) | |||
Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) |