如何在Excel工作表中检查公式 [英] How to check the formula in an excel sheet

问题描述

我必须在Excel工作表中查看公式，但是它只显示值，而不显示公式.有什么办法吗?

I have to view the formula in an Excel sheet, But it just shows the value but not the formula. Is there any way to do this?

http://www.ga.gov.au/__data/assets/excel_doc/0011/25040/Vincentys-formulae-to-calculate-distance-and-bearing-from-latitude-and-longitude.xls[^]

I want to check the cell which calculates Azimuth.

推荐答案

在Excel 2007中的Formulas Tab 下，有切换按钮Show Formulas显示或隐藏工作表中的公式.键盘快捷键是 CTRL + `，在Excel2003中，它在Tools->Options->View->Formulas 复选框下.
在这里说明
http://blog.contextures.com/archives/2009 /03/23/show-excel-formulas-instead-of-results/ [

In Excel 2007, under Formulas Tab there is toggle button Show Formulas to show or hide formulas in the Worksheet. The key board short cut is CTRL + ` and in Excel2003 it is under Tools->Options->View->Formulas Check box.
It is explained here
http://blog.contextures.com/archives/2009/03/23/show-excel-formulas-instead-of-results/[^]
I think it may be helpful.

您必须首先取消保护工作表的保护，但是当我进入编辑"，转到"，特殊"(仍在Excel 2003中)并选择公式"时，没有.

You have to first unprotect the sheet but then when I went to Edit, Go To, Special (still in Excel 2003) and chose Formulas it said there were none.

这篇关于如何在Excel工作表中检查公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！