ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature)

Toggle fullscreen Fullscreen button

Sharing buttons:

Let's take a look at how we can use hyperlinks in Excel

so we can quickly jump to different places in our file.

This is especially good for the bigger files you work with.

Now we're also going to take a look

at how you can quickly create a back button

to your starter index sheet

from all the other tabs in one go.

Now we're also going to take a look

at creating friendly hyperlinks using formulas,

and how you can change the color of the hyperlinks

in case that color bothers you.

(rhythmic music)

To add a hyperlink in an Excel cell,

all you have to do is type in the link,

so let's say I want to add a link to a specific blog post.

Press Enter, and Excel is going to recognize it as a hyperlink.

So I'm able to click on it

and it's going to take me to this blog post.

Now sometimes you might not want to show the entire link.

You might want to show a friendly name or add a screen tip.

You can edit this hyperlink.