Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Viewing hidden data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jambun@bigpond.com.au - 22 May 2008 07:42 GMT
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 - 22 May 2008 08:17 GMT
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

>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
[quoted text clipped - 3 lines]
> returned values in columns  Y:AJ are off screen
> Thanks EPJ
jambun@bigpond.com - 22 May 2008 10:46 GMT
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

>Hi Jambun,
>
[quoted text clipped - 34 lines]
>> returned values in columns  Y:AJ are off screen
>> Thanks EPJ
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.