Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expandable Rows
I am currently working on a spreadsheet that lists 19 stores and within those
19 stores there is a list of employees that I would like to be able to expand in and out as data is needed to input for those employees. How can I get the rows to expand under each store by clicking on the plus symbol to the left of the store? I have seen it done just never did it myself. [+] Store 001 Employee 1 Employee 2 Employee 3 This is roughly how I envision it. Thank you for your help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expandable Rows
Highlight the rows you wnat to group and select Data - Group and Outline -
Group -- HTH... Jim Thomlinson "VegasBurger" wrote: I am currently working on a spreadsheet that lists 19 stores and within those 19 stores there is a list of employees that I would like to be able to expand in and out as data is needed to input for those employees. How can I get the rows to expand under each store by clicking on the plus symbol to the left of the store? I have seen it done just never did it myself. [+] Store 001 Employee 1 Employee 2 Employee 3 This is roughly how I envision it. Thank you for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make rows collapsible and expandable in Excel ? | Excel Discussion (Misc queries) | |||
expandable Text Box | Excel Worksheet Functions | |||
formatting, expandable trees? | Excel Discussion (Misc queries) | |||
how do I make an expandable list in Excel? | Excel Discussion (Misc queries) | |||
expandable listbox | Excel Programming |