Up next in 10
Excel Hyperlink Basics: Use Create Hyperlink Dialog to Create, Modify, and Remove Links
559 views
Dec 4, 2024
This tutorial covers everything from linking within a single sheet to creating links between workbooks, accessing web pages, and even setting up email hyperlinks. Perfect for beginners and Excel enthusiasts alike! 00:00 Introduction 00:27 Creating Hyperlinks within a Sheet 01:05 Modifying Hyperlinks 01:36 Linking Named Ranges 02:15 Removing Hyperlinks 02:42 Linking Cells in Another Sheet 03:48 Linking Another Workbook 04:29 Linking Cells in Another Workbook's Sheet 05:01 Linking to a Cell in Another Workbook (with spaces in sheet name) 05:32 Linking Named Ranges in Another Workbook 06:07 Linking Web Pages 07:17 Linking New Workbook 08:24 Linking Emails
View Video Transcript
0:00
hi everyone and welcome in this video
0:03
we'll explore how to create and use
0:04
hyperlinks in Excel we'll cover creating
0:07
links within a single sheet between
0:09
sheets to other workbooks web pages and
0:12
even links for sending emails hyperlinks
0:14
are a powerful feature that allows you
0:16
to create clickable links in your
0:17
spreadsheets these links can instantly
0:19
take you to specific locations within
0:21
the same sheet other sheets in your
0:23
workbook external files or websites
0:26
let's Dive Right In let's start by
0:28
creating hyperlinks within a single
0:30
sheet which is useful for quickly
0:31
navigating between sections of your data
0:34
to add a hyperlink first select the cell
0:36
where you want it to appear then press
0:38
contrl K or go to the insert tab on the
0:40
ribbon and click on link this opens the
0:43
insert hyperlink dialogue box in the
0:45
link to section choose place in this
0:47
document you'll now see a list of all
0:49
worksheets and any named ranges in your
0:51
workbook with your current worksheet
0:53
selected by default enter the cell
0:55
reference you want to link to in the
0:56
type the cell reference field and click
0:58
okay your hyperlink is now created click
1:01
on it to jump directly to the link cell
1:04
to edit the hyperlink select the cell
1:06
containing it and open the insert
1:08
hyperlink dialogue box again if you need
1:10
to select a cell that already contains a
1:12
hyperlink click an empty part of the
1:14
cell or click a neighboring cell and use
1:16
the arrow keys to move over once in the
1:18
dialogue box update the cell reference
1:21
as needed you can also change the
1:23
display text in the text to display box
1:25
when you're finished click okay your
1:27
link is now updated click the modified
1:29
link and Excel will navigate to the new
1:35
location to link to a named range or
1:38
named object start by selecting the cell
1:40
where you want the hyperlink to appear
1:42
press contrl K to open the insert
1:44
hyperlink dialogue box under the link to
1:47
section choose place in this document in
1:49
nub or select a place in this document
1:51
box you'll see a list of names under
1:53
Define names select the name you want to
1:56
link to you can also customize the text
1:58
that appears for the link by editing the
2:00
text to display field once you're done
2:02
click okay your hyperlink is now created
2:05
click on it to jump directly to the
2:07
named range or object when clicked Excel
2:10
not only jumps to the location but also
2:12
selects the entire named range if you
2:15
need to delete the hyperlink select the
2:17
cell containing it press contrl K to
2:19
reopen the edit hyperlink dialogue box
2:22
and click remove link click okay and the
2:24
hyperlink will be deleted alternatively
2:27
you can remove multiple hyperlinks at
2:29
once select the cells with links go to
2:31
the Home tab find the editing group
2:33
click the clear dropdown and choose
2:35
remove hyperlinks this will delete all
2:38
selected
2:42
hyperlinks to create a hyperlink to a
2:44
cell reference on another worksheet
2:46
Begin by selecting the cell where you
2:47
want the hyperlink press contrl K to
2:50
open the insert hyperlink dialogue box
2:52
in the link to section choose place in
2:54
this document in nub or select a place
2:57
in this document box select the target
2:59
sheet from the list list such as
3:00
employee list enter the specific cell
3:03
reference in the type to sell reference
3:04
field such as A35 to link to sell A35 on
3:08
the employee list sheet you can also set
3:10
a screen tip which will appear when you
3:12
hover over the link to provide
3:14
additional information click okay to
3:16
create the link now when you click the
3:18
hyperlink Excel will jump directly to
3:20
the specified cell on the employee list
3:24
sheet if you want to link to a named
3:27
range on a different worksheet you don't
3:29
need to select a spefic specific sheet
3:30
in the insert hyperlink dialogue box as
3:32
named ranges are Global across the
3:34
workbook simply choose the named range
3:36
under the defined names list and Excel
3:39
will link to it no matter which sheet it
3:40
resides
3:46
on next we'll explain how to create a
3:49
hyperlink that links to a specific sheet
3:51
and cell within another Excel workbook
3:53
to demonstrate we'll create hyperlinks
3:55
in a new workbook that point to the
3:57
employees. xlsx file first open a new
4:00
workbook and select the cell where you
4:02
want the hyperlink press control K or go
4:05
to the insert Tab and select Link in the
4:07
link to section choose existing file or
4:10
web page browse to locate the Excel
4:12
workbook you want to link to select it
4:14
and click okay now when you click the
4:17
hyperlink a security warning may appear
4:19
this typically happens because you're
4:21
linking to an external file and Excel is
4:24
verifying that the link leads to a safe
4:26
location click okay to open the linked
4:28
workbook now next we'll update the
4:30
hyperlink to link directly to sell a
4:32
one-on sheet two in the employees. xlsx
4:35
workbook press contrl K to open the edit
4:38
hyperlink dialogue box in the address
4:40
field at the bottom appin the sheet name
4:43
sheet two and cell reference a one to
4:45
the workbook path to do this add a
4:48
hashtag symbol after the file path
4:50
followed by the sheet name an
4:52
exclamation mark and a cell reference
4:54
now when you click the hyperlink it will
4:56
open employees. xlsx navigate to sheet 2
5:00
and select CA 1 next we will link to the
5:03
sheet employee list since the sheet name
5:05
contains a space Excel requires the
5:08
sheet name to be enclosed in single
5:10
quotes to ensure the hyperlink works
5:12
correctly when linking to a sheet with
5:14
spaces in its name you must enclose the
5:16
sheet name in single quotation marks
5:18
this tells Excel to treat the entire
5:20
name as a single entity including the
5:23
space now when you click the hyperlink
5:25
Excel will open employees. xlsx navigate
5:29
to the employee list sheet and select
5:30
cell A1 you can also create hyperlinks
5:33
to named ranges or objects in another
5:35
workbook for example in the employees.
5:38
xlsx workbook we've created a named
5:40
range called departments which contains
5:43
a list of all departments to link to
5:45
this named range from another workbook
5:47
you don't need to specify the sheet name
5:49
or cell reference simply add the hashtag
5:51
symbol after the workbook name followed
5:53
by the name of the named range or object
5:56
when you click the hyperlink Excel will
5:58
open the employees. xlsx workbook and
6:01
navigate directly to the Department's
6:03
named
6:06
range now let's look at how to create a
6:09
hyperlink to a web page in a Cell the
6:11
quickest method is to Simply type the
6:12
URL directly into the cell and press
6:15
enter Excel will automatically convert
6:17
the URL into a clickable link which
6:20
opens in your web browser when clicked
6:22
alternatively you can create the link
6:23
using the insert hyperlink dialogue box
6:26
press contrl K or go to the insert Tab
6:28
and select link in the link to list
6:31
choose existing file or web page then in
6:33
the address box type the URL of the web
6:36
page you want to link to click okay to
6:38
close the dialogue box this creates a
6:40
clickable link in the cell which will
6:42
open the web page in your browser when
6:44
clicked by default Excel displays the
6:46
full URL in the cell if you prefer to
6:49
display custom text instead of the URL
6:51
you can change it into text to display
6:53
field in the insert hyperlink dialogue
6:55
box simply enter your desired text here
6:58
and the URL in the address box you can
7:00
also assign a hyperlink to a cell that
7:02
already contains text open the insert
7:04
hyperlink dialogue box type the URL in
7:07
the address box and click okay the
7:09
cell's existing text will become a
7:11
clickable link that opens the URL in
7:13
your browser when
7:15
clicked to insert a hyperlink to a new
7:17
Excel workbook you can use the create
7:19
new document option in the insert
7:21
hyperlink dialogue box this feature lets
7:24
you create a new Excel workbook or other
7:26
types of documents directly from the
7:27
hyperlink dialogue by clicking the
7:29
change button if you want to specify a
7:31
different document type using Create new
7:33
document saves time compared to the
7:35
longer process of creating a new
7:37
workbook from the file menu saving it
7:39
and then returning to your original
7:41
workbook to insert a hyperlink instead
7:43
you can create the new workbook name it
7:45
select its save location and even choose
7:48
to open it immediately for editing all
7:50
from the insert hyperlink dialogue box
7:52
for example we can create a new workbook
7:55
named ABC without specifying the file
7:58
extension Excel will automatically
8:00
assign xlsx as the extension assuming we
8:03
want to create an Excel file after
8:05
setting the name if we choose edit the
8:08
new document later Excel will simply
8:10
insert the hyperlink when you click the
8:12
hyperlink it will open the newly created
8:14
workbook this approach offers a seamless
8:17
way to link to new documents while
8:18
keeping your workflow efficient Excel
8:21
also allows you to create hyperlinks
8:22
that open the default email client and
8:24
start a new email with a preconfigured
8:26
recipient and subject to create an email
8:29
Hy link press contrl K or go to the
8:31
insert Tab and click link select email
8:34
address from the left panel in the email
8:36
address field typ the email address you
8:38
want the link to direct to optionally
8:40
you can also pre-fill the subject line
8:42
for the email customize the text to
8:44
display field to show the text you want
8:46
to appear in the cell click okay to
8:48
insert the hyperlink now when you click
8:51
this hyperlink it will open the default
8:53
email client with a new message address
8:55
to the specified email such as info@
8:57
brain.com and with the subject line
9:00
preset to sending from my Excel sheet
9:02
you can then write the body of the email
9:04
and send it directly thank you for
9:06
watching if you found this video helpful
9:08
please give it a thumbs up and consider
9:10
subscribing for more Excel tips and
9:12
tutorials don't forget to hit the
9:13
notification Bell so you never miss an
9:15
update your support helps us continue
9:18
creating valuable content See you in the
9:20
next video