Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand a box
Hi
I do not know if this is possible but I have a large hierarchy of information and I am trying to set it up on excel so everything is easy to look for. My idea was that I start of with several boxes with eg Waste, Cleaning, Catering etc. You click on the cell or the command box which ever and more options appear eg if you click on catering options appear in a similar fashion as an organisation chart which will say vending, food, coffee etc and when you click on that it expands a column with all the info about that particular subject. Again not sure if it can be done but any other suggestions would be really appreciated. -- Thanks Ruth |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand a box
start here
http://www.contextures.com/xlDataVal01.html Once you grasp the basics, check her site for info on dependent dropdowns. That is the ultimate solution to your question "Ruth" wrote: Hi I do not know if this is possible but I have a large hierarchy of information and I am trying to set it up on excel so everything is easy to look for. My idea was that I start of with several boxes with eg Waste, Cleaning, Catering etc. You click on the cell or the command box which ever and more options appear eg if you click on catering options appear in a similar fashion as an organisation chart which will say vending, food, coffee etc and when you click on that it expands a column with all the info about that particular subject. Again not sure if it can be done but any other suggestions would be really appreciated. -- Thanks Ruth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill and expand | Excel Worksheet Functions | |||
Expand a Spreadsheet | Excel Worksheet Functions | |||
Expand columns | Excel Worksheet Functions | |||
Range that expand | Excel Discussion (Misc queries) | |||
How do I expand the Name Box? | Excel Discussion (Misc queries) |