ExcelBanter - Find Option replacement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Find Option replacement (https://www.excelbanter.com/excel-discussion-misc-queries/176132-find-option-replacement.html)

erick-flores

Find Option replacement

Hello all

Is it possible to have in cell B2 the option to Find something in the
entire worksheet?

Just like Ctrl+F, but I do not want to press Ctrl+F....I just want to
be able to directly type what i am trying to find in B2 and get the
same results as Ctrl+F

thanks in advance

J. Sperry[_2_]

Find Option replacement

You can use conditional formatting, so that everything equal to B2 is shaded
a certain color.

"erick-flores" wrote:

Hello all

Is it possible to have in cell B2 the option to Find something in the
entire worksheet?

Just like Ctrl+F, but I do not want to press Ctrl+F....I just want to
be able to directly type what i am trying to find in B2 and get the
same results as Ctrl+F

thanks in advance

All times are GMT +1. The time now is 02:14 AM.