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

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

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

"mgdarkman" <mgdarkman@discussions.microsoft.com> wrote in message
news:C2CEBFEA-3D2B-4012-9983-26F86C622A7C@microsoft.com...
> 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

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

"Paul B" wrote:

> 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
>
> "mgdarkman" <mgdarkman@discussions.microsoft.com> wrote in message
> news:C2CEBFEA-3D2B-4012-9983-26F86C622A7C@microsoft.com...
> > 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
>
>
>

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mgdarkman" <mgdarkman@discussions.microsoft.com> wrote in message
news:C2CEBFEA-3D2B-4012-9983-26F86C622A7C@microsoft.com...
> 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

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" wrote:

> 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)
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "mgdarkman" <mgdarkman@discussions.microsoft.com> wrote in message
> news:C2CEBFEA-3D2B-4012-9983-26F86C622A7C@microsoft.com...
> > 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
>
>
>

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mgdarkman" <mgdarkman@discussions.microsoft.com> wrote in message
news:9114E8A5-1EF4-41D4-953B-858CED3741C1@microsoft.com...
> 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

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

"Max" wrote:

> 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
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "mgdarkman" <mgdarkman@discussions.microsoft.com> wrote in message
> news:9114E8A5-1EF4-41D4-953B-858CED3741C1@microsoft.com...
> > 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
>
>
>

You're welcome. Thanks for posting back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mgd" <mgd@discussions.microsoft.com> wrote in message
news:DACD8B9A-DB14-4D22-B487-444083FCDC73@microsoft.com...
> Thank you for the reply. I will try this later today.
> Michael

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

... traced via:
http://www.*****-blog.com/archives/2...tent-of-anothe
r-cell/

(It doesn't work in my xl97, needs xl2000 and up,
so guess I'm outta luck here ..)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---