Find and Select in Excel

You can use the tool Find and Replace (Find and Replace) in Excel to quickly find the text you want and replace it with other text. Also you can use the command Go To Special (Select Group of Cells) to quickly select all cells with formulas, comments, conditional formatting, constants, and more.

To find

To quickly find a specific text, follow our instructions:

  1. On the Advanced tab Home (Home) click Find & Select (Find and highlight) and select Find (Find).

    A dialog box will appear Find and Replace (Find and replace).

  2. Enter the text you want to search for, for example “Ferrari”.
  3. Нажмите кнопку Find Next (Find below).

    Find and Select in Excel

    Excel will highlight the first occurrence.

    Find and Select in Excel

  4. Нажмите кнопку Find Next (Find next) again to highlight the second occurrence.

    Find and Select in Excel

  5. To get a list of all occurrences, click on Find All (Find all).

    Find and Select in Excel

Substitute

To quickly find specific text and replace it with other text, follow these steps:

  1. On the Advanced tab Home (Home) click Find & Select (Find and highlight) and select Replace (Replace).

    Find and Select in Excel

    A dialog box of the same name will appear with the active tab Replace (Replace).

  2. Enter the text you want to search for (for example, “Veneno”) and the text you want to replace it with (for example, “Diablo”).
  3. Click on Find Next (Find below).

    Find and Select in Excel

    Excel will highlight the first occurrence. No substitutions have been made yet.

    Find and Select in Excel

  4. Нажмите кнопку Replace (Replace) to make one replacement.

    Find and Select in Excel

Note: Use Replace All (Replace All) to replace all occurrences.

Selecting a group of cells

You can use the tool Go To Special (Cell Group Selection) to quickly select all cells with formulas, comments, conditional formatting, constants, and more. For example, to select all cells with formulas, do the following:

  1. Select one cell.
  2. On the Advanced tab Home (Home) click on Find & Select (Find and highlight) and select Go To Special (Selecting a group of cells).

    Find and Select in Excel

    Note: Formulas, comments, conditional formatting, constants, and data validation can all be found with the command Go To Special (Selecting a group of cells).

  3. Check the box next to Formulas (Formulas) and click OK.

    Find and Select in Excel

    Note: You can search for cells with formulas that return numbers, text, logical operators (TRUE and FALSE), and errors. Also, these options will become available if you check the box Constants (Constants).

    Excel will highlight all cells with formulas:

    Find and Select in Excel

Note: If you select one cell before clicking Find (Find), Replace (Replace) or Go To Special (Select a group of cells), Excel will view the entire sheet. To search within a range of cells, first select the desired range.

Leave a Reply