Home  >  Article  >  Topics  >  How to edit formulas in excel

How to edit formulas in excel

coldplay.xixi
coldplay.xixiOriginal
2020-12-28 11:16:2096965browse

How to edit formulas in Excel: First find the formula selection box in the "Insert" ribbon; then select to enter a formula; and finally copy the formula in the formula selection box to Excel.

How to edit formulas in excel

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to edit formulas in excel:

1. First, find the formula selection box in the "Insert" ribbon.

How to edit formulas in excel

#2. Open the inserted formula selection box and the inserted formula in a certain workbook will appear.

How to edit formulas in excel

3. We can choose to enter a formula in excel, as shown in the figure below,

How to edit formulas in excel

4. We Close the formula window, and then you can see the formula appear in a shaded border in the worksheet.

How to edit formulas in excel

5. We can copy the formula in the formula selection box to excel, and there will be no shadow, as shown in the figure below,

How to edit formulas in excel

Related learning recommendations: excel tutorial

The above is the detailed content of How to edit formulas in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn