expand/collapse rows without VBA and using hyperlink - how to ?

Question

I've installed recently excel 2016 and when learning it I've opened the telemetryDashboard file

>>>Win→Start→Microsoft Office Tools→Telemetry Dashboard For Office 2016

In this file, it's possible to click on a cell and it will :
a) display rows which were hidden
and
b) change the color of an image.
This looks to be done without any macros and using hyperlinks with defined named.

I don't understand how this works and therefore to do the same in new excel sheet.
If someone could explain how it works ? File is attached but I have as well put above the link where this file is stored when excel is installed.

Thanks

Answer 1

Hi ThanaKanjanawarin,

Thank you for posting your query in our community.

Per your description, you want to know more about Telemetry Dashboard. I found some official articles for your reference:

Guide to Office Telemetry Dashboard resources - Deploy Office | Microsoft Docs

Office Telemetry Dashboard worksheet reference - Deploy Office | Microsoft Docs

Deploy Office Telemetry Dashboard - Deploy Office | Microsoft Docs

However, if you still have questions about it, I sincerely recommend you post the question in office-excel-itpro - Microsoft Q&A, it is the specific channel handling this kind queries, members and experts are professional and will assist you further.

Thanks for your understanding.

Best regards,

Jazlyn