#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
eve eve is offline
external usenet poster
 
Posts: 23
Default Roving Text Box

I have a spreadsheet that is approx 329 rows and is color coded. I currently
have the color legend at the bottom of the document. I would like to have the
legend remain in view while scrolling through the document. Is this possible?
If so, please let me know how to do it.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,646
Default Roving Text Box

One way:
Select cell in column A just above legend row then WindowSplit up

Regards,
Stefi

€žEve€ť ezt Ă*rta:

I have a spreadsheet that is approx 329 rows and is color coded. I currently
have the color legend at the bottom of the document. I would like to have the
legend remain in view while scrolling through the document. Is this possible?
If so, please let me know how to do it.

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
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t zzxxcc Excel Worksheet Functions 2 August 26th 08 11:04 PM
Sumif text is contained winthin a longer text string in a cell Johnny M[_2_] Excel Worksheet Functions 3 March 21st 07 02:50 PM
Text does not display in "Text boxs" and when wrapping text in a c Esteban Excel Discussion (Misc queries) 1 March 8th 07 11:59 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
merged cells into one text cell, size varies dependant on text dat Jazzylady825 Excel Discussion (Misc queries) 0 December 9th 05 08:26 PM


All times are GMT +1. The time now is 09:35 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"