|  

» Displaying Formulas and Values of the Same Cells in Excel 2007

To display formulas and values of the same cells:

1. Select View -> New Window (in Window Group).
2. Select Arrange -> Horizontal.
3. Select a cell and Select Formulas -> Show Formulas (in Formula Auditing Group).

To move between windows, press Ctrl+Tab or Ctrl+F6.


Rate This Tip
12 34 5
Rating:     Views: 2667
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments