Hidden row (col) buttons

;

;-\)

I have seen Excel sheets with hidden rows where there are +/- buttons in the
left column that allows you to easily hide/unhide the rows (columns).

How is this done?
 
D

Dave Peterson

There are a couple of ways.

One is Data|Subtotals. But you'll see a subtotal line between each group.

Another way is Data|Group.
 

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

Need Help with a VBA subroutine 0
Hide Unhide Button 4
Cell data entering slow! 0
hidden rows, column copy-paste 0
Compare two different workbook sheet to show the difference in text 0
Unable to unhide hidden columns 3
form buttons on sheet collapse on unhide - sometimes 5
Repeating a row other than the 1st row as the header row in a table from next page 1

Top