When we use excel in our daily office, we sometimes need to enter some vertical scores for operations, but if we enter the scores directly, we will find that the scores are displayed in the form of left and right, so how to enter the vertical scores of the upper and lower structures in excel? Next, I will share with you how to do it. #excel#
Methodological steps
Method 1: Formula
1. Open Excel** and click[Insert] - [Formula].to insert a formula edit box in **.
2. Click[Formula] - [Fraction] - [Fraction (Vertical)].to insert a blank vertical fraction in the formula edit box.
3. Click the numerator and denominator of the vertical fraction in the edit box of the selected formula, enter the corresponding number, and thenClick the left mouse button in an empty space to exit the formula editing state, so that the vertical fraction is entered.
4. If you need to enter a score with a fraction, such as "2 and 2/3", then click the formula to enter the editing statePosition the cursor in front of the score line, and then enter the integer part 2 to get the fraction with the band.
Method 2: Ink formula
1. In the Excel that opens, click[Insert] - [Formula] - [Ink Formula].to pop up the Math Input Control dialog box.
2. In the "Math Input Control" dialog box, hold down the left mouse button to write the vertical fraction (similar to handwriting) that needs to be entered in the input box, and click [Insert] after the input is completed, so that a vertical fraction is inserted in **.
Note: If some lower versions of Excel do not have the "Ink Formula" handwriting function, you can use Method 1 Ordinary Formula.