Help-forgot what this feature is called

Mr930

Well-known Member
Joined
Aug 31, 2006
Messages
585
I have not used this but want to check it out but i can't remember what it is called to look it up.

I want to set up an area to become a print area, but this area points to various other parts of the spreadsheet, like a snapshot. Is that what it is called?

thanks
Fred
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Mr930

Well-known Member
Joined
Aug 31, 2006
Messages
585
That would be it, I think the icon was a little camera on the 2003 menu, I am now in 2007.
 
Upvote 0

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
The Camera tool is available in XL 2007 (if you know how to find it!).

Left click the Office Button > Excel Options > Customize > on the Choose commands from select All Commands. Scroll down to Camera and left click it then click the Add button then click OK. This will add it to the Quick Access Toolbar (QAT).
 
Upvote 0

Forum statistics

Threads
1,190,692
Messages
5,982,317
Members
439,773
Latest member
tyruschen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top