When creating Microsoft Excel worksheets formula results are shown in the worksheet NOT the formula. There may be times when it would be helpful if you could SEE the formula in the worksheet.
To display formulas in Excel 2007:
- Click the Office button
- Click the Excel Options button
- In the Excel Options dialog box, click Advanced
- Scroll down to the Display options for this worksheet section
- Click to select the option Show formulas in cells instead of their calculated values
To resume seeing the results of the formula, just repeat the above steps. Or you can use the shortcut keys for toggling formula viewing on and off: Ctrl+` (accent key below the tilde ~). This shortcut works in earlier versions of Excel as well.
Microsoft Excel 2007 Online Tutorials
If you’re trying to learn Microsoft Excel 2007 there are excellent online resources available. I recommend checking these out:
Microsoft Office Online offers several Excel 2007 Courses
| |
Worksheet Selection in Excel
If you have several worksheets in an Excel workbook, it can be time consuming to select the one you want to view. This shortcut can help you speed up the process.
Right click on the sheet tab navigation arrows
|
A menu of worksheet tabs pops up
| |
Left click the worksheet you want to view
|