Share via

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

Anonymous
2022-03-14T07:24:41+00:00

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

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2022-03-14T09:10:33+00:00

    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

    Was this answer helpful?

    0 comments No comments