Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

The Quickest Way to Sum columns or rows in Excel Spreadsheet

Date:2019-8-30 Author:Cordelia

Among all these ways to calculate the summation in Excel, the fastest way as I think is to use shortcuts. With it, you can even sum multiple columns or rows in seconds. The only thing you need do is selecting the values to sum, and press Ctrl+= on the keyboard.

For example, if you want to sum the values from B2 to B5, just select these cells and press Ctrl+=.

The Quickest Way to Sum columns or rows in Excel Spreadsheet

The summation will be worked out and show in the cell next to selected cells. In my case, it’s displayed in B6.

The Quickest Way to Sum columns or rows in Excel Spreadsheet

You can sum all the columns in the table as well – just select all the columns you want to sum and press Ctrl+=.

The Quickest Way to Sum columns or rows in Excel Spreadsheet
Sum columns

If you want to sum all the rows, try selecting one more column beside the selected cells before pressing Ctrl+=.

The Quickest Way to Sum columns or rows in Excel Spreadsheet
Sum rows

Similarly, you can select one more column and one more row beside the selected range of cells to calculation the summation of both rows and columns.

The Quickest Way to Sum columns or rows in Excel Spreadsheet
Sum columns and rows
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *