## 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

Windows

Access Key: **Alt** + **M** + **G**

Mac

None

### 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.

### Comments

Please send us your comments on this article.