How do Excel tables convert negative numbers into positive numbers?

How do Excel tables convert negative numbers into positive numbers?

The Excel table changes the entire column or the entire row negative number to a positive number, such as 22 to 22, and this example takes excel2010 as an example. Other versions are similar.

1, open the Excel table, such as the right image, a column is all negative. As shown in figure

2. Enter a number in any space-1, as shown

3, check-1 This cell, right----copy, as shown

4, then select all the negative numbers you need to change, right----selective pasting---selective pasting (note 2010 version is level two menu), as shown

5, into the Selective Paste menu interface, select (multiply), click OK, as shown

6, all negative numbers immediately become positive, as shown in figure