Since Excel allows us to enter data into the sheet differently, we may need to add values accordingly. Different Methods to Use Excel AutoSUM Shortcut It works similar to the SUM keyboard shortcut. Alternately, we can use the AutoSUM shortcut from the Home tab after selecting the desired cells. That is how we can use the AutoSUM keyboard shortcut in Excel to get the quick sum of the desired values in a worksheet.
Upon holding an Alt key, we also need to press the equal (=) sign button on the keyboard. Next, we need to press and hold down the Alt key.Similarly, we can also place the cursor to the outer-left of the row after the data range that we want to sum. First, we must place the cursor below the selected cells of the column that we want to sum.We need to follow the below steps to use the AutoSUM keyboard shortcut in Excel: Steps to Use AutoSUM shortcut in ExcelĪlthough both the shortcuts are convenient, the keyboard shortcut is way better than the other one. Once we click the 'Auto Sum' tool shortcut, the SUM function is applied, and the result is provided just like the previous shortcut. For this, we must press the Alt key followed by H, U, and S, i.e., Alt + H + U +S. We can also access this shortcut using the keyboard. We need to go to the Home tab and select the 'Auto Sum' icon from the Editing group. AutoSUM in Excel using the AutoSUM shortcut under Home TabĪnother shortcut to quickly sum up values in Excel is located on the ribbon. As soon as we press the shortcut key, the sum function is automatically applied, and the result is given for the selected range of data. However, there can be different ways of using this particular keyboard shortcut. We must press both the keys simultaneously to quickly sum up selected rows or columns. The AutoSUM shortcut in Excel involves using the Alt key with the equal (=) key, such as "Alt + =", without the quotes. Let us now discuss each Excel SUM shortcut in detail: AutoSUM in Excel using the Keyboard Shortcut Key We can use any of the following SUM shortcuts in Excel: Similarly, it allows us two different ways or shortcuts to quickly perform the sum of values within our Excel sheet. AutoSUM/ SUM Shortcut in ExcelĮxcel has an extensive range of shortcuts for most of the basic and advanced tasks. They help speed up our work process and save a lot of time while dealing with huge data. Excel SUM shortcuts are usually referred to as AutoSUM shortcuts. This article discusses essential Excel SUM shortcuts that automatically create a SUM formula for a desired or selected range of data and instantly provide the quick sum of data. This function is used more frequently than other functions, and hence Excel provides quick shortcuts to use this particular function. Using the SUM function, we can quickly add or sum up values in an excel sheet. It has a wide range of built-in functions and formulas, and one such function is the SUM. MS Excel or Microsoft Excel is one of the most powerful spreadsheet programs.
0 kommentar(er)
