ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to have the full text of a cell shown (https://www.excelbanter.com/excel-discussion-misc-queries/115810-how-have-full-text-cell-shown.html)

Max Caminzuli

how to have the full text of a cell shown
 
I have Exel 2003.
In a cell with a long text, only half of it is shown. This happens even if I
increase the hight of the cell. The full text is there but only few lines are
shown. ? What can I do to have the whole text written down
Thank you

Max

CLR

how to have the full text of a cell shown
 
Right-click FormatCells AlignmentTab check WrapText, then either
increase the height of the cell to fit, or widen the column, or both.
Depending on your circumstances, the use of a TextBox may be more appropriate
than putting a bunch of text in a single cell.

Vaya con Dios,
Chuck, CABGx3



"Max Caminzuli" wrote:

I have Exel 2003.
In a cell with a long text, only half of it is shown. This happens even if I
increase the hight of the cell. The full text is there but only few lines are
shown. ? What can I do to have the whole text written down
Thank you

Max


Kevin B

how to have the full text of a cell shown
 
Regardless of how you format your display this is the cell limitations,
lifted directly out of Excel Help:

Character limit of 32,767 characters per cell .
Display limit of 1,024 characters per cell;
All 32,767 display in the formula bar.
--
Kevin Backmann


"Max Caminzuli" wrote:

I have Exel 2003.
In a cell with a long text, only half of it is shown. This happens even if I
increase the hight of the cell. The full text is there but only few lines are
shown. ? What can I do to have the whole text written down
Thank you

Max


Dave Peterson

how to have the full text of a cell shown
 
Try adding alt-enters every 80-100 characters. This will force new lines within
the cell and you'll see many more than the documented 1k or so.

Max Caminzuli wrote:

I have Exel 2003.
In a cell with a long text, only half of it is shown. This happens even if I
increase the hight of the cell. The full text is there but only few lines are
shown. ? What can I do to have the whole text written down
Thank you

Max


--

Dave Peterson


All times are GMT +1. The time now is 09:43 PM.

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