Keep certain cells visible when scrolling, not just rows or colum

[Guest]

I would like to keep a group of cells visible when scrolling through an excel
document. I have a frozen the row I want but need this additional information
visible at all times.

Thank you for your assistance

 

[Paul B]

mgdarkman, you can copy the range you want to keep visible and then right
click where you want to put them and paste special, paste link.
Or if you have date you don't want to overwrite you could use the camera
tool to take a picture of the range and put it where you want, the camera is
found under tools \ customize \ commands \ tools \ camera, you can also drag
the camera tool to your tool bar where it will be easy to get to

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Max]

Another option to play with .. we could also open another window (or more)
on the same sheet, then tile both windows to taste (I use this frequently)

Click Window > New Window
Click Window > Arrange > Horiz (or Vert) > OK

(To close the extra window,
click the "x" at the top right corner of that window, save the file)

 

[Guest]

Perhaps I have not explained myself very well as I have received 2 replies
that don't do what I am looking for. I have a sheet with the panes frozen on
row 4. I have seen sheets that as you scroll down either on the left or the
right a box will move down with you. What I am trying to accomplish is to
move a legend down the page as you scroll. Hope this helps to clarify what I
am looking for

 

[Guest]

Perhaps I have not explained myself very well as I have received 2 replies
that don't do what I am looking for. I have a sheet with the panes frozen on
row 4. I have seen sheets that as you scroll down either on the left or the
right a box will move down with you. What I am trying to accomplish is to
move a legend down the page as you scroll. Hope this helps to clarify what I
am looking for

 

[Max]

Perhaps you're referring to this ..

Select say, col B

Click Data > Validation > Input Message tab

Enter the title, and the input message, eg:

Title: Legend

Input message:

Ratings
---------
AAA = Triple A
AA = Double A
etc

Click OK

Select any cell in col B, and the "legend" box will be visible
Move the box to a desired display position

Now when we scroll up / down, the "legend" will continue to be visible in
the same position (as long as the active cell remains within col B)

 

[Max]

FWIW, you might also want to check out this download:
http://www.jkp-ads.com/Download.htm#WatchOtherCell
(WatchOtherCell.zip)

... traced via:
http://www.dicks-blog.com/archives/2006/02/09/watching-the-content-of-anothe
r-cell/

(It doesn't work in my xl97, needs xl2000 and up,
so guess I'm outta luck here ..)

---

 

[Guest]

Thank you for the reply. I will try this later today.
Michael

 

[Max]

You're welcome. Thanks for posting back ..