Find/Replace on Range?

A

Al Franz

When I highlight a column or some cells I can not restrict a FINE and
REPLACE to those highlighted cells. Can this be done so that it doesn't
search the whole sheet? Using Excel 2003.
 
G

Gord Dibben

All

When you select a range of cells and specify "within" Sheet from Options the
Find will take place only in the selected range.

If you specify "within" Workbook the Find will ignore your selected range and
do the workbook.

Same goes for Replace.

Gord Dibben Excel MVP
 
Top