Have you thought obout using the format/alignment/wrap text feature?
This way you could adjust the row height and the column width could
remain the same. Perhaps you could create a macro that toggles row
autofit on and off?

I hope I understand what you are trying to achieve and this helps
Richard



Rich Wrote:
I have a column where the cell contents are sometimes 200+ characters
long.
For me to see everything, I have to widen the column almost full-width
of my
screen, forcing all other columns off the screen, leaving me no choice
but to
scroll back and forth.

Normally, I could just select that cell and look in the Formula Bar to
see
that cell's full contents. Unfortunately, this column uses a VLOOKUP
formula
to populate the cells so I cannot see what the values are; all I see
are the
formulas.

My worksheet already has split panes. In the top pane, I would like to
merge
several cells together and be able to see the full width of any cell I
select
*without* resizing that cell in the bottom pane. Can this be done?


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=393508