Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamic chart on user selected data range in Excel 2007 turen Charts and Charting in Excel 5 September 1st 07 02:03 AM
Pivot tables range valued upon save in Excel 2007 brad Excel Discussion (Misc queries) 2 May 22nd 07 11:50 AM
Changing a pivot table's data range in Excel 2007 Ken W Excel Worksheet Functions 1 April 1st 07 03:45 PM
Excel 2007 Display value based on values in another column range ChrisM Excel Worksheet Functions 2 September 4th 06 03:32 PM
Excel Range permission , Office 2007 Beta 2 Ali Excel Discussion (Misc queries) 0 June 24th 06 11:39 AM


All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"