Floating a Key Range (Excel 2007)
 

Is is possible to select a range of cells (say, a color key for your data)
and have it "float" alongside as you scroll down or across your spreadsheet?
Kind of like toolbars used to be floating, before the Ribbon.

As I color code my data, I have problems remembering what data is which
color. The floating key would help a great deal.

Thanks!

Floating a Key Range (Excel 2007)
 

you might be able to put it in the first column and row, and then freeze
panes leaving this section always visible.

"That70sHeidi" wrote:

Is is possible to select a range of cells (say, a color key for your data)
and have it "float" alongside as you scroll down or across your spreadsheet?
Kind of like toolbars used to be floating, before the Ribbon.

As I color code my data, I have problems remembering what data is which
color. The floating key would help a great deal.

Thanks!