EXCEL 同時顯示某一單元格的公式及結(jié)果

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.(選擇一個窗口, 按Ctrl+`)
To move between windows, press Ctrl+Tab or Ctrl+F6.(按CTRL+TAB或ctrl+F6在窗口之間切換)