Displaying Both Formulas and Values for Cells

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>.

F1 - Get The Most Out Of Excel Formulas and Functions0029

No comments:

Post a Comment

Related Posts