I have created an excel sheet and created multiple groups in the sheet by
grouping rows (selecting rows i want to group - Data - Group and Outline -
group).

Now when i search for a text in the whole excel file (Ctrl+F), i want Excel
to go to the specific cell where the text was found by EXPANDING the group
where that cell belongs. What Excel does right now, is that it only
highlights the group where the cell was, and then I have to manually expand
the group, and the group within the group and dig down the group where it
found the cell. which is very inconvinient.

I would like Excel to itself expand and dig down the groups and directly
show the cell where it found the text. how do i do that?

Thx.