How to make a key float in an excel wksh when a person scrolls.

P

Pete_UK

If your key is, say, an explanation of the colours you have used and
the range of values they represent, then you could arrange these on
one row (across many columns) at the top of your sheet and use Window
| Freeze Panes with the cursor in A3, so that the top two rows will
always be visible as you scroll down.

Hope this helps.

Pete
 
K

Kelly

for instance, if you have a chart, the key, indicating what the colors mean,
will stay in once place on the screen when you scroll down.
 
P

Pete_UK

With a chart you can set up a legend (key) which you can choose to
place at the top, bottom, left or right of your chart. I am not aware
of any way to fix this on the screen as you scroll around - must be a
big chart if you need to scroll !

Pete

for instance, if you have a chart, the key, indicating what the colors mean,
will stay in once place on the screen when you scroll down.
--
Kelly C



Pete_UK said:
If your key is, say, an explanation of the colours you have used and
the range of values they represent, then you could arrange these on
one row (across many columns) at the top of your sheet and use Window
| Freeze Panes with the cursor in A3, so that the top two rows will
always be visible as you scroll down.
Click to expand...
Hope this helps.
Pete
Click to expand...

Click to expand...

- Show quoted text -
Click to expand...
 
Top