format to see bottom of cell

D

Dang Tran

I want to find out if there is a way to format a cell so I can view the
bottom half of the cell because there are more text then the height of the
cell. I don't want to increase the height of the cell.

Thanks in advance
 
M

Max

Maybe an indirect way would be to write the text in the cells into their own
comment boxes ? Then, hovering the mouse over the cell will display the
desired full text in the cell w/o having to increase the row height.

You might wish to check out Dave M's page at:
http://www.mvps.org/dmcritchie/excel/ccomment.htm

Look for: Sub AddComments()

The sub will populate comments in a range with text values of another range
(#addcomments), but you can also select the same source range for the
comments to be written into, not necessarily another range
 
Top