Clicking on numbered boxes, plus and minus sign to show and hide d

O

OpMachinist

I received a spreadsheet that used easy ways to show and hide rows and
columns by clicking on numbered little boxes or plus and minus signs. These
are located above the column headers and to the left of the row numbers. The
boxes are very small numbered boxes that when clicked hide and unhide a
predetermined section of the sheet. I would like to know how to do this.

Thanks,
 
D

Dave Peterson

You can use Data|Group and Outline|group to outline either the rows or columns.

You can also get these outlining symbols on the rows via data|subtotal.
 

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

Top