Change Hyperlink 🔗Name in Excel
Вставка
- Опубліковано 11 вер 2024
- Change Hyperlink Name in Excel
In this exciting UA-cam 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/q...
Completed: mega.nz/file/f...
#Excel #MsExcel #exceltutorial
3 ways to change the name of a hyperlink 😅
But what if I hav 50+ different hyperlinks to add and they need to be shortened?
The best way to do this is to use the hyperlink formula. You should have the shortened name in cells in excel and use the formula (you can drag the formula). In this video, at the end, i show how you can get the names of all the files you have in a folder and extract shorter names to use in the formula. Have a look: ua-cam.com/video/s3RkR60AC28/v-deo.html
My issue is I want to change it from the name back to the url
@@DianasFourreasons if u know the url, then u can use the formula with the url or just the formula and leave the name parameter empty. If ur issue is that u want to extract the url from a link, then it s another video that i did not publish yet