98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Summing
microsoft excel courses - Summing
Resolved · Low Priority · Version Standard
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |