How to use Autosum in Excel?
Do you have questions regarding Autosum formula in Excel? Do not worry! This tutorial will explain you in detail regarding Autosum formula in Excel
- What is Autosum?
- What are the uses of Autosum?
- Where do you find Autosum in excel?
- What if Autosum stops working?
- How to use Autosum with other options?
👉 What is Autosum in Excel?
AutoSum is the most powerful feature in Microsoft Excel. It helps to carry out the task at a great speed. When you want to total a particular row or column you use this function. AutoSum helps to total up various rows and columns in the spreadsheet.
Without inserting a formula in the formula bar you can directly total the row or the column by just clicking on AutoSum. For example, if you want to total the values from cell A1 to cell A7 then you just need to select it and click on AutoSum. This feature does not require to remember the formula.
👉 Where is Autosum button in Excel?
- You can find AutoSum button at two places in the ribbon.
- The first place is in the home tab.
- The second place is in the formula tab.
- You can also use the AutoSum shortcut from the keyboard by using the Alt + =
👉 How to use Autosum in Excel?
When we want to add a single cell or wide range of cells you use this feature to add in excel.
- When we want to add a column of cells, we use the following steps:
Step 1: Select the cell under the columns you want to add. You can simply click on a particular cell or you can drag your mouse to select the cell you want to add.
Step 2: Then click on Autosum in the Home tab or Excel formula tab. (You can use Excel Shortcut keys ALT + =)
- When we want to add the lines of a cell, we use the following steps:
Step 1: Select the cell next to the row that you want to add. You can simply click on a particular cell or you can drag your mouse to select the cell you want to add.
Step 2: Then click on the autos in the Home tab or in Excel’s Formula tab. (You can use Excel Shortcut keys ALT + =)
- When you want to add multiple columns, we use the following steps:
Step 1: Suppose we want to add columns from B to column F. You have to select the column by pressing the arrow buttons to drag the mouse through the cell or pressing shift continuously and selecting the cell.
Step 2: After selecting the cell you click on the Autosum button This will help you total all the columns together.
- When you want to add multiple rows, we use the following steps:
Step 1: Suppose we want to total the rows in a spreadsheet. You choose a special cell whether you want the total and the row.
Step 2: Click on Autosom and it will appear on the right side of the row’s total worksheet.
- When we want to add multiple lines and columns at the same time:
Step 1: Select the rows and columns you want to add. You can click by dragging your mouse or using the keyboard button shift and arrow.
Step 2: Click Autosum in the ribbon. The column will appear below the total column and will appear on the right side of the total sheet of a line.
We should keep in mind that Autosum in Excel will appear to the right or bottom of the spreadsheet. It will never appear at the top or left of the spreadsheet. When you use Autosum in Excel, you also have to see that there is no empty column or row.
Autosum in Excel will stop if empty cell is there. But when you select the cell manually and if that selection includes an empty cell it will be ignored.
👉 How to use Autosum with other functions?
In addition to adding cells, Autosum in Excel also does other functions.
Average: This feature helps in bringing the average of the selected cell. We can obtain arithmetic mean for the selected cell by selecting the column.
Count: This feature lets you calculate the number of cells you have selected.
Maximum: This feature helps you find the maximum value in the select ed cells.
Minimum: This feature helps you find the minimum values in the selected cells.
Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.
Learn 100+ Excel Tips & Tricks