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

autosum

ResolvedVersion Standard

Marika has attended:
Excel Intermediate course
PowerPoint Introduction course

AutoSum

Can you only access/find AutoSum in the toolbar or can it also be found in one of the menu options?

RE: AutoSum

Hi Marika, Thank you for your post, In answer to your question, the Autosum command (Sigma) on the toolbar is a shortcut to the 'Big Five' Sum, Count, Average, Max and Min, at the bottom of the menu (found by clicking on the drop down arrow) you will see the option more functions, this will open the More Functions dialog box which allows you access to all of Excel's functions, the More Functions dialog box can be accessed from the fx button on the Formula bar, but sadly in answer to your question no it is not available as one of the standard menu options. I hope that answers your question, best regards Pete.

Excel tip:

Navigate with keyboard without losing your active cell

If you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document.

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.