Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
viewing all words in a cell
I can see all the words in the cell in the formula bar when the cell is
selected. When it's not, I can's see them in the cell, no matter how big I physically make the cell. I can make the cell so big that there is a lot of white space at the end of the words, but the words still cut off. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
viewing all words in a cell
T insure visibility, insert a hard return every so often. This is done with
a ALT-ENTER key touch. -- Gary's Student "Annabelle611" wrote: I can see all the words in the cell in the formula bar when the cell is selected. When it's not, I can's see them in the cell, no matter how big I physically make the cell. I can make the cell so big that there is a lot of white space at the end of the words, but the words still cut off. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
viewing all words in a cell
Annabelle
Excel has a limit of 1024 characters visible in a cell, all 32k (total limit) show in the formula bar See help (Excel limits and specifications) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Annabelle611" wrote in message ... I can see all the words in the cell in the formula bar when the cell is selected. When it's not, I can's see them in the cell, no matter how big I physically make the cell. I can make the cell so big that there is a lot of white space at the end of the words, but the words still cut off. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
viewing all words in a cell
But if you add alt-enters (to force new lines within the cell) every 80-100
characters, then you'll be able to see lots more characters than 1024 in that cell. Nick Hodge wrote: Annabelle Excel has a limit of 1024 characters visible in a cell, all 32k (total limit) show in the formula bar See help (Excel limits and specifications) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Annabelle611" wrote in message ... I can see all the words in the cell in the formula bar when the cell is selected. When it's not, I can's see them in the cell, no matter how big I physically make the cell. I can make the cell so big that there is a lot of white space at the end of the words, but the words still cut off. Any ideas? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
viewing all words in a cell
Dave
True, but that's a 'dance' ;-) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Dave Peterson" wrote in message ... But if you add alt-enters (to force new lines within the cell) every 80-100 characters, then you'll be able to see lots more characters than 1024 in that cell. Nick Hodge wrote: Annabelle Excel has a limit of 1024 characters visible in a cell, all 32k (total limit) show in the formula bar See help (Excel limits and specifications) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Annabelle611" wrote in message ... I can see all the words in the cell in the formula bar when the cell is selected. When it's not, I can's see them in the cell, no matter how big I physically make the cell. I can make the cell so big that there is a lot of white space at the end of the words, but the words still cut off. Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I put several words one on top the other in one cell? | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
How Do? Take two words in cell 1 and slpit them to cell 2 & 3 | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |