ExcelBanter - EXCEL REPORT

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - EXCEL REPORT (https://www.excelbanter.com/excel-programming/274522-excel-report.html)

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.

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.)

Angelika Jackson wrote:

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