Viewing Text In A Cell rsenn 12/29/2008 10:38:11 PM When viewing a spreadsheet and I click on a cell, all text in the cell shows up in the box at the top of the screen but all of the text doesn't show up on the screen if I am not in that particular cell? How can I make all text show up in all cells?

RE: Viewing Text In A Cell FSt1 12/30/2008 12:34:01 AM hi in xl help, type the word specifications. this will list the specs and limits of your version of excel. how much text you have? a cell will hold 37767 characters but only 1024 will show in the cell. all 37767 will show in the fomula bar....the box at the top of the screen. regards FSt1 "rsenn" wrote: [Quoted Text] > When viewing a spreadsheet and I click on a cell, all text in the cell shows > up in the box at the top of the screen but all of the text doesn't show up on > the screen if I am not in that particular cell? How can I make all text show > up in all cells?

Re: Viewing Text In A Cell Dave Peterson <petersod[ at ]verizonXSPAM.net> 12/30/2008 1:42:27 AM But that 1024 documented in the help isn't accurate. One can add alt-enters (to force newlines within the cell) every 80-100 characters and lots more than 1024 characers can be seen. FSt1 wrote: [Quoted Text] > > hi > in xl help, type the word specifications. this will list the specs and > limits of your version of excel. > how much text you have? > a cell will hold 37767 characters but only 1024 will show in the cell. all > 37767 will show in the fomula bar....the box at the top of the screen. > > regards > FSt1 > > "rsenn" wrote: > > > When viewing a spreadsheet and I click on a cell, all text in the cell shows > > up in the box at the top of the screen but all of the text doesn't show up on > > the screen if I am not in that particular cell? How can I make all text show > > up in all cells? -- Dave Peterson

RE: Viewing Text In A Cell Shane Devenshire 12/30/2008 8:15:01 AM Hi, To see more text in the cell you will need to 1. Merge a number of cells or 2. Resize the row height and/or column width If this helps, please click the Yes button Cheers, Shane Devenshire "rsenn" wrote: [Quoted Text] > When viewing a spreadsheet and I click on a cell, all text in the cell shows > up in the box at the top of the screen but all of the text doesn't show up on > the screen if I am not in that particular cell? How can I make all text show > up in all cells?

RE: Viewing Text In A Cell Shane Devenshire 12/30/2008 4:32:03 PM Hi, the answer is version dependent: 2003: Cells can contain 1024 characters in a formula Cells can contain 32,767 text characters but only the first 1023 will be visible (unless you use Alt Enter to force line breaks) 2007: Cells can contain 8192 characters in formulas Cells can contain 32,767 text characters in cells and all can be seen and printed without needing to use Alt Enter. If this helps, please click the Yes button, Cheers, Shane Devenshire -- If this helps, please click the Yes button Cheers, Shane Devenshire "rsenn" wrote: [Quoted Text] > When viewing a spreadsheet and I click on a cell, all text in the cell shows > up in the box at the top of the screen but all of the text doesn't show up on > the screen if I am not in that particular cell? How can I make all text show > up in all cells?