Six Methods for entering scores in Excel

Excel is indeed very powerful in terms of mathematical statistics, but it is also unsatisfactory in some details. For example, if you want to enter a score, you may have some knowledge. We will collect six common methods to share with you.

1. Integer + space + score

For example, if you want to enter 1/2, enter 0 (Space) 1/2. If you want to enter 1/3, enter 1 (Space) 1/3.

Advantages and disadvantages of the method: This method is easy to input and can be calculated, but not beautiful enough (because we often use vertical expressions to indicate scores, so the input is not in line with our reading habits ).

2. Input with ANSI code

For example, to enter 1/2, you can press and hold the "Alt" key, then enter "189", and then open the "Alt" Key ("189" should be input with a keypad, the input on the keyboard is invalid ).

Advantages and disadvantages of the method: the input is not convenient enough. It is not easy to know what the ANSI code of each value represents, and the input value cannot be calculated. However, the scores entered by this method are visually displayed, and some uncommon symbols and units can be entered using this method. This input method is used in the help of EXCEL to enter currency symbols.

3. Set the cell format

For example, if you want to enter 1/2, select a cell and use "format/unit format" in the menu. Select "classification" as the score and "denominator as a single digit, enter 0.5 in this cell, and "1/2" is displayed ".

Advantages and disadvantages: Same as the first method.

4. Use Microsoft formula to enter

You can use the menu "insert/object" and find "Microsoft formula 3.0" in the object type. [OK] The Public Editor is displayed (the Public Editor requires custom installation. If no installation is available, you will be prompted to put the installation disc in the office and follow the prompts.) You can enter the score in the same way as using the official editor in word.

Advantages and disadvantages of the method: the input is very beautiful and easy to typeset. It conforms to the regular style of writing fraction, but the input score cannot be calculated.

5. Custom Input Method

For example, to enter 1/2, select a cell, use the "format/cell" menu, select "Custom" in the "Number" category, and then enter: # (Space )?? /2.

Advantages and disadvantages: Same as the first input method. This method can easily convert many existing values into scores of the same denominator.

6. Dual-row Integration

This method uses the bottom border of the table as the shard horizontal bar. in a cell, you can enter the numerator, set the cell to a bottom box, and enter the denominator in the next cell of the same column. In order to be beautiful, we can set other cells to a frameless line, and then set the background fill color to white.

Advantages and disadvantages: the input is convenient and beautiful, but the score cannot be calculated.

After reading these input scores, do you think it is not a simple question? If you are interested, you can try these methods one by one and learn the secrets.