How much can I fit into a cell?

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?
 
G

Gord Dibben

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

Resize cell to fit picture 3
To much space in my cell? 3
How to fit each cell into a perfect square? 3
Auto fit text in cell of a protected worksheet 3
Insert Picture into a cell 1
Auto fit row height for one column 3
changing the row height to fit 2
Linking Spread Sheets 1

Top