How to Use SUM Formula Shortcut in Excel (2 Simple 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 any range of cells. As this function is one of the most frequent, it’s convenient for all of us to use shortcuts instead of typing the SUM function and selecting a range. In this article, I will explain 2 smart ways to use SUM Formula Shortcut in Excel. I hope it will be very helpful for you if you are looking for an efficient way to do so.

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

Download this practice workbook to exercise while you are reading this article.


2 Simple Ways to Use SUM Formula Shortcut in Excel

In order to explain the Excel SUM formula shortcut, I am going to use a yearly expenditure list of a few families. I have arranged the information in the Name, Housing, Food, Transport, Health, Clothing, and Expenditure columns. I want to add the total expense along with the year in the Expenditure column. So, I have to apply the SUM function along the row. Let’s dive into detail.

Excel Sum Formula Shortcut


1. Use Keyboard Shortcut

A keyboard shortcut is most often the fastest way for any command. In order to apply the Excel SUM formula shortcut, we can use a keyboard shortcut too. The process is discussed in detail in the following section.

Steps:

  • Select a cell in the Expenditure column.
  • Next, click on  CTRL + =  (the CTRL button and Equal at once). We will have the SUM function along with the related cells in the row.

Use Keyboard Shortcut to SUM Formula

  • Then, press the ENTER button to have the total expense value.

Excel Sum Formula Shortcut

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


2. Apply AutoSum Feature to SUM Formula Shortcut

There is already a built-in feature as an Excel SUM formula shortcut. That is named as AutoSum. Follow the following steps to apply the SUM formula shortcut.

Steps:

  • First of all, select a cell in the Expenditure column (i.e. H5).
  • Next, go to the Home tab.
  • Then, click on AutoSum from the ribbon.

Apply AutoSum Feature to SUM Formula

  • As soon as we click on the AutoSum option, we will have the SUM function along with the related cells in the row.

  • Now, hit the ENTER button to have the output.

  • You can use Fill Handle to AutoFill the rest cells in column H.

Excel Sum Formula Shortcut

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


Similar Readings


Notes

🖋️ You can apply the above procedures as the Excel SUM formula shortcut along with the column.

🖋️ In terms of applying the shortcut in a certain range, you just need to define the range manually after applying the Keyboard Shortcut or AutoSum.

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


Conclusion

At the end of this article, I like to add that I have tried to explain 2 simple ways on the topic of how to use SUM Formula Shortcut in Excel. It will be a great pleasure for me if this article helps any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.


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