ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   formatting specific cell (https://www.excelbanter.com/new-users-excel/211289-formatting-specific-cell.html)

KristyLynn30

formatting specific cell
 
I have a large document , large in width, and large in height. All of my
cells are formatted for 'wrapped text', but one particular column, column H
will not format like all of the others.

My question, which is probably silly, is: Is there a limit as to how much
text you can create in just one single cell? Do I have too much text in this
one specific cell that it will not format correctly.

It's odd that ALL of my other cells will format, but this one particular
cell will NOT!!

Peo Sjoblom[_2_]

formatting specific cell
 
Look up specifications in help

--


Regards,


Peo Sjoblom

"KristyLynn30" wrote in message
...
I have a large document , large in width, and large in height. All of my
cells are formatted for 'wrapped text', but one particular column, column
H
will not format like all of the others.

My question, which is probably silly, is: Is there a limit as to how much
text you can create in just one single cell? Do I have too much text in
this
one specific cell that it will not format correctly.

It's odd that ALL of my other cells will format, but this one particular
cell will NOT!!




Shane Devenshire[_2_]

formatting specific 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.

"KristyLynn30" wrote:

I have a large document , large in width, and large in height. All of my
cells are formatted for 'wrapped text', but one particular column, column H
will not format like all of the others.

My question, which is probably silly, is: Is there a limit as to how much
text you can create in just one single cell? Do I have too much text in this
one specific cell that it will not format correctly.

It's odd that ALL of my other cells will format, but this one particular
cell will NOT!!


Shane Devenshire[_2_]

formatting specific cell
 
And, almost everything is in the help system under the topic specifications
(but not quite everything).

Cheers,
Shane

"KristyLynn30" wrote:

I have a large document , large in width, and large in height. All of my
cells are formatted for 'wrapped text', but one particular column, column H
will not format like all of the others.

My question, which is probably silly, is: Is there a limit as to how much
text you can create in just one single cell? Do I have too much text in this
one specific cell that it will not format correctly.

It's odd that ALL of my other cells will format, but this one particular
cell will NOT!!



All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com