Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Excel helps us perform our work faster with many of its incredible features. The AutoSum feature is one of them. We can easily use AutoSum to calculate horizontally in Excel. In this article, I will show you 4 easy methods on how to AutoSum in Excel horizontally.
How to AutoSum Horizontally in Excel: 4 Easy Methods
This is the dataset for today’s article. There are some salespersons with the amount of sales for the 1st quarter of 2022. I will use the AutoSum feature to calculate the total sales.
1. Use Home Tab to AutoSum Horizontally in Excel
You can use the AutoSum feature in the Home tab. To perform AutoSum, follow these steps.
Steps:
- First, select F5.
- Then, go to the Home
- After that, select AutoSum.
- You will see that Excel will enter the following formula in F5.
=SUM(C5:E5)
- Then, press ENTER. Excel will return the output.
- Finally, use the Fill Handle to AutoFill up to F11.
2. Apply AutoSum Feature from Formula Tab in Excel
Now, you will also find the AutoSum feature in the Formula tab. You can also use the feature from that tab.
Steps:
- First, select F5.
- Then, go to the Formula
- After that, select AutoSum.
- You will see that Excel will enter the following formula in F5.
=SUM(C5:E5)
- The rest is similar to method-1.
3. Use Keyboard Shortcut to AutoSum Horizontally in Excel
Now, I will show a keyboard shortcut to AutoSum Horizontally in Excel.
Steps:
- Select F5.
- Then, press ALT+=. You will see that Excel will enter the following formula in F5.
=SUM(C5:E5)
- The rest is similar to method-1.
Read More: How to Autosum Column in Excel
4. Perform AutoSum to All Cells at Once.
In this section, I will show how to perform AutoSum to a selected range. The advantage of this method is that you do not need to AutoFill cells in this method.
Steps:
- Select the range F5:F11.
- Then, press the keyboard shortcut ALT+=. You can use the other 2 methods too.
- Excel will calculate the summation of all the rows horizontally.
Things to Remember
- Under the AutoSum feature, you have many other options like average, minimum, maximum, etc.
Download Practice Workbook
Download this workbook and practice while going through the article.
Conclusion
In this article, I have explained 4 methods on how to AutoSum in Excel horizontally. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.
