Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand/Collapse Buttons for hidden rows or colums
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand/Collapse Buttons for hidden rows or colums
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. Vineet Anand wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand/Collapse Buttons for hidden rows or colums
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. "Vineet Anand" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Collapse/Expand Buttons in a Pivot Table | Excel Worksheet Functions | |||
How do I move the expand/collapse for rows and columns in Excel? | Excel Worksheet Functions | |||
How do I auto expand hidden rows or columns? | Excel Discussion (Misc queries) | |||
Expand/Collapse Rows | Excel Worksheet Functions | |||
HOW CAN I COLLAPSE AND EXPAND COLUMS | Excel Discussion (Misc queries) |