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>.
Selasa, 04 Oktober 2011
Displaying Both Formulas and Values for Cells in Excel
Topic
Learning ExcelRelated
- Understanding ArraysFor those who do not have a background in programming or mathematics,
- Avoid the nightmare of pressing <F4> multiple times when coping and pasting formula
- Inserting/Editing FormulasTo open the Insert Function dialog box:Select an empty cell and
- To add a Comment to a formula:1. At the end of the formula, add a + (plus) sign.2. Type t
- Selecting Cells That Contain Formulas in Excel :To select cells containing Formulas in or
- Relative ReferenceWhen a formula is copied, a Relative reference is used. A Relative refe
Langganan:
Posting Komentar (Atom)
EmoticonEmoticon