Search Bar

Michelle Fayed

When using the search bar on a specific sheet to locate all the rows that match, is there a way to highlight all of those rows from the search within the sheet?

I have a sheet with almost 11,000 rows and don't want to go row by row to locate and highlight them and copy them to another sheet.

Thank you in advance for your time, attention and help!

Johnathan Vargas Cruz

If you are only looking for results on a specific sheet, then you could add a filter. It would show only the rows that satisfy the given filter, so you could select all the rows and quickly copy them over that way.