| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
+ / - above column letters
I saw a spreadsheet that had some plus and minus buttons above the column
letters that allows for the columns under them to expand and collapse when clicking the buttons. How do you do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
+ / - above column letters
select a contiguous set of columns or rows and goto <data<group and outline
and select group also check "outline" in help "Stanley" wrote: I saw a spreadsheet that had some plus and minus buttons above the column letters that allows for the columns under them to expand and collapse when clicking the buttons. How do you do that? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
+ / - above column letters
Select the columns, then Data-'Group and Outline'-Group
-- Regards, Dave "Stanley" wrote: I saw a spreadsheet that had some plus and minus buttons above the column letters that allows for the columns under them to expand and collapse when clicking the buttons. How do you do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| How do I change a column of cells to all capital letters? | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Linear Mode
