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
- To add a Comment to a formula:1. At the end of the formula, add a + (plus) sign.2. Type t
- Avoid the nightmare of pressing <F4> multiple times when coping and pasting formula
- Selecting Cells That Contain Formulas in Excel :To select cells containing Formulas in or
- To paste the calculated value of a single formula into a cell (thus overwriting the form
- Range Name SyntaxName syntax rules:The Name string must begin with a text character, not
- To display the syntax of all formulas in a sheet:Press <Ctrl+‘> (the ‘ symbol is lo
Langganan:
Posting Komentar (Atom)
EmoticonEmoticon