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
|