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:
- 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).
- Enter the text you want to search for, for example “Ferrari”.
- Нажмите кнопку Find Next (Find below).
Excel will highlight the first occurrence.
- Нажмите кнопку Find Next (Find next) again to highlight the second occurrence.
- To get a list of all occurrences, click on Find All (Find all).
Substitute
To quickly find specific text and replace it with other text, follow these steps:
- On the Advanced tab Home (Home) click Find & Select (Find and highlight) and select Replace (Replace).
A dialog box of the same name will appear with the active tab Replace (Replace).
- Enter the text you want to search for (for example, “Veneno”) and the text you want to replace it with (for example, “Diablo”).
- Click on Find Next (Find below).
Excel will highlight the first occurrence. No substitutions have been made yet.
- Нажмите кнопку Replace (Replace) to make one replacement.
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:
- Select one cell.
- On the Advanced tab Home (Home) click on Find & Select (Find and highlight) and select Go To Special (Selecting a group of cells).
Note: Formulas, comments, conditional formatting, constants, and data validation can all be found with the command Go To Special (Selecting a group of cells).
- Check the box next to Formulas (Formulas) and click OK.
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:
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.