Displaying Both Formulas and Values for Cells in Excel

To display both formulas and values for cells:
1. From the Window menu, select New Window.
2. From the Window menu, select Arrange.
3. Select the Horizontal option button and click OK.
4. Select one of the two windows and press <Ctrl+‘> (the key to the left
of the number 1).

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