Worksheet cells display the results of formula calculations. To see the underlying formula, you click on the cell and the formula is displayed in the formula bar. There are times when you might need to see more than one formula at a time. You can change the worksheet view to display the formulas directly in the cell by pressing the CTRL + ` (accent) keys together. The accent key is located directly above the tab key on the left side of your keyboard.
This keystroke combination is a toggle and you can use it to toggle between the formula view and the results view.
You can also set the formula view by selecting or deselecting the Formula option on the view page of the Options dialog box.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment