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

[Guest]

--
Kelly C

 

[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

 

[Gord Dibben]

What do mean by "float a key"?

What is a "key"?


Gord Dibben MS Excel MVP

 

[Guest]

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.

 

[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

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

- Show quoted text -

 

[Gord Dibben]

In that case, Pete has the right solution.


Gord