Unhiding group rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....
 
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.
 
You can apply outlining symbols (grouping) by selecting your rows to group, then
Data|Group.
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unhide row formula 1
Cannot unhide the hidden rows in my spreadsheet 3
Need help with Macro 2
hide/unhide macro 2
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
Unhide a row 1
Hide row code help 1
Problem with hidden rows automatically unhiding 2

Back
Top