auto sum

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Auto Sum

Auto Sum

resolvedResolved · Low Priority · Version 2003

Sue has attended:
Excel Introduction course
Excel Intermediate course

Auto Sum

Where do I find Auto Sum

RE: Auto Sum

Hello Sue,

Thanks for your question and welcome to the forum

Auto sum can be found either:

On the Home ribbon on the right hand side in the Editing group.

OR

On the Formulas ribbon on the left hand side in the Function Library group.

Thanks and kind regards

Maggie


 

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


View all Excel hints and tips


Server loaded in 0.09 secs.