I search and highlight for a very unique string ie. "Header", find all, highlight all.
With the cells I needed selected, I would like to select the row as well. I tried Shift+Space, but it only selected the row of the last cell selected.
My end goal is to then highlight the rows as a visual aid.
I've seen solutions using filters, but that isn't as clean as what I had described above. And I've seen it done! Many moons ago. It was awesome for what I needed to do. This was when I was younger and before Drive to save it. Clearly, I haven't needed it since, but now I do.
Thank you in advance!