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.
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.
- 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.
- Then, press the ENTER button to have the total expense value.
- Use Fill Handle to AutoFill the rest of the cells in column H.
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.
- 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.
- 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.
Read More: How to Sum Rows in Excel (9 Easy Methods)
- 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)
🖋️ 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)
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.