Change Hyperlink Name in Excel
In this exciting RU-vid video, I will show you a trick to transform your Ugly hyperlink into a User friendly name! No more 1000 character Hyperlinks.
First of all, I will show you a technique to transform a URL into a link by just clicking in the formula bar and pressing Enter. Then we will right click on the link and go to a menu to change the Name of the hyperlink and add a screen tip (small user help when you hover on the link)!
Then, we will look at another way to create a link by directly accessing the menu and changing a few parameters.
Finally, we will look at the hyperlink formula. This formula has a parameter called "Friendly Name". This is how you can automatically give a name to the Hyperlink. The cool part of the formula is that it is dynamic. If something changes, it will automatically update!
***Links
Data: mega.nz/file/qeg3labI#2xOkXyL...
Completed: mega.nz/file/fGhzHQyC#ItqdCb6...
#Excel #MsExcel #exceltutorial
27 янв 2024