Saving large text field so it 'pops up'

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I want to put a block of text (100-300 characters) in a cell; the text may
consist of multiple lines.

I would like the to be able to keep the cell small (one text line high) when
the cell in not selected but see the whole text block when the cell is
selected ( or moused-over).

2 questions:
Is there a way to make the entire contents of a cell 'pop up' when the cell
is selected?

Is there a way to have accept newlines (when pasting) rather than moving
down to the next cell. (putting in Alt-Enter by hand is a drag).

Thanks,

Jim Cant
 
You could have a worksheet event that autofits the rowheight when you select
that cell (or row).

You could have a worksheet event that displays a textbox when you select the
cell.

But maybe you could just plop the text into a comment for that cell. When you
over the mouse over that cell, you'll be able to see the comment.

Alternatively, you could use Data|validation.
Use Any Value (on the Settings tab)
Type in your message in the Input Message tab
(check that "show input box when cell is selected")

=====
And instead of pasting into the worksheet, select the cell first and paste into
the formula bar (if I understood correctly).
 
Back
Top