select entire row after using CTRL+F

[teie0103]

after finding cells that contain certain text using CTRL+F, how do I select the entire row that contains that cell ?

[6StringJazzer]

After the CTRL+f find the cell, click SHIFT+SPACE

[teie0103]

Attachment 754287

well . there are multiple rows . and this happens when I press shift space

[6StringJazzer]

That technique selects the entire row for whatever cells are selected. However, it will not work for a discontiguous selection.

What are the steps you took to reach the condition in the image you attached?

If you are selecting multiple cells that are discontiguous then you either have to do this manually or write a macro to do it.

[teie0103]

trying to select all cells that contain AUS . and yes there is a discontiguous selection.

I ctrl+f for the (AUS) keyword . thats it . pressing shift backspace selects only a part of rows .

[6StringJazzer]

When I do that it only selects one cell. Nevertheless, there is no built-in solution that I am aware of.

[teie0103]

ok . I will select them one by one I think.
thanks !