Perhaps you didn't notice that all formulas in XL start with an equal sign.

If you have a 10 column by 10 row array (A1 to J10), and you want to total
each individual column AND each individual row, start with this in A11:
=Sum(A1:A10)
And this in K1:
=Sum(A1:J1)

Now, XL allows you copy these formulas from cell to cell, and
*automatically* changes the cell references to accommodate for the new
location of the copied formula.
Copying the formula from A11 to B11 will result in the formula changing to:
=Sum(B1:B10)
And copying the formula in K1 to K2 will result in:
=Sum(A2:J2)

To copy a cell (formulas OR data), select the cell.
You'll notice a small square in the lower right hand corner of the
selection.
This is called the "Fill Handle".
Hover the cursor over this square until it changes from a fat white cross to
a skinny black cross.
Then click and drag this fill handle down a column or across a row as far as
you need to copy the original's contents.

In XL, there's always more then one way to accomplish any task.
Here are a few ways (formulas) that you could use to total the contents of
cells A1 to A10:

=Sum(A1:A10)
=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10
=Sum(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10)

Each syntax has it's own benefits which we won't get into here.

Post back with any further questions.