Wher is my Camera Button in Excel 2007?

[wx4usa]

In my older version of Excel I had a small Camera/Picture Icon. Where
is it in 2007 ?

 

[Chip Pearson]

Right-click on the ribbon tab names region and choose "Customize the
Quick Access Toolbar". Change "Choose Commands From" from "Popular" to
"All". There, scroll down in the list to "Camera" and click the "Add"
button to add it to the QAT.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Ron de Bruin]

Hi wx4usa

See
http://www.rondebruin.nl/notinribbon.htm

 

[wx4usa]

Right-click on the ribbon tab names region and choose "Customize the
Quick Access Toolbar". Change "Choose Commands From" from "Popular" to
"All". There, scroll down in the list to "Camera" and click the "Add"
button to add it to the QAT.

Cordially,
Chip Pearson
Microsoft MVP
    Excel Product Group
Pearson Software Consulting, LLCwww.cpearson.com
(email on web site)

Thank you Chip!

 

[Martin ©¿©¬]

In my older version of Excel I had a small Camera/Picture Icon. Where
is it in 2007 ?

Hi
What does the camera button do & what would I use it for?

 

[Chip Pearson]

The Camera is a useful but largely unknown tool in Excel. It allows
you to take a picture of a range of cells and have a live link between
the picture and the cells. Change a cell and the picture will update.

You can use it to display part of one sheet as a floating image on
another sheet. For example, if you wanted to display to the user range
C1020 from Sheet3 on Sheet1, you can use the Camera to create an
image of the range on Sheet3 and display it on Sheet1. I recently used
it in a dash-board type application. On the main worksheet, columns
were formatted to various width for data display, but the user wanted
a Gantt chart display on Sheet1. Because the columns on Sheet1 were
variable width, a Gantt chart could be created on Sheet1 because the
item width were not constant. So, I created the Gantt chart on a new
worksheet and used Camera to put the live link image from the Gantt
sheet on to Sheet1.

It is unfortunate that so few people know what the Camera is. It is a
very useful tool (and the topic of an upcoming page on my web site).

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Martin ©¿©¬]

Thank you Chip for that tutorial

 

[Roger Govier]

Hi Chip

The Camera is a useful but largely unknown tool in Excel

I quite agree.
I think it is fantastically useful, and something I make quite a lot of use
in clients reports.
I look forward to your upcoming page as a reference site to show people how
to use it.

 

[Jeff Jensen]

Thanks Chip, very useful information.

Jeff

The Camera is a useful but largely unknown tool in Excel. It allows
you to take a picture of a range of cells and have a live link between
the picture and the cells. Change a cell and the picture will update.

You can use it to display part of one sheet as a floating image on
another sheet. For example, if you wanted to display to the user range
C1020 from Sheet3 on Sheet1, you can use the Camera to create an
image of the range on Sheet3 and display it on Sheet1. I recently used
it in a dash-board type application. On the main worksheet, columns
were formatted to various width for data display, but the user wanted
a Gantt chart display on Sheet1. Because the columns on Sheet1 were
variable width, a Gantt chart could be created on Sheet1 because the
item width were not constant. So, I created the Gantt chart on a new
worksheet and used Camera to put the live link image from the Gantt
sheet on to Sheet1.

It is unfortunate that so few people know what the Camera is. It is a
very useful tool (and the topic of an upcoming page on my web site).

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)