Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
One row has a lot of data in one cell, but it cuts off the data in the middle
and doesn't show it on the spreadsheet or in print, except if I hit F2. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
Does this mean that you can see lots (maybe about a 1000 characters), then it
just fizzles out and you can't see the rest? If yes, try adding alt-enters (to force a new line within the cell) every 80 or 100 characters. You should be able to see lots more. jessi wrote: One row has a lot of data in one cell, but it cuts off the data in the middle and doesn't show it on the spreadsheet or in print, except if I hit F2. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
Excel will allow 32767 characters to be entered in a cell.
But.....only 1024 of these will be visible or can be printed. Is this your problem? You can extend this 1024 limit by using a smaller font or adding an Alt + Enter every 80-100 characters. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 18:04:11 -0700, jessi wrote: One row has a lot of data in one cell, but it cuts off the data in the middle and doesn't show it on the spreadsheet or in print, except if I hit F2. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
It didn't work - all it did was give me a dozen paragraphs, but once I left F2, I could only see the first half of the text again. Any other ideas? I really appreciate your help. "Gord Dibben" wrote: Excel will allow 32767 characters to be entered in a cell. But.....only 1024 of these will be visible or can be printed. Is this your problem? You can extend this 1024 limit by using a smaller font or adding an Alt + Enter every 80-100 characters. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 18:04:11 -0700, jessi wrote: One row has a lot of data in one cell, but it cuts off the data in the middle and doesn't show it on the spreadsheet or in print, except if I hit F2. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
How many characters could you see?
I've seen 15000 with a small font and a wide column and tall rowheight. Maybe you'd be better served by using a textbox--either from the Drawing toolbar or from the Control toolbox toolbar? Or by using MSWord? jessi wrote: It didn't work - all it did was give me a dozen paragraphs, but once I left F2, I could only see the first half of the text again. Any other ideas? I really appreciate your help. "Gord Dibben" wrote: Excel will allow 32767 characters to be entered in a cell. But.....only 1024 of these will be visible or can be printed. Is this your problem? You can extend this 1024 limit by using a smaller font or adding an Alt + Enter every 80-100 characters. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 18:04:11 -0700, jessi wrote: One row has a lot of data in one cell, but it cuts off the data in the middle and doesn't show it on the spreadsheet or in print, except if I hit F2. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
It doesn't matter how small I make the font, or how wide I make the column.
Enlarging the row size gave me a much larger cell but the bottom half of the cell is empty after the text disappears. And I'm only seeing about 1200 characters out of the entire text which is about twice that. How could I use Microsoft Word to help? "Dave Peterson" wrote: How many characters could you see? I've seen 15000 with a small font and a wide column and tall rowheight. Maybe you'd be better served by using a textbox--either from the Drawing toolbar or from the Control toolbox toolbar? Or by using MSWord? jessi wrote: It didn't work - all it did was give me a dozen paragraphs, but once I left F2, I could only see the first half of the text again. Any other ideas? I really appreciate your help. "Gord Dibben" wrote: Excel will allow 32767 characters to be entered in a cell. But.....only 1024 of these will be visible or can be printed. Is this your problem? You can extend this 1024 limit by using a smaller font or adding an Alt + Enter every 80-100 characters. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 18:04:11 -0700, jessi wrote: One row has a lot of data in one cell, but it cuts off the data in the middle and doesn't show it on the spreadsheet or in print, except if I hit F2. -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
Put your information in MSWord and drop excel completely????
And did you put alt-enters every 80-100 characters? I've never seen that fail. jessi wrote: It doesn't matter how small I make the font, or how wide I make the column. Enlarging the row size gave me a much larger cell but the bottom half of the cell is empty after the text disappears. And I'm only seeing about 1200 characters out of the entire text which is about twice that. How could I use Microsoft Word to help? "Dave Peterson" wrote: How many characters could you see? I've seen 15000 with a small font and a wide column and tall rowheight. Maybe you'd be better served by using a textbox--either from the Drawing toolbar or from the Control toolbox toolbar? Or by using MSWord? jessi wrote: It didn't work - all it did was give me a dozen paragraphs, but once I left F2, I could only see the first half of the text again. Any other ideas? I really appreciate your help. "Gord Dibben" wrote: Excel will allow 32767 characters to be entered in a cell. But.....only 1024 of these will be visible or can be printed. Is this your problem? You can extend this 1024 limit by using a smaller font or adding an Alt + Enter every 80-100 characters. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 18:04:11 -0700, jessi wrote: One row has a lot of data in one cell, but it cuts off the data in the middle and doesn't show it on the spreadsheet or in print, except if I hit F2. -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
I tried the Alt-enters this morning - it gave me about a dozen paragraphs but
didn't change the problem. And Word won't work for this project. Any other ideas? Or anywhere else I might look for the answer? My boss is getting antsy. "Dave Peterson" wrote: Put your information in MSWord and drop excel completely???? And did you put alt-enters every 80-100 characters? I've never seen that fail. jessi wrote: It doesn't matter how small I make the font, or how wide I make the column. Enlarging the row size gave me a much larger cell but the bottom half of the cell is empty after the text disappears. And I'm only seeing about 1200 characters out of the entire text which is about twice that. How could I use Microsoft Word to help? "Dave Peterson" wrote: How many characters could you see? I've seen 15000 with a small font and a wide column and tall rowheight. Maybe you'd be better served by using a textbox--either from the Drawing toolbar or from the Control toolbox toolbar? Or by using MSWord? jessi wrote: It didn't work - all it did was give me a dozen paragraphs, but once I left F2, I could only see the first half of the text again. Any other ideas? I really appreciate your help. "Gord Dibben" wrote: Excel will allow 32767 characters to be entered in a cell. But.....only 1024 of these will be visible or can be printed. Is this your problem? You can extend this 1024 limit by using a smaller font or adding an Alt + Enter every 80-100 characters. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 18:04:11 -0700, jessi wrote: One row has a lot of data in one cell, but it cuts off the data in the middle and doesn't show it on the spreadsheet or in print, except if I hit F2. -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
I don't have any other suggestions that I haven't shared in the previous posts.
jessi wrote: I tried the Alt-enters this morning - it gave me about a dozen paragraphs but didn't change the problem. And Word won't work for this project. Any other ideas? Or anywhere else I might look for the answer? My boss is getting antsy. "Dave Peterson" wrote: Put your information in MSWord and drop excel completely???? And did you put alt-enters every 80-100 characters? I've never seen that fail. jessi wrote: It doesn't matter how small I make the font, or how wide I make the column. Enlarging the row size gave me a much larger cell but the bottom half of the cell is empty after the text disappears. And I'm only seeing about 1200 characters out of the entire text which is about twice that. How could I use Microsoft Word to help? "Dave Peterson" wrote: How many characters could you see? I've seen 15000 with a small font and a wide column and tall rowheight. Maybe you'd be better served by using a textbox--either from the Drawing toolbar or from the Control toolbox toolbar? Or by using MSWord? jessi wrote: It didn't work - all it did was give me a dozen paragraphs, but once I left F2, I could only see the first half of the text again. Any other ideas? I really appreciate your help. "Gord Dibben" wrote: Excel will allow 32767 characters to be entered in a cell. But.....only 1024 of these will be visible or can be printed. Is this your problem? You can extend this 1024 limit by using a smaller font or adding an Alt + Enter every 80-100 characters. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 18:04:11 -0700, jessi wrote: One row has a lot of data in one cell, but it cuts off the data in the middle and doesn't show it on the spreadsheet or in print, except if I hit F2. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
reveal unshown data in cell
Thank you for trying to help me.
"Dave Peterson" wrote: I don't have any other suggestions that I haven't shared in the previous posts. jessi wrote: I tried the Alt-enters this morning - it gave me about a dozen paragraphs but didn't change the problem. And Word won't work for this project. Any other ideas? Or anywhere else I might look for the answer? My boss is getting antsy. "Dave Peterson" wrote: Put your information in MSWord and drop excel completely???? And did you put alt-enters every 80-100 characters? I've never seen that fail. jessi wrote: It doesn't matter how small I make the font, or how wide I make the column. Enlarging the row size gave me a much larger cell but the bottom half of the cell is empty after the text disappears. And I'm only seeing about 1200 characters out of the entire text which is about twice that. How could I use Microsoft Word to help? "Dave Peterson" wrote: How many characters could you see? I've seen 15000 with a small font and a wide column and tall rowheight. Maybe you'd be better served by using a textbox--either from the Drawing toolbar or from the Control toolbox toolbar? Or by using MSWord? jessi wrote: It didn't work - all it did was give me a dozen paragraphs, but once I left F2, I could only see the first half of the text again. Any other ideas? I really appreciate your help. "Gord Dibben" wrote: Excel will allow 32767 characters to be entered in a cell. But.....only 1024 of these will be visible or can be printed. Is this your problem? You can extend this 1024 limit by using a smaller font or adding an Alt + Enter every 80-100 characters. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 18:04:11 -0700, jessi wrote: One row has a lot of data in one cell, but it cuts off the data in the middle and doesn't show it on the spreadsheet or in print, except if I hit F2. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reveal hyperlinks in Excel? | Excel Discussion (Misc queries) | |||
How do i reveal hidden sheets | Excel Discussion (Misc queries) | |||
Can a mouseover reveal associated data in charts? | Excel Discussion (Misc queries) | |||
Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
How to reveal conditional formatting? | Excel Worksheet Functions |