My favorite use of the hyperlink function is to create a table of contents or navigation buttons in Excel sheets. It helps ...
If I asked you which Excel tab you use most, there's a good chance the View tab wouldn't even cross your mind. The Insert, Formulas, and Data tabs usually get all the attention, and for good reason.
To display a tooltip, you may use Comments, Notes, Data Validation Help Text, or Screen Tips. Let us see how they work in Excel and Google Sheets.