Absolute value in Excel shortcut
Absolute value is a value that represents the distance from the origin 0. For example, the absolute value of +3 is 3, but the absolute value of -3 is also 3. To find absolute value, you need to use the ABS function, but here we will learn how to use shortcuts to calculate absolute value instead of entering them manually. Note that some people confuse absolute value with absolute references, but they are not the same thing.
Shortcut to calculate absolute value
Access Key: Alt + M + G
Calculate absolute value using shortcut
For information on how to use shortcuts to calculate absolute value, see below.
Total Time: 1 minute
Select a cell
Select the cell where you want the result of the absolute value calculation to be displayed. Remember the cell number (ex E2) that is the target of the absolute value calculation.
Open Math & Trig
Press Alt + M + G to open Math & Trig; make sure ABS is selected.
Enter the cell number
Press Enter to display the Function Arguments dialog box. Enter the cell number that contains the number you want to make absolute (ex E2).
Absolute value calculation completed
Press Enter. Absolute value have been calculated and reflected in the selected a cell.