microsoft excel courses - summing

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Summing

microsoft excel courses - Summing

resolvedResolved · Low Priority · Version Standard

Nikki has attended:
Excel Introduction course

Summing

how to autosum a row?

RE: summing

Hi Nikki

To use Autosum button from the standard toolbar, place your cursor where you want the result of the sum calculation to be displayed.

Ensure there is no data in the column immediately above the cursor position.
Ensure there is data immediately to the left of the cursor position; by then selecting Autosum Excel will confirm the summing of the row with "marching ants"

If there is data immediately above the cursor position Autosum will attempt to sum the column, you will then need to manually highlight the range of cells in the row





 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips


Server loaded in 0.07 secs.