Microsoft Office Tutorials and References
In Depth Information
An Introduction to the Camera T ool
The Camera tool creates an Excel object
that returns a picture of the range to which
it points.
A
B
C
1
2
3
4
Tom
Dick
Harry
Tom
To see how it works, enter the labels shown in column B, and
format cell B2 any way you want.
To use the Camera, first select cell B2. Click on the Camera tool
icon in your toolbar. When you do, Excel displays a marquee
around cell B2. Then click somewhere to the right of cell B3. When
you do, Excel displays a live copy of cell B2, as the figure shows.
If you change the text in cell B2, or change its formatting, the
Camera object updates immediately, even if your Calculation option
is set to manual.
With that brief introduction, let’s explore some of the ways that you
can use the Camera.
Ways to Use the Camera Tool
This section introduces a variety of ways to use the Camera tool for
dashboard reports, and other uses.
Display Tables with Different Column
Widths and Row Heights
Admittedly, this is a sorry excuse
for a management report. Even
so, the figure illustrates one
reason that the Camera is so
useful for dashboard reporting.
A
B
C
D
Product
Hats
Coats
Total
2
Sales
34
57
91
Costs
21
32
53
Profits
13
25
38
3
Top Customer
Smith & Company
Top Sales Person
Hermina Smith
4
This figure shows a worksheet that contains only two Camera
objects. The top object reports product profitability from one
worksheet; the bottom object reports customer and sales-person
 
Search JabSto ::




Custom Search