EXCEL REPORT

[Angelika Jackson]

My supervisor would like me to set up my spreadsheet
(which contains various columns of information for the
item list in the first column). Is there a way that when
my supervisor clicks on "C1" it will show all the
information that is in "C2" through "C15" similar to how
an inserted comment works.

 

[Dave Peterson]

And maybe you could use Data|Subtotals. This will group (er, subtotal) like
data together. (Sort your data first.

Then you can use the outlining symbols to the left to hide/show details.

(Try it against a copy of your workbook--just in case.)