Find-Replace in specific rows

[ajaykgarg]

I have an sheet with hundreds of rows. I want to find a word only in first 10 rows and replace every occurence in these 10 rows only with another word.

Is it possible?

tia
Ajay

[protonLeah]

Select all ten rows, then, with them still selected, just to a find/replace/replace all....

[ajaykgarg]

Thanks.

Is there any way of accomplishing the same, without having to select the rows?
That is, if these 10 rows are scaterred across the sheet among hundreds of other rows, is there a simpler way of doing it other than selecting the rows before searching?

tia
Ajay

[protonLeah]

....That is, if these 10 rows are [scattered] across the sheet among hundreds of other rows....,

This is a completely different problem from your original post:

I want to find a word only in first 10 rows...

The first ten OCCURRENCES is not necessarily the same as the first ten rows.

Have you tried the macro recorder? You can then modify the macro to loop through the search until it counts ten finds.