Tip Printed from ExcelTip.com

---

Displaying Formulas and Values of the Same Cells


To display formulas and values of the same 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.