In this Autosum example, let's say you want to add up both the columns and the rows in this data table. We start by selecting the cells in the rows we want to add up:Īfter we click the Autosum button, the results look like this:Īutosum example four - add up rows and columns of data at the same time This example is similar to example two, except it adds up data in multiple rows rather than multiple columns. In this case, clicking the Autosum button will automatically generate the formulas for each column (B to F) and enter the results immediately, as shown here:Īutosum example three - add up the cells in a row of data I've selected the cells where I want my automatically generated formulas to go: Here's the data we'll use for this example.
#Excel keyboard shortcut autosum how to
The next Autosum example shows you how to use Autosum to add up multiple columns at once. select B2:B7 in the example above).Īutosum example two - add up the cells in multiple columns of data at once If you don't want the empty cell, then you can change the range you select before pressing the Autosum button (i.e. This can be useful later if you need to add extra rows of data to your table since it will mean you won't need to change your formula. The formula includes all of the cells in the column from the first cell that contained a number through the cell immediately above the cell where the formula is being created. If you are happy with the formula Excel has created for you, you can press Enter to complete the process (note that you won't get this option if you used the keyboard shortcut).Īt this point it is worth noting that the SUM formula created by Autosum includes the empty cell in B7. It will then wait for you to press Enter (or Escape if the formula is incorrect): ( Tip: You can also press ALT+ = (on Windows) or Option+ Command+ = (on Mac) as an alternative to clicking the Autosum button on the toolbar)Įxcel will automatically find the range of data in the column above where you clicked, and will create a SUM formula that will add up those cells. Next, click the Autosum button, which looks like this: Here is an example of how use Autosum to add up the cells from B2:B6.Ĭlick in a cell in the column below the range you want to add up (or to the right of the range if your data is in a row rather than a column). Autosum example one - add up the cells in a column of data With Autosum, Excel will automatically add up a range of cells for you, and place the result in a nearby cell.Īutosum has been around a long time, and will work in all recent versions of Excel, including Excel Online (part ot the Office365 Suite) and versions on the Mac.
It is often faster than creating a formula by hand, especially when you have a large amount of data to add up. Autosum is a powerful feature that can save you time if you need to add up cells or columns of data quickly. This lesson explains how to use Autosum in Microsoft Excel.
0 kommentar(er)
