How to insert and edit mathematical formula editor in Excel and enter the formula

Key points of this article

Calculation formulas (such as =SUM) are used for calculations, and the formula editor is used for typesetting. The two cannot replace each other.
Before inserting into the formula editor, confirm the version of the office software and look for the option with the word "formula" in the insertion related menu.
The formatting formula is an independent object in the table, and the value will not change with the cell. To change the data, you need to manually change the formula.
For documents that require a large number of formatting formulas, you can use a document editor that supports formulas and check them one by one after completion.

Many people need to write a mathematical formula like x² + y² = r² or √(a/b) when doing experiment records, performance statistics or financial tables in Excel. At this time, if you type characters directly in the cell, the superscripts and fraction lines will not be aligned, and the printout will be ugly. So everyone will search for "excel insert formula editor" and "excel input mathematical formula", hoping to find an edit box that can be typed like a textbook.

This article is written for readers who need to put mathematical formulas in tables but cannot tell the difference between them and ordinary calculation formulas. After reading, you will be able to find the formula editing entrance in the office software, know how to enter fractions, superscripts and subscripts, and root signs. You will also know what restrictions there are on arranged formulas in tables, and when you should use another tool.

The operations in this article take the common desktop version of Excel as an example. The menu positions and names of different versions are slightly different. If you encounter any discrepancies, just follow the judgment method in this article to find them.

When writing formulas in Excel, how do you choose: for calculation or for typesetting? One sentence conclusion

Let’s start with the conclusion: to make the table count, use calculation formulas; to make the equations look good and type them like print, use a formula editor. The two have different uses, so don't mix them.

your situation	Recommended practices	reason
Need to automatically sum and average based on cell data	Write the calculation formula in the cell, starting with an equal sign	The results will change with the data, suitable for statistics and accounting
A standard mathematical expression needs to be displayed next to the table	Insert the formula editor and enter the typesetting formula	Fractions, superscripts and subscripts, and radicals can be displayed correctly
The formulas are only used for explanation and do not participate in calculations.	Use the formula editor to typeset and place it in the description area.	Avoid mistakenly thinking that it will participate in the operation
The entire document contains a large number of formulas and needs to be typed in a unified manner	Use a document editor that supports formulas instead	Formulas are easier to maintain and export together with the text
Just want to write a simple square in the cell	Use superscript format or calculation formula (such as =A1^2)	Don't have to open an edit box for a small symbol

Before you start: Confirm these points first

1. Confirm which formula you need. If you want to calculate data, you should write a calculation formula starting with an equal sign; if you just want to display a mathematical formula, you only need a formula editor. If you choose the wrong type, you will have to rework it again and again.

2. Confirm the office software version. Older or leaner versions may not have formula-related options in the Insert menu. If you encounter a situation where it cannot be found, check the version information first, and then determine whether you need to upgrade or handle it in another way.

3. Think about where to put the formula. The typesetting formula is a floating object in Excel and can be moved, but it will not automatically adjust its position with the rows and columns like cells. If rows and columns will be added or deleted after the table, it is recommended to place the formulas in a fixed description area to avoid layout misalignment.

4. Confirm whether it needs to be sent to others. If the file is to be edited or printed by others, you should make sure that the other party's software can open it normally and that the formulas are displayed correctly. Formulas involving examinations, papers or formal reports should be checked against the original manuscript one by one before sending.

5. Prepare the original formula. First write the formula to be entered clearly on paper or in a draft, including brackets, superscripts and subscripts, and fraction levels. When typing while writing, it is easy to miss parentheses, resulting in structural errors.

Steps to Insert the Formula Editor and Enter Mathematical Formulas in Excel

