Written by Allen Wyatt (last updated January 8, 2022)
This tip applies to Excel 97, 2000, 2002, and 2003
Formulas are at the heart of Excel. In fact, most workbooks contain dozens (if not hundreds) of formulas. Normally, Excel displays the results of your formulas on a worksheet. If a cell contains a formula, you can view the formula by selecting the cell and looking at the Formula Bar. You can also instruct Excel to display the formulas for all cells instead of the results of those formulas. This is done by following these steps:
Figure 1. The View tab of the Options dialog box.
If you prefer, you can use the keyboard shortcut of Ctrl+` to toggle between the formulas and their results. (The ` key is the one just above the Tab key and to the left of the 1 key.)
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2641) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
An easy way to create a name for a formula or constant value. The name can then be used in other formulas or for ...
Discover MoreWhen processing huge amounts of data, it can be a challenge to figure out how to derive the aggregate values you need. ...
Discover MoreDo you need to determine the top three values in a range of columns? The techniques discussed in this tip will come in ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments