Viewing hidden data

[jambun]

I have input values in 18 cells C8:T8 these cells return a value
through formulas to the cells Y8:AJ8 is there any way to view these
values at the bottom of the screen in some sort of a window so tha t
they can be seen as the values in C8:T8 are entered. And will scroll
to the next row when values are entered in C9:T9 etc. Note the
returned values in columns Y:AJ are off screen
Thanks EPJ

 

[Norman Jones]

Hi Jambun,

Try using Excel's Camera tool:

Menu | Tools | Customize | Customize Toolbars/Menus |
Commands Categories: All commands
Scroll down to find Camera
Drag to a toolbar

Then select cells C8:T8 and click on the
Camera icon; the border around the selected
cells transforms into a moving marquee and the
mouse pointer turns into a cross. Now click on
the worksheet to returns the Camera, which
can now be moved to the bottom of the sheet,
and which will display a dynamic view of the
cells of interest.

Alternatively:

Copy the range C8:T8 |
Hold the Shift key and select the Edit menu |
Choose Paste Picture Link

The resultant dynamic link may be moved to a
position of choice.

 

[jambun]

Norman
Both ideas of yours work fine but I need the information in the"Camera
View" to show the contents of the next row if i start entering values
in row D,E.F etc.ie: as i scroll to Row D the information in the
Camera Shot needs to scroll also.
Thanks
EPJ