View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default Viewing hidden data

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.



---
Regards.
Norman

wrote in message
...
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