Add Up (Sum) Entire Columns or Rows in Excel To sum columns or rows at the same time, use a formula of the form: =sum (A:B) or =sum (1:2) Remember that you can also use the keyboard shortcuts CTRL + SPACE to select an entire column or SHIFT + SPACE an entire row