Excel Hack

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 a cell for calculating absolute values.

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

Select ABS function

Press Alt + M + G to open Math & Trig; make sure ABS is selected.

Enter the cell number

Enter cell numbers

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

Absolute value calculation completed

Press Enter. Absolute value have been calculated and reflected in the selected a cell.