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?