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? |
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? |
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? |
All times are GMT +1. The time now is 11:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com