×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Microsoft: Office FAQ

Best of Excel

The Excel CAMERA Feature by SkipVought
Posted: 20 Sep 11

Once you know about it, have it in your toolbox and focus! your efforts, you will develop ways to use it!

This link to John Walkenbach's excellent site, explains the feature and how to find it.

http://spreadsheetpage.com/index.php/oddity/the_camera_tool/

Here is the nifty feature. It is no just a picture.  a picture is static.  This is a DYNAMIC linked picture.  As the range linked to the picture changes, so does the picture; both the content and the size of the picture.  What a way to widen your field of view!

So how can this be used?

Suppose that you have a summary sheet with a bunch of small dissimilar summary tables. You want to have 3 or 4 tables, but the columns just don't match up nicely.  Well just as you might with several chart objects, you can also use several camera pictures place wherever you want and each linked to the source table on another sheet.

Suppose you have a sheet with a multi row heading area of summary values and the columns of the data area below it, again does not match the data in the complex heading area.  You can use the Camera feature for either the heading are or the data area, or both.

It's really a, er uh, SNAP to use!  winky smile
 

Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close