![]() |
Cells not showing all the text
I had already asked this, but the thread fell into oblivion, so here I go
again: I use a spreadsheet to keep track of some tasks and sometimes the text gets a bit long with all the description that is included, causing Excel not to show the full content of the cell, even though cells are formated to "Wrap Text" and I had dragged the bottom margin of the specific cell farther down. My work around has been to press Alt Enter to cause a line break (sometimes at several points of a single task) and this way the text is shown complete. Is there a way I can avoid this annoyance or is this some kind of limitation of Excel? Jorge E Jaramillo |
Cells not showing all the text
You had a couple of replies to your original post.
See help on "specifications" to see that it is a limitation. Alt + Enter is the only way to increase the 1024 visible limit although if you were to use small enough font you can increase some more. Gord Dibben MS Excel MVP On Tue, 6 Oct 2009 12:28:03 -0700, Jorge E. Jaramillo wrote: I had already asked this, but the thread fell into oblivion, so here I go again: I use a spreadsheet to keep track of some tasks and sometimes the text gets a bit long with all the description that is included, causing Excel not to show the full content of the cell, even though cells are formated to "Wrap Text" and I had dragged the bottom margin of the specific cell farther down. My work around has been to press Alt Enter to cause a line break (sometimes at several points of a single task) and this way the text is shown complete. Is there a way I can avoid this annoyance or is this some kind of limitation of Excel? Jorge E Jaramillo |
Cells not showing all the text
Thanks for your answer.
I saw the replies to my original post, but they did not fix the problem. "Gord Dibben" wrote: You had a couple of replies to your original post. See help on "specifications" to see that it is a limitation. Alt + Enter is the only way to increase the 1024 visible limit although if you were to use small enough font you can increase some more. Gord Dibben MS Excel MVP On Tue, 6 Oct 2009 12:28:03 -0700, Jorge E. Jaramillo wrote: I had already asked this, but the thread fell into oblivion, so here I go again: I use a spreadsheet to keep track of some tasks and sometimes the text gets a bit long with all the description that is included, causing Excel not to show the full content of the cell, even though cells are formated to "Wrap Text" and I had dragged the bottom margin of the specific cell farther down. My work around has been to press Alt Enter to cause a line break (sometimes at several points of a single task) and this way the text is shown complete. Is there a way I can avoid this annoyance or is this some kind of limitation of Excel? Jorge E Jaramillo |
Cells not showing all the text
When you don't get a satisfactory "fix" best you stay in the original thread
so's we know that you are not satified with the truth. Gord On Wed, 7 Oct 2009 05:36:01 -0700, Jorge E. Jaramillo wrote: Thanks for your answer. I saw the replies to my original post, but they did not fix the problem. "Gord Dibben" wrote: You had a couple of replies to your original post. See help on "specifications" to see that it is a limitation. Alt + Enter is the only way to increase the 1024 visible limit although if you were to use small enough font you can increase some more. Gord Dibben MS Excel MVP On Tue, 6 Oct 2009 12:28:03 -0700, Jorge E. Jaramillo wrote: I had already asked this, but the thread fell into oblivion, so here I go again: I use a spreadsheet to keep track of some tasks and sometimes the text gets a bit long with all the description that is included, causing Excel not to show the full content of the cell, even though cells are formated to "Wrap Text" and I had dragged the bottom margin of the specific cell farther down. My work around has been to press Alt Enter to cause a line break (sometimes at several points of a single task) and this way the text is shown complete. Is there a way I can avoid this annoyance or is this some kind of limitation of Excel? Jorge E Jaramillo |
All times are GMT +1. The time now is 07:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com