How to quickly add negative sign in excel?

How to quickly add a negative sign in excel:

1. Create a new workbook

2. Copy the data into the new workbook

3. Enter "-1" in any table on the side

4. Then copy this cell (that is, copy -1), select the cell where -1 is located, right-click the mouse to display the shortcut menu, click copy, or you can select the cell and press Ctrl C to proceed. copy.

5. Select the data cells that need to be modified. If there is a lot of data, you can directly click on the letters above the list to select the entire column; if there is little data, you can directly use the mouse. Drag to select. After selecting, right-click and select "Paste Special" in the shortcut menu.

#6. In the pop-up dialog box, select "Multiply" in "Operation" and click OK.

Recommended: "excel tutorial"

The above is the detailed content of How to quickly add negative sign in excel?. For more information, please follow other related articles on the PHP Chinese website!