I am trying to make a spreadsheet that shows the relationship between 3 groups of people. For example, Group C works under Group B, and Group B works under Group A. I want to be able to hide the contents of Group B and Group C. So therefore, I can double click Group A, and the contents of Group B will show up. Then by double clicking Group B, Group C will show up. Any tips?
2006-07-05 08:38:19 · 5 answers · asked by Kim B 2 in Business & Finance ➔ Other - Business & Finance
use Pivot Tables.
Data should be arranged like this.
in coloumn A put Group Name of the Highest Authority
in coloumn B put Group Name for its subordinate
and in Coloumn C Enter the Name of the Last Level Person.
Now from Coloumn D onwards enter the required Data.
Go to Data Menu and Select Pivot Tables.
look for help on Pivot Tables in Excel Help and u will understand how the data should be arranged.
if required, mail me at kiran_j_jain@yahoo.com
Regards,
Kiran Jain
2006-07-06 02:26:05 · answer #1 · answered by Kiran 1 · 0⤊ 0⤋
Maybe you should try pivot tables. You can run a help search for the term "pivot tables" and it should guide you on how to organize the information.
Although, admittedly, I have no real idea how it would be possible to do what you are saying since hiding/unhiding is not a function that a simple double click would toggle.
2006-07-05 09:11:34 · answer #2 · answered by mmenaquale 2 · 0⤊ 0⤋
ya take the class on spreadsheets.
2006-07-05 08:41:38 · answer #3 · answered by zeus_daughter2 5 · 0⤊ 0⤋
I don't know that option but it should be available. try the help menu in excell
2006-07-05 08:44:55 · answer #4 · answered by fasb123r 4 · 0⤊ 0⤋
idk
2006-07-05 08:47:45 · answer #5 · answered by Toki 3 · 0⤊ 0⤋