Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Viewing Text In A Cell
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Viewing Text In A Cell
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Viewing Text In A Cell
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: 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Viewing Text In A Cell
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: 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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Viewing Text In A Cell
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: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing Cell Data | Excel Discussion (Misc queries) | |||
viewing shaded cells or text in spreadsheet | Excel Discussion (Misc queries) | |||
UserForms - Viewing multiple entries in a text box. | Excel Discussion (Misc queries) | |||
How do I keep text viewing correctly as I change zoom % | Excel Discussion (Misc queries) | |||
Cell Contents cut off from viewing | Excel Discussion (Misc queries) |