The Excel camera – smile please! By Simon Hurst

PhotosSimon 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.

Continued...

» Register now

The full article is available to registered AccountingWEB 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.

Comments
shurst's picture

Thanks

shurst | | Permalink

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

Paul Scholes's picture

Simon - you've made my day

Paul Scholes | | Permalink

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

Powerpoint table

Anonymous | | Permalink

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.