Faculty/Staff Help Student Help About Computer Services    
   

Excel Tip - Easily create multiple sums at once

If you need to create a series of sums, such as beneath multiple columns or at the ends of multiple rows, you can create all the sums at once with a single mouse click. Rather than creating individual sum formulas or copying a sum formula from one cell to the rest of the range, simply select the appropriate range of cells (including the empty cells where the totals will be placed) and then click the AutoSum button on the Standard toolbar.

 

 

 

 
Ouachita Baptist University • Computer Services
Cone Bottoms Hall 250 • 870.245.5567

online support form support@obu.edu www.obu.edu