en uk

Searching for text Microsoft Office 2007

    You can search for a specific label or number anywhere in your spreadsheet. To search for text or numbers, follow these steps:

    1. Click the Home tab.

    2. Click the Find & Select icon in the Editing group.

    A pull-down menu appears.

    3. Click Find.

    The Find and Replace dialog box appears, as shown in Figure 7-14.

    If you click the Replace tab, you can define the text or number to find and new text or numbers to replace it.

    Searching for text Microsoft Office 2007

    Figure 7-14:

    The Find and Replace dialog box lets you search your worksheet.

    4. Click in the Find What text box and type the text or number you want to find.

    If you click the Options button, the Find and Replace dialog box expands to provide additional options for searching, such as searching in the dis­played sheet or the entire workbook.

    5. Click one of the following:

    Find Next: Finds and selects the first cell, starting from the cur­rently selected cell that contains the text you typed in Step 4

    Find All: Finds and lists all cells that contain the text you typed in Step 4, as shown in Figure 7-15

    Searching for text Microsoft Office 2007

    Figure 7-15:

    The Find All button names all the cells that contain the text or number you want to find.

    6. Click Close to make the Find and Replace dialog box go away.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.