Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to insert equations in WPS Spreadsheet
Uploaded time: July 18, 2022 Difficulty Beginner
How to insert equations in WPS Spreadsheet
How to insert equations in WPS Spreadsheet
You will be the amazing reporter with WPS Spreadsheet, which could be an alternative to Microsoft Excel.Mathematical equations contain a variety of number formats like symbols, scores, root numbers, and so on. It is difficult for us to enter these equations with the input method. However, with the Equation function in WPS Spreadsheet, inserting mathematical equations will no longer be a problem.
Click the Insert tab at the top of the screen, then click the Equation button. Here, WPS Office presets a variety of commonly-used mathematical equations for us, which can be quickly added by clicking.
If you can't find what you want in the drop-down menu at Equation, click Insert New Equation” to customize your new equation.
In the Equation Tools tab, we can quickly insert various basic mathematical symbols.Skillfully using Basic Math, we can also choose various symbol classifications, such as Operator, Arrows, and so on.
On the right side of the tab menu, we can choose many different number formats, such as Fraction, Subscripts and Superscripts, Radical, Function, etc.
Most mathematical equations can be entered skillfully using the two small functions we mentioned.
In addition, we can also use the Equation Editor to edit equations.
Click the Insert tab.Then click the drop-down button of Equation.
Finally, click Equation Editor to open it.
In the pop-up Equation Editor edit box, enter the formula and click Close, The formula will be inserted into the slide as a picture.
Double-click the equation to pop up the Equation Editor again if you want to re-edit.
What a practical feature! Did you get it?
Does this video help you?