Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell size 2007
WHAT IS THE LIMIT OF CHARACTERS IN A CELL in 2007?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell size 2007
Look up specifications in help
-- Regards, Peo Sjoblom "Bob Boyd" <Bob wrote in message ... WHAT IS THE LIMIT OF CHARACTERS IN A CELL in 2007? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell size 2007
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 "Bob Boyd" wrote: WHAT IS THE LIMIT OF CHARACTERS IN A CELL in 2007? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell size 2007
If we specifically open up a cell with many text characters, we can see them.
The problem is when the spreadsheet is opened "autoadjust" for the rows does not show all of the characters present. Is there a fix for that? -- Thanks for the help "Bob Boyd" wrote: WHAT IS THE LIMIT OF CHARACTERS IN A CELL in 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 - 2003 File Size | Excel Discussion (Misc queries) | |||
drop down box font size in 2007 | Excel Discussion (Misc queries) | |||
size of tab font in XL 2007 | Excel Discussion (Misc queries) | |||
cell size and font size | Excel Discussion (Misc queries) | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) |