How do you get the formula bar in Excel '07 to automatically display a FULL
view of entered text when the cell is selected - like in Excel '03?

I have a *.xls spreadsheet created in Excel '03, and converted to *.xlsm in
Excel '07 (one active macro).

The cells have text entries that I highlight and copy/paste into another
program. They are relatively small entries (40 - 80 characters/cell) and may
or may not have ALT-Enter line breaks (for spacing) inserted in the text.
The cell text is valuable only for copy/paste, so the cell is set at 8.43
width, 12.75 height, wordwrap is not enabled, so the text runs over the top
of many cells to the right of the cell entry.

In Excel '03, when I clicked on the cell to select, the formula bar would
"drop down" and display the entire contents of the cell. Then I could
highlight and copy. Now in Excel '07, only the first line of text is
displayed when the cell is selected.

I can click on the up/down arrows on the right end of the formula bar to
up/down through the cell contents line-by-line, but that doesn't allow a full
copy/paste of the cell contents. I can also click on the "double-down" arrow
on the right end of the toolbar, and will open a larger pre-defined formula
bar view. The pre-defined view may be too small for the cell entry, and you
can drag edges for a larger view, but I would prefer not to constantly
re-size the display.

Is there any way to get the cell to automatically display a "right-sized"
full view of the entered text when the cell is selected - regardless of the
amount of text entered?

Thanks in advance!
--
Gordon308