How much can I fit into a cell?

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I have a spread sheet of many thousands or rows and my comments are always
moving causing me a lot of extra work so I tried to move them into the cells
but only about 125 row height is all I can get. I can make the cell as large
as I want but the data goes to the bottom and leaves the top empty. I'm
using Excel XP. Anyway to fix this problem?
 
Excel specs say that you can enter 32767 characters in a cell but only 1024
of them will show or print.

You can increase this number by adding an Alt + Enter every 100 or so
characters.

And ...........no, merging several cells does not increase this limit.


Gord Dibben MS Excel MVP
 

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

To much space in my cell? 3
Insert Picture into a cell 1
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
Auto fit wrapped and merged cells in entire worksheet 8
Resize cell to fit picture 3
Cell does not expand to fit text 1
Rows expand to fit text typed in? 2
Auto fit text in cell of a protected worksheet 3

Back
Top