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
- This posting was contains fundamentals, shortcuts, tips, and techniques that are essentia
- A formula can be copied and pasted into the appropriate place within another formula in t
- 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 add a Comment to a formula:1. At the end of the formula, add a + (plus) sign.2. Type t
- To display both formulas and values for cells:1. From the Window menu, select New Window.
Langganan:
Posting Komentar (Atom)
EmoticonEmoticon