Kb Use the options button to reveal a options on how to narrow the search parameters. For example to search within a row, column or range of cells

If you select more than one cell excel automatically confines its search to only include those cells. By default excel will search the entire worksheet to find instances of matched data.

Constants, finds all the cells that do not contain formulas or functions in the active worksheet area.

Selecting a cell with a formula and checking Precedents highlight all the cells that are referenced by in the formula or function.

Selecting a data cell and checking dependent highlights all the formula cells that reference the cell.

 Select the formula option and check the error check box to find all the formula cells that contain errors

Blank finds all the cells in the active region of the worksheet that do not contain values formulas, functions e region of the worksheet that do not contain values formulas, functions or labels.

Current, highlights the active portion of the worksheet, great for copy and pasting all the data from a worksheet into a region of another.

Repeatedly pressing the find next button skips to each instance that matches the search conditions highlighting the cells that meet the conditions.

Pressing the “find all” button shows a list of all the instances that match the search conditions. Clicking on an item in the list causes the selection box to go to the selected item.