Sometimes I need to analyse data (row-by-row) in a worksheet with a lot of columns. Sometimes I then want to see information from a cell in a column way off to the far right together with a couple of columns on the left side of the sheet. Of course you can split the window, freeze the panes, but this isn’t always sufficient.
I devised a tiny utility that shows a modeless window (only works in XL2000 and up) which displays the content of a cell in a set column on the same row:
The form can be resized to get it out of the way and accomodate for the amount of information you want to see.
Find it here.