How to Build Excel 2007 Formulas with the Insert Function Dialog Box
Excel Order of Operations to Keep in Mind
How to Print Formulas in an Excel 2007 Worksheet

How to Display All Formulas in an Excel 2007 Worksheet

In Excel 2007, it can be difficult to view your formulas without accidentally editing them. That’s because anytime you are in “edit” mode and the active cell has a formula, the formula might incorporate the address of any other cell you click. This totally messes things up.

Wouldn’t it be easy if you could just look at all your formulas? There is a way! Follow these steps:

1

Click the Office button and then click the Excel Options button.

The Excel Options dialog box appears.

2

Click the Advanced tab in the left pane.

The Advanced options appear in the right pane.

3

Scroll down to the Display Options for This Worksheet section.

These options appear about two-thirds of the way down.

4

Select the Show Formulas in Cells Instead of Their Calculated Results check box and then click OK.

Excel displays the formulas in the worksheet cells.

To quickly switch between displaying formulas and the formula results in the current worksheet, press Ctrl+` (the accent mark that shares a key with the tilde). This keyboard shortcut works as a toggle.

blog comments powered by Disqus
Controlling Excel 2007 Formula Calculations Manually
How to Build an Array Formula in Excel 2007
Assigning Names to Constant Values in Excel 2007
How to Enter Basic Formulas in Excel 2007
How to Change the Order of Operations in Excel 2007 Formulas
Advertisement

Inside Dummies.com