First, determine the placement location. Select a blank cell in the table, or select the blank area next to the formula, so that the formula object has a clear placement point.
Open the insert related menu. Look for options labeled "Formula" or "Formula" in the insertion area of office software. Different versions have different names. After finding and clicking, a formula input box will appear.
Choose the template you need. The formula box generally provides structures such as rational expressions, radicals, superscripts and superscripts, sums, and parentheses. Choose the structure first, then fill in numbers and letters in the blank spaces, which is less likely to be wrong than typing symbols directly.
Enter expressions segment by paragraph. Enter from left to right according to the draft; place the numerator, denominator, index, and index in the corresponding boxes. If you find an incorrect structure during input, use the arrow keys to move the cursor, delete the incorrect template, and select again.
Exiting editing mode. After completion, click the table area outside the formula box with your mouse to exit editing. If you want to modify it, double-click the formula object to re-enter.
Adjust position and size. Drag the border of the formula object to place it in the appropriate position. If the font size differs too much from the table text, you can adjust it uniformly in editing mode to keep the layout coordinated.
Save and review files. After saving as an Excel file, close it and reopen it to confirm that the formula object still exists and its position is not shifted.
Export another check when sharing is needed. If you want to send it to others, you can first open it on another device or a different version to confirm the formula displays consistently.

After completion, check each item one by one

After arranging the formulas in the table, don't submit them directly; first check each item in the table below.

Inspection items	How to see it	What should you do if there's a problem?
Whether the structure is correct	Compare the draft to see if the score line, subscripts, and parentheses correspond one-to-one	Enter editing mode, delete the incorrect template, and re-enter as a draft
Check if any symbols are missing	Check the Greek letters, operators, and minus sign one by one	Add missing symbols to the template; If you can't find it, replace it with a general text description and add a comment
Whether the position is shifted	After scrolling the table and adjusting column widths, check if the formula remains in its original position	Dragging the Turn into the Right Position; If necessary, place the formula in a fixed area and add an explanatory text
Whether data is linked	Modify the numbers in the relevant cells to see if the formula results have changed	Layout formulas do not interact. If you need to calculate, write a separate formula and place it in the cell
Check if opening is normal	Open the file on another computer or a different version	If the display is abnormal, export as an image and put it in a table, or provide a separate formula in document form

🎯 Which method suits you?

Only put one or two formulas in one table. You can directly use the formula object built into Excel; the operation is simple, and after saving, it follows the file.
The table needs frequent calculations and includes explanatory formulas. The calculation section uses calculation formulas, while the explanation section uses formatting formulas, separated in different cells or areas.
Write a lot of math content and format it together with the main text. In this case, it is better to use a document editor that supports formulas. OmniDoc's UniDoc web editor (app.unidoc.top) supports formulas and can be used to write documents containing formulas; The desktop client (download.omnidoc.top) also includes a document editor and table tools, which can be selected as needed.
Only formulas are needed, no editing is required. You can first arrange it in the document editor and then add it to the table as a screenshot. This method is suitable for post-final display, but later formula modifications require retaking screenshots.

❓ Frequently Asked Questions (FAQ)

1. How to use the Excel formula editor online?

Excel itself is a desktop software, and its formula editor needs to be opened in the installed program. If you need to edit formulas directly in your browser, you can use online document editors, such as the UniDoc web editor, which supports formulas and is suitable for online document writing.

2. How do you bring up the Excel formula editor?

First, confirm the software version, then look for options labeled "formula" or "equation" in the relevant insert menu. If you can't find it, it's usually an older version or the relevant features aren't installed. Upgrading the software or checking if the features are disabled usually solves the problem.

3. Why isn't the expression after entering the equals sign the effect I want?

Formulas starting with an equal sign are calculated by Excel based on cell data, resulting in numbers. If you just want the formula to look good and layout like print, you should use the formula editor instead of directly entering the calculation formula.

4. Why don't the formulas that are laid out automatically change with the data?

The formula editor generates layout objects; it only displays the form and does not participate in calculations. If automatic calculation is needed, write a separate formula in the cell and use the two separately.

5. What should I do if the formula in the table shows a misalignment after sending it to someone else?

This is usually because the other person's software version or font is different from yours. Before sending, you can open the inspection on another device; If there are still issues, it is recommended to export the formula as an image and put it in the table, or provide a separate formula document.

📝 Summary

When inserting mathematical formulas into the Formula Editor in Excel, the key is to distinguish between calculation formulas and layout formulas, then find the insertion entry point and enter them paragraph by paragraph using a template. After arranging, check the structure, position, and opening effect. If you need to format a large number of formulas, consider using a document editor that supports formulas.

Open OmniDoc and process your table file