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.

#### 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.

**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.

#### 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.

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

**Similar Readings**

**How to Sum Colored Cells in Excel (4 Ways)****How to Sum Colored Cells in Excel Without VBA (7 Ways)****Sum If a Cell Contains Text in Excel (6 Suitable Formulas)****SUM Ignore N/A in Excel( 7 Easiest Ways)****Excel Sum If a Cell Contains Criteria (5 Examples)**

### 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.

**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.