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

--
Kelly C

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

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

On Mar 6, 11:50 pm, Kelly wrote:
--
Kelly C

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

What do mean by "float a key"?

What is a "key"?


Gord Dibben MS Excel MVP

On Tue, 6 Mar 2007 15:50:05 -0800, Kelly
wrote:

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

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" wrote:

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

On Mar 6, 11:50 pm, Kelly wrote:
--
Kelly C

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

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

On Mar 7, 2:49 pm, Kelly wrote:
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" wrote:
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

On Mar 6, 11:50 pm, Kelly wrote:
--
Kelly C- Hide quoted text -

- Show quoted text -

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

In that case, Pete has the right solution.


Gord

On Wed, 7 Mar 2007 06:49:21 -0800, Kelly
wrote:

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.