My understanding of Excel's "Freeze Panes" feature is that you can only freeze the left-most column(s), or top-most row(s).
However, I have a table where a very important column needs to be located on the far-right, because elsewhere I am using the
VLOOKUP function to pull data from this table.
Having this column on the far-right makes like easy on the function end... but since there are so many columns in the table, this layout makes life harder for the user on the data-entry end.
Is there any trick or technique by which I could achieve the same effect as "Freeze Panes" for this far-right column? That is, have the right-most column always appear on the screen, as the user scrolls horizontally across the other columns?