Active Cell displayed in another cell?

R

Rich

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?
 
E

Earl Kiosterud

Rich,

An event-driven macro could put the selected cell where you want it. Or
maybe better yet, in the status bar, or in a modeless form (stays on the
screen, and lets you continue working. Requires Excel 2000 or newer). We
can write it for you if you're interested.
 
R

rgarber50

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
 
Top