# How to AutoSum Horizontally in Excel (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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)`

### 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)`

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.

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

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF