Sum Formula Shortcuts in Excel (3 Quick Ways)

The SUM function is one of the basic and most frequent functions available in Excel. We use this function to add up values within a row or a column or a range of cells. As this function is one of the most frequent ones, it’s convenient for all of us to use shortcuts instead of typing the SUM function and then selecting a range. In this blog post, you are going to learn shortcuts for the sum formula to add up values in Excel.

You are recommended to read How to Use SUM Function in Excel beforehand. This might assist you better understanding this article.

Download the Practice Workbook

In this practice workbook, you will find 5 sheets in total. The first two sheets containing a dataset of Product Price Lists with Product and Price columns can be used, to sum up, a column. The next three sheets containing a dataset of Monthly Expense Calculation can be used, to sum up, rows. You can download this practice workbook and practice the methods along with it.

3 Ways to Shortcut the Sum Formula in Excel

Now we are going to discuss 5 different ways that shortcut the sum formula in Excel. Let’s learn them all one by one.

1. Sum Up a Column

In this section, we are going to learn how to shortcut the sum formula within a column using a keyboard shortcut as well as the AutoSum command.

A. Using Keyboard Shortcut

The fastest way to shortcut the sum formula is to use a keyboard shortcut. Let’s see how we can really do it:

Step-1: Select cell C13.

Step-2: Hold the ALT key and type “=”.

Step-3: Press the ENTER key.

excel sum formula using keyboard shortcut

B. Using AutoSum

AutoSum command can also be used to shortcut the sum formula. You will easily find this command under the Home ribbon. Here’s the step by step procedure to do it:

Step-1: Select cell C13.

Step-2: Go to the Home ribbon and Select the AutoSum command.

Step-3: Press the ENTER key.

sum up a column using autosum

Read More: Shortcut for Sum in Excel (2 Quick Tricks)


2. Sum Up a Row

In this section, you are going to learn how to sum up a row in a quick way. You can use the following two methods to do so.

A. Using Keyboard Shortcut

This is just the same as what we actually did while adding up a column using a keyboard shortcut. Anyways, let’s repeat the whole process, to sum up, a row.

Step-1:  Select cell H5.

Step-2:  Hold the ALT key and type “=”.

Step-3: Press the ENTER key.

sum up a column using keyboard shortcut

B. Using AutoSum

You can follow the same procedure that you did while summing up a column using the AutoSum command in case of adding up values in a row. Here’s how to do it stepwise:

Step-1: Select cell C13.

Step-2: Go to the Home ribbon and select the AutoSum command.

Step-3: Press the ENTER button.

sum up a row using autosum command

Read More: How to Sum Rows in Excel (9 Easy Methods)


Similar Readings


3. Sum Up a Specific Range

This is not an actual shortcut. You have to tweak the formula a bit to sum it to a range. Here’s the stepwise instruction for you to follow:

Step-1: Select cell D13.

Step-2: Hold the ALT key and type “=”.

Step-3: Edit the range from B5:H12 to D6:E7.

Step-4: Hit the ENTER button.

sum up a specific range using keyboard shortcut

Read More: How to Sum Range of Cells in Row Using Excel VBA (6 Easy Methods)


Things to Remember

  • Type ‘=” while holding the ALT button.
  • Tweak the range to sum up a range of cells.

Conclusion

So, now you have learned all the 5 ways to shortcut the sum formula in Excel. All of them are suitable to handle different scenarios. You are recommended to practice all of them along with the given workbook because that might help you to work swiftly and smoothly in your actual workplace.


Related Articles

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo