Viewing Text In A Cell

[rsenn]

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?

 

[FSt1]

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

 

[Dave Peterson]

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.

 

[Shane Devenshire]

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

 

[Shane Devenshire]

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