Selecting Cells That Contain Formulas in Excel :
To select cells containing Formulas in order to color, delete, or
protect, use the Go To dialog box:
1. Press <F5>.
OR
From the Edit menu, select Go To.
2. In the Go To dialog box, click Special.
3. Select Formulas, and then click OK.
Rabu, 05 Oktober 2011
Selecting Cells That Contain Formulas in Excel
Topic
Learning ExcelRelated
- Relative ReferenceWhen a formula is copied, a Relative reference is used. A Relative refe
- Range Name SyntaxName syntax rules:The Name string must begin with a text character, not
- Inserting/Editing FormulasTo open the Insert Function dialog box:Select an empty cell and
- To copy/paste Formulas from a range of cells without changing the Absolute or Relative re
- A formula can be copied and pasted into the appropriate place within another formula in t
- To display both formulas and values for cells:1. From the Window menu, select New Window.
Langganan:
Posting Komentar (Atom)
EmoticonEmoticon