Unhiding group rows

L

Lp12

Hi All,

I hide some rows (4-8 for example) and then i group rows 1-10.
when i expend the grouped rows (pushing the + )the hidden rows become visible.
How can i pervent this?
thanks a lot....
 
S

swatsp0p

I'm not sure how you "group" rows. You can 'group' objects, items in a pivot
table and buttons on a menu bar. More info, please.
 
D

Dave Peterson

You can apply outlining symbols (grouping) by selecting your rows to group, then
Data|Group.
 
D

Dave Peterson

I don't think you can.

Maybe you could use data|filter|autofilter instead and mark each row that you
want to hide (and filter to show the ones you want.)
 
Top