ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format Cell Question (https://www.excelbanter.com/excel-discussion-misc-queries/207173-format-cell-question.html)

Rebecca

Format Cell Question
 
Greetings. I am using VISTA and Excel 2007.

I have many cells the contents of which are truncated -- that is, the entire
contents of the cells are not visible but cut off at the bottom. I have tried
to Format Cells / Autofit Cell Height, but the bottom part of many cells is
not visible.

If I mouse clink on the cells the entire contents appears, but when I leave
the cells the contents go back to be truncated.

Could one of the experts help me out here? Thanks.

Gary''s Student

Format Cell Question
 
All the text will be visible in the formula bar, but not in the cell. To
make the text visible in the cell, include a hard break every couple of
hundred characters.
--
Gary''s Student - gsnu200809


"Rebecca" wrote:

Greetings. I am using VISTA and Excel 2007.

I have many cells the contents of which are truncated -- that is, the entire
contents of the cells are not visible but cut off at the bottom. I have tried
to Format Cells / Autofit Cell Height, but the bottom part of many cells is
not visible.

If I mouse clink on the cells the entire contents appears, but when I leave
the cells the contents go back to be truncated.

Could one of the experts help me out here? Thanks.



All times are GMT +1. The time now is 11:59 AM.

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