MICROSOFT EXCEL TIP: How To Quickly Sum A Range Of Cells In Excel

This is very useful tip to quickly sum a range of cells in Excel (in just seconds) using two keyboard keys: Alt and =.

If you have a table like the one below, and you want to sum all the numbers very quickly:

sum range in Microsoft Excel

Step 1: Simply select the entire table plus the blank cells where you want to place your total values:

sum data in Microsoft Excel

Step 2: Press Alt =

sum data inn Microsoft Excel

Notice that Excel automatically sum the values in each row and column with the SUM formula.

Now, you try it. Post or email me your questions. 

1 comment:

  1. Betway Casino Bonus Code is MAXBONUS | ᐈ 30 Free Spins
    Casino Review, 바카라 Bonuses, FAQ & More! New players welcome bonus $10 no deposit aprcasino bonus + kadangpintar 100% up to $1000 in Betway Casino Bonuses!


Powered by Blogger.