Expand/Collapse Buttons for hidden rows or colums

V

Vineet Anand

After I hide 5 rows, how can I place a '+' button above the first hidden
row, which when clicked, would unhide the subsequent 5 rows ? The button
would then revert to '-' and perform the reverse function when clicked.

I remember seeing it on a worksheet once; if I know the above, I guess
it would work the same for columns.

- Many Thanks
 
D

Dave Peterson

In xl2003 menus:

Select the rows.
Data|Group and outline|group

And then:
Data|Group and outline|Settings
and uncheck "Summary rows below detail"

You can also get these outlining symbols by using Data|subtotal.
 
P

PJ

Hi Vineet

I think you might have seen a worksheet with subtotals on it.

This is from Excel Help: "When you insert automatic subtotals, Excel
outlines the list so that you can display and hide the detail rows for each
subtotal."

So far as I know, this only works for rows.
 

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

Create form with checkbox les that expand and collapse sections of the form? 0
Expand Collapse Buttons 0
form buttons on sheet collapse on unhide - sometimes 5
hidden rows and autofill troubles 0
Pivot Table Expand Collapse not showing for Cube 2
Problem with hidden rows automatically unhiding 2
group/ungroup column/row buttons 5
Command buttons linked to moving rows 2

Top