Cell Size?

T

Tavish Muldoon

Is there a maximum limit to each cell I can add text to.? Some cells
with a lot of text give me a ################3 when I print them out,
but if I click on it - it will display the data up the 'cell bar'.

Can I prevent this?

Thanks,

Tmuld.
 
I

icestationzbra

for excel limits, look for "Excel specifications and limits" in excel
help.

Length of cell contents (text) 32,767 characters. Only 1,024 display in
a cell; all 32,767 display in the formula bar.

if you are getting #'s, you might want to try changing the cell's
format from Text to General.
 
F

Frank Kabel

Hi
the limit is 1,024 characters. You can extend this limit by manually
entering linebreaks (with ALT+ENTER). Also make the cell large enough
 
Top