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
- Relative ReferenceWhen a formula is copied, a Relative reference is used. A Relative refe
- To paste the calculated value of a single formula into a cell (thus overwriting the form
- Understanding ArraysFor those who do not have a background in programming or mathematics,
- To copy/paste Formulas from a range of cells without changing the Absolute or Relative re
- To display the syntax of all formulas in a sheet:Press <Ctrl+‘> (the ‘ symbol is lo
- Inserting/Editing FormulasTo open the Insert Function dialog box:Select an empty cell and
Langganan:
Posting Komentar (Atom)
EmoticonEmoticon