ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How much text can I type into a single cell in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/50470-how-much-text-can-i-type-into-single-cell-excel.html)

KathfromWI

How much text can I type into a single cell in Excel?
 
I created a form in Excel with fill-in-the-blank formatting. Everything is
working beautifully except for one thing. I have one cell that I need to
record quite a bit of information in. Although everything I typed is all
there in the formula bar, it cuts off half the text in the cell.

I've increased the row height, have it set to wrap text and merge cells but
nothing seems to make a difference. I can't locate anything in the help menu
that addresses it.

Thanks,
Kathleen

Gary''s Student

Try inserting a manual return in your text (ALT-ENTER) every so often. It
should help make the text visible.
--
Gary''s Student


"KathfromWI" wrote:

I created a form in Excel with fill-in-the-blank formatting. Everything is
working beautifully except for one thing. I have one cell that I need to
record quite a bit of information in. Although everything I typed is all
there in the formula bar, it cuts off half the text in the cell.

I've increased the row height, have it set to wrap text and merge cells but
nothing seems to make a difference. I can't locate anything in the help menu
that addresses it.

Thanks,
Kathleen


KathfromWI

Thank you - that did the trick!

Kathleen

"Gary''s Student" wrote:

Try inserting a manual return in your text (ALT-ENTER) every so often. It
should help make the text visible.
--
Gary''s Student


"KathfromWI" wrote:

I created a form in Excel with fill-in-the-blank formatting. Everything is
working beautifully except for one thing. I have one cell that I need to
record quite a bit of information in. Although everything I typed is all
there in the formula bar, it cuts off half the text in the cell.

I've increased the row height, have it set to wrap text and merge cells but
nothing seems to make a difference. I can't locate anything in the help menu
that addresses it.

Thanks,
Kathleen



All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com