Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make an expandable list in Excel?
I'm creating a large spreadsheet that contains quite a bit on qualitative
information (a number of policy options for a number of states). I'd like to be able to make certain categories of information into an expandable/collapsible list, so that other users could choose how much information to display at a time. Is there a way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make an expandable list in Excel?
Hi,
I think what you need is either..... Data/Filter or Data/Group and Outline have a look at those to see if that is what you want. HTH Jean-Guy "lizbgreen" wrote: I'm creating a large spreadsheet that contains quite a bit on qualitative information (a number of policy options for a number of states). I'd like to be able to make certain categories of information into an expandable/collapsible list, so that other users could choose how much information to display at a time. Is there a way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make an expandable list in Excel?
I'd try GROUPS
You must leave a blank column, however. You highlight the section that you want to hide by using the ROW or COLUMN selections (not cell selections). Then: DATA - GROUP & OUTLINE - GROUP This allows you to expand/collapse either rows or columns. Yes you can do both and they can overlap. You get a + or - at the top of the screen - This expands or contracts the sections This is better then "hiding" sections, as you have to highlight then un-hide them. I use it and it works fine. "lizbgreen" wrote: I'm creating a large spreadsheet that contains quite a bit on qualitative information (a number of policy options for a number of states). I'd like to be able to make certain categories of information into an expandable/collapsible list, so that other users could choose how much information to display at a time. Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Excel 2000 print long narrow list "snake" on wide paper? | Excel Discussion (Misc queries) | |||
How do I make a Validation List in Excel, using data on a second | Excel Discussion (Misc queries) | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
How do I make longer a drop-down list (the window) in excel? | Excel Worksheet Functions | |||
Is there a way to make a drop down list in Excel that lets you se. | Excel Worksheet Functions |