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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelly - 06 Mar 2007 23:50 GMT

Signature

Kelly C

Reply to this Message

Pete_UK - 07 Mar 2007 01:23 GMT

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

> --
> Kelly C

Reply to this Message

Kelly - 07 Mar 2007 14:49 GMT

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.

Signature

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
[quoted text clipped - 8 lines]
> > --
> > Kelly C

Reply to this Message

Pete_UK - 07 Mar 2007 17:23 GMT

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.
[quoted text clipped - 15 lines]
>
> - Show quoted text -

Reply to this Message

Gord Dibben - 07 Mar 2007 18:23 GMT

In that case, Pete has the right solution.

Gord

>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.

Reply to this Message

Gord Dibben - 07 Mar 2007 01:58 GMT

What do mean by "float a key"?

What is a "key"?

Gord Dibben MS Excel MVP

Reply to this Message