Another way to select cells is to use Excel’s Home?Editing?Find & Select?Find command (or press Ctrl+F), which enables you to select cells by their contents. Click the Options button to display additional choices for refining the search.

Enter the text that you’re looking for; then click Find All. The dialog box expands to display all the cells that match your search criteria. For example, Figure 14-16 shows the dialog box after Excel has located all cells that contain the text Tucson. You can click an item in the list, and the screen will scroll so that you can view the cell in context. To select all the cells in the list, first select any single item in the list. Then press Ctrl+A to select them all.

FIGURE 14-16
The Find And Replace dialog box, with its results listed.

Note that the Find and Replace dialog box allows you to return to the worksheet without dismissing the dialog box.

• Excel How-to: Creating a Pivot Table A pivot table is a merely a summary of data in a format that you can manipulate to suit your...
• Quick! Hide the screen! - The Mysterious Windows Key [/caption] Tips and shortcuts for easy and efficient PC use. Following in the foot steps of my Window's Run Commands...
• Go For Pay Per Click Search Engines Most of us are utilizing serps once we are on the lookout for one thing within the internet. However did...
• Tips For Cost Effective Pay Per Click Advertising Pay per click advertising is one of the fastest ways to targeting potential customers to your business products or services....
• How To Make Money With Google Adsense Human Psychology and making money with Adsense. [ad#adstext1] In many ways, to see good results with Google AdSense requires a...