Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking on numbered boxes, plus and minus sign to show and hide d
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking on numbered boxes, plus and minus sign to show and hide d
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. OpMachinist wrote: 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, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minus sign | Excel Worksheet Functions | |||
plus and minus sign in cells | Excel Worksheet Functions | |||
I want to display the minus sign | New Users to Excel | |||
Check boxes to show/hide Tabs | Excel Worksheet Functions | |||
HOW DO I HIDE DATA AND SHOW A PLUS SIGN THAT I HAVE HIDDEN DATA H. | Excel Discussion (Misc queries) |