How to display formula content in Excel

Dear readers, have you ever encountered the problem that only calculation results can be displayed in Excel tables, but the content of formulas cannot be viewed? PHP editor Youzi hereby provides a detailed guide to help you solve this problem step by step.

Open the Excel table and just use the shortcut CTLR [~] key, which is the key next to the numeric key 1, to display the formulas in all cells.

Similarly press the shortcut key again to restore the original number form. Isn't it very simple? You can also click on the [Formula] column above and select [Show Formula] there.

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