As you use Excel, you may need to locate specific types of cells in your worksheets. For example, wouldn’t it be handy to be able to locate every cell that contains a formula—or perhaps all the cells whose value depends on the current cell? Excel provides an easy way to locate these and many other special types of cells. Simply choose Home?Select & Find?Go To Special to display the Go To Special dialog box, shown in Figure 14-15.

FIGURE 14-15
Use the Go To Special dialog box to select specific types of cells.

After you make your choice in the dialog box, Excel selects the qualifying subset of cells in the current selection. Usually, this subset of cells is a multiple selection. If no cells qualify, Excel lets you know with the message No cells were found.

When you select an option in the Go To Special dialog box, be sure to note which suboptions become available. For example, when you select Constants, the suboptions under Formulas become available to help you further refine the results. Likewise, the suboptions under Dependents also apply to Precedents, and those under Data Validation also apply to Conditional formats.

• Network Marketing - Fixing Problems From The Ground Up A good majority of people don't really understand network marketing it is like they love the comp plan but they...
• Excel How-to: The GETPIVOTDATA Function In a previous post, we created a simple pivot table from a list of Excel data.  Today, we'll link the...
• Satya Sai Baba Incense Collection - 25 Boxes, 21 Different - All the Satya Varieties At One Time User Reviews Send this to a friend Satya Sai Baba Incense Collection - 25 Boxes, 21 Different - All the...
• Stem Cells Treat MS Image via Wikipedia Promising results from a small study may offer hope for the treatment of multiple sclerosis (MS). Researchers...
• How To Repair Windows XP File System Using SFC If your PC is running XP, chances are that you will know when there is a problem with the file...