excel is hiding some text?

Question

I have an excel sheet which had a fair amount of info in one cell, no matter how big i make the cell excel is hiding some text on me, i can see it when i double click the cell but when i click on another cell it goes away and when i print it will only print to a certain point in the text then cut off the rest of the text but the cell is spaced and big enough for all of the text.....what do i do??
tks

Answer 1

Excel has limits on character display

Excel can display only the first 1,024 characters in each cell. 32,767 will show in the formula bar. It might have changed with Excel 2007/2010. And when printing it out, the first 1,024 will display. It does not matter how big you make the cell.

A workaround is to dump the table into Word. If all the cells fit.



Your next question, how can I fix it? Is there an add-on? Nope.

Answer 2

Something similar happened to me once. What worked for me was to right click and select format cell. Then check whats your cell currents format maybe is on number and it should be in text. What happened to me is that I wrote words that excel recognized as something else so I just had to change the format to number instead of text. Also in alignment click wrap text. Hope it works for you!

Answer 3

you may pass to record > web page Setup... Then contained in the "Sheet" tab, there is an determination (on the precise) to pick "Print section". click on the little button on the precise of this and it is going to assist you to pick on your spreadsheet which parts you want to print (in basic terms by clicking and dragging). this will also cut back the window you're in to one small line. in case you want to provide up after a click and drag and choose more beneficial then one section, in basic terms carry down Ctrl. once all parts are chosen, click the little button back to carry decrease back the window with your web page Setup ideas; click ok. Then once you pass to record > Print... it is going to purely print your renowned parts.