Text staying put

[Guest]

Having created a data table in Excel, a key is required for colour coded
cells. Is it possible the keep the key in a set position whilst the
spreadsheet is is scrolled up and down. I would prefer not to split the
screen if possible.

 

[Guest]

You could open a 2nd window of the same spreadsheet and arrange them on the
screen so both are visible all the same time. I am not aware of any
possibility to have an "always on top" excel window.

Stephane.

 

[Dave Peterson]

You could put your key in the top few rows, then use window|Freeze so that those
rows are always visible.