The Excel camera – smile please! By Simon Hurst

Kashflow logo
3

Simon Hurst offers some tips on how to use Excel's little know 'camera' feature.

The recent Excel Zone compendium article on printing led to an extensive exchange of comments mainly centred around setting the print area to include several individual, distinct areas. This is relatively easy to accomplish by holding down the Control key while selecting additional areas. However, if the print area is made up of separate areas, then Excel will print each on a separate page.

Of course, you could create a separate sheet with links to all the different areas, arranged as you wish them to print, but this might be tricky to maintain. Changing...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

Share this content

Replies

Please login or register to join the discussion.

By shurst
11th Jul 2008 17:33

Thanks
Liam - many thanks for the PowerPoint example and Paul thanks for taking the trouble to let us know how useful you found the article - it's great to know that something has been of help.

Regards

Simon

Thanks (0)
10th Jul 2008 14:53

Simon - you've made my day
It is rare these days for me to be "WOWd" and even if I am, I rarely let the other person know, but you have managed it.

My immediate thought was of a number of huge messy spreadsheets that we or clients prepare and within which we have to set up little "print this bit" areas because the rest of the sheet is such a mess or the key figures are half a mile apart. Not only is this time consuming but when the 5 little bits are printed or PDFd we end up with 5 sheets with differing positions on the page and where text & numbers look either 20 or 6 point.

Brill


Thanks (0)
avatar
By Anonymous
09th Jul 2008 15:38

Powerpoint table
I use the paste picture link to show tables on powerpoint pages. They are embedded as pictures and are thus not adjustable by the reader, unlike a simple copy/paste table would be.

You only need one use for a feature if it's a good one.

Thanks (0)