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