Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
camera

ResolvedVersion 2010

Iwona has attended:
Excel Intermediate course
Excel Intermediate course

Camera

I want to use camera function to copy sth and paste to another file but I have completly forgot where it is located. can you advise

RE: Camera

Hi Iwona, thanks for your query. You'll need to add this to your quick access toolbar, I'm afraid. The camera tool is not on the ribbon.

1) Click on the drop down on the right of the QAT
2) Choose More Commands
3) Change from "Popular Commands" to "All Commands"
4) Scroll down the list to the camera tool, select it and click Add. Then click OK. It should now be on the QAT and available for use.

Hope this helps,

Anthony

Wed 18 Jan 2012: Automatically marked as resolved.

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.