How to lock a legend on screen

G

Guest

I want my legend, which I created in column G, cells 1 through 12, to be
visible in column G, regardless of the row I am working on. So if I am
editing row 231, I want the legend to show up in Cell G231 though G242. In
this way the legend is ALWAYS visible.....

Is this possible?
 
D

Dave O

If you land the cell pointer on H13 and click Window Freeze Panes, H13
becomes the axis of the frozen panes. You might then hide columns A-F,
thereby displaying column G only. Whether this will work or not
depends on what you have in A-F, and whether it must be displayed at
all times.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top