Put the first formula in A5, i.e.:

=SUM(A1:A4)

then copy that formula and paste into B5:E5, or whatever.

Hope this helps.

Pete


"hhspotts" wrote in message
...
I have a table in which I want the total (SUM) of each column--is there a
shortcut to inserting the formulas or do I have to do =SUM(A1:A4),
=SUM(B1:B4), =SUM(C1:C4) etc.?

hhspotts