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
- Avoid the nightmare of pressing <F4> multiple times when coping and pasting formula
- A formula can be copied and pasted into the appropriate place within another formula in t
- To add a Comment to a formula:1. At the end of the formula, add a + (plus) sign.2. Type t
- Inserting/Editing FormulasTo open the Insert Function dialog box:Select an empty cell and
- Range Name SyntaxName syntax rules:The Name string must begin with a text character, not
- Selecting Cells That Contain Formulas in Excel :To select cells containing Formulas in or
Langganan:
Posting Komentar (Atom)
EmoticonEmoticon