How to cancel the plus/minus sign next to an excel table

Reported answer
How to cancel the plus/minus sign next to an excel table
Ask online customer service
Scan the code to ask online customer service
  • Number of answers

    four

  • Number of browses

    6,658

4 answers Default sorting
  • Default sorting
  • Sort by time

Didn't find a satisfactory answer? Go ask Doubao AI intelligent assistant
Select the row or column to cancel, and then select Data - Hierarchical Display - Ungroup
cancel comment
1 Open Excel, double click the cell where you want to enter the symbol, mark the positive and negative, and you can see the symbol in the candidate item. Click the symbol
2 As shown in the figure, the input has been completed.
The addition and subtraction of Excel tables can be realized by functions.
1. Create a new Excel document, enter a number in an Excel cell, double-click the cell to add or subtract, and enter an equal sign:
2. Click the cell to be involved in the calculation with the mouse, and the cell to be clicked will be selected by the dotted line. The location of the cell will be displayed after the equal sign:
3. Enter the plus minus operator, then click the cell to be involved in the operation, and repeat the operation until all the cells to be involved in the operation are added to the function:
4. Press the Enter key on the keyboard, and the function will calculate and display the final result
1、 Use symbol mode
1 Open the document and click Insert.
2 Click the symbol.
3 Select normal text in the font drop-down box.
4 Find the plus or minus sign, click Select, and click the Insert button below.
5 The addition and subtraction symbols were successfully printed.
2、 Use the symbol function input by the system to print
1 Click the wrench icon of the input method.
2 Click the symbol.
3 Click Math/Units.
4 Find the plus and minus signs and click Insert.
3、 Output using character encoding
1 Press the keyboard alt key.
2 Press the number keys on the right of the keyboard and press 177.
3 The plus minus sign is output successfully.
The lower one is input directly, and the upper one is input by pressing the upshift key.
After entering the plus sign, press Enter to move the cursor to the next line, and then enter the minus sign
cancel comment
Just add in the car
cancel comment
In Excel, if you want to cancel the plus or minus sign (used to display the automatic increase or decrease before and after the decimal point) in the cell corners, you need to adjust the number format. Click a cell, and then select the right-click menu ->Set Cell Format. Under the Number tab, find the decimal places and set the corresponding precision to 0 or not to display. Remember to apply or save changes
cancel comment
ZOL Q&A > How to cancel the plus/minus sign next to an excel table

Top mobile phones

See more rankings>

report

Thank you for contributing to the harmony of the community. Please select the type of report

Reported successfully

It will be handled after verification
Thank you for your contribution to community harmony

Scan the code to participate in the trial of new products at 0 yuan
You can get the sheets and grand gifts on the top floor

 Scan and pay attention to us
Tips

Are you sure you want to cancel this registration and exit this activity?