From the course: Excel Online Tips and Tricks (Microsoft 365)
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Interact with the web using hyperlinks
From the course: Excel Online Tips and Tricks (Microsoft 365)
Interact with the web using hyperlinks
- [Instructor] Excel for the web makes it super easy to interact with web content. The file you're looking at has a list of staff data including their email addresses. Now, whilst the email addresses are underlined you'll notice that if we try to click on one of them at random, nothing actually happens. Let's change this. Right-click on UN's email address and then select Hyperlink. Make sure that the radio button next to email address has been selected. What we need to do now is copy the display text by using the Control + C keyboard shortcut and then select the email address section and then Control + V on the keyboard. And then click on OK. If you now go ahead and try to click on UN's email address, Excel for the web will try and open your local email client enabling contact to be made with him. The other thing that you may wish to do is add a web link to the location, just in case you want to find out some more…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.