Section 6 - Editing Formulas

By double-clicking on a cell, you can edit the cell's formula directly in the cell without moving the mouse pointer to the formula bar.

OR

You can display the actual formula in the cell (rather than the value) by holding down the Ctrl key and pressing the Grave accent mark (`) located in the top left corner of your keyboard.

OR

In Excel XP, select Options from the Tools menu.

Select Formulas option from the View tab.

In Excel 2007, under the Formulas tab select Formula Auditing, then select Show Formulas.

Excel 2007

In MAC Excel 2004 click on the Excel button on the main menu, then select Preferences. The view tab is selected, then check the Formulas check box under Window options.