format to see bottom of cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top