Cell Size?

  • Thread starter Thread starter Tavish Muldoon
  • Start date Start date
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.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the number of words per cell in Excel be increased? 8
Excel 2003 - Maximum number of characters a cell can contain? 1
Cell format - wrap text 7
Excel Typed text appears in wrong cell 0
Does the Text format have a size limit? 1
Printing too much! 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Partial Hidden Text in a cell 2

Back
Top