Up next in 10
How to Remove All Hyperlinks in Excel Workbook with One Click - Create an Excel Add-In
1K views
Mar 1, 2025
Tired of manually removing hyperlinks in Excel? In this tutorial, you'll learn three easy methods to remove hyperlinks from a selection, worksheet, or entire workbook. Then, we’ll take it a step further by creating a custom Excel add-in that lets you remove hyperlinks with a single click—just like a built-in command! You'll also see how to customize the Ribbon by adding buttons for quick access. Make your workflow more efficient with this simple yet powerful automation. Watch now and enhance your Excel skills! Excel Hyperlinks Tutorials: https://youtube.com/playlist?list=PL5Q03Rggd_jIJ6O0C0ZRBi2RVA8xsXVyT&si=e5NovFxNJq8HoMZ2 Excel Add-ins Tutorials: https://youtube.com/playlist?list=PL5Q03Rggd_jJifkO3EaTlSNNzriYSte3y&si=r8gCvnB6BV0TFM3P
View Video Transcript
0:00
welcome to this Excel tutorial in this
0:02
video we'll explore three different
0:04
methods to remove hyperlinks and convert
0:07
them in PL text after understanding how
0:10
each method works we'll take it a step
0:12
further by creating an Excel addin that
0:14
removes hyperlinks with a single click
0:16
whether from a workbook worksheet or
0:18
selection finally we'll insert buttons
0:21
on the Home tab allow you to access this
0:23
functionality from the ribbon whenever
0:25
needed the first method utilizes the
0:27
clear drop down available on the Home
0:29
tab so select the cell containing the
0:31
hyperlink go to the Home tab click the
0:33
clear drop down in the editing group and
0:35
choose remove hyperlinks the hyperlink
0:38
will be removed leaving only the text to
0:40
remove multiple hyperlinks at once
0:43
select all the cells containing
0:44
hyperlinks and follow the same steps the
0:47
second method is even quicker simply
0:49
rightclick the cell containing a
0:51
hyperlink in the menu that appears
0:53
select remove hyperlink to remove
0:55
multiple hyperlinks select all the
0:57
linked cells rightclick any SEL Ed cell
1:00
and choose remove hyperlinks this will
1:03
instantly strip all hyperlinks while
1:05
keeping the text if you frequently need
1:07
to remove hyperlinks VBA can help
1:09
automate the task the previous methods
1:11
are useful but what if you need to
1:13
remove hyperlink from the entire
1:15
workbook instead of manually selecting
1:17
all content on each sheet and using the
1:20
remove hyperlinks command which can be
1:22
timec consuming especially for large
1:24
workbooks VBA provides a faster solution
1:27
if you haven't enabled the developer tab
1:29
yet right click the ribbon select
1:30
customize ribbon check the developer
1:32
option and click okay go to the
1:34
developer tab and click Visual Basic in
1:37
a code group in a VBA editor window
1:39
insert a new module by clicking the
1:41
insert menu and selecting module in the
1:44
newly open module window create a sub
1:46
routine named remove hyperlinks from
1:48
selection and insert the VBA code shown
1:50
on screen this script will remove all
1:53
hyperlinks from the currently selected
1:55
cells in your Excel
1:58
worksheet to test it close the VBA
2:01
editor and go back to the Excel Window
2:03
select a cell containing a hyperlink
2:05
then go to the developer tab and click
2:08
macros in the code group you'll see our
2:10
sub routine listed in the macro dialogue
2:11
box click run and just like that the
2:15
hyperlink is removed leaving only the
2:17
text now try selecting multiple cells
2:20
and running the macro again you'll
2:22
notice that all hyperlinks in the
2:23
selection are removed at once let's take
2:25
this a step further by creating a new
2:27
macro that removes all hyperlinks from
2:29
the active sheet go back to the VBA
2:32
editor and insert another sub routine
2:34
give it a suitable name such as remove
2:36
hyperlinks from sheet this time instead
2:39
of using selection we'll modify the code
2:41
to use active
2:50
sheet now return to Excel and run this
2:53
macro from the macro's dialogue box
2:55
you'll see that it instantly removes all
2:57
hyperlinks from the entire worksheet
2:59
without needing to select
3:05
anything for even greater efficiency
3:08
let's create a macro that removes all
3:10
hyperlinks from every worksheet in the
3:12
workbook go back to VBA editor and
3:14
insert another subroutine this time
3:17
we'll use it for each Loop to go through
3:19
every sheet and remove hyperlinks we
3:21
declare a variable WS to represent each
3:24
worksheet in a workbook the for each
3:26
Loop Cycles through all worksheets one
3:28
by one inside the loop the Ws hyperlinks
3:32
delete command removes all hyperlinks
3:34
from the current worksheet the loop
3:36
continues until every sheet has been
3:38
processed once you run this macro every
3:41
hyperlink in the entire workbook will be
3:43
removed instantly this is especially
3:45
useful when working with large workbooks
3:47
that contain multiple sheets full of
3:49
hyperlinks now let's test it go back to
3:52
the Excel Window open a macros dialogue
3:54
box and run the new macro you'll see
3:56
that all hyperlinks in the entire
3:58
workbook are removed in just one click
4:01
next we'll create an Excel addin and add
4:03
custom ribbon buttons to remove
4:05
hyperlinks from any workbook making it
4:08
as easy to use as a built-in command to
4:10
create an addin first copy the VBA code
4:14
and close your current
4:20
workbook next open a new workbook and
4:23
press alt plus f11 to open the VBA
4:26
editor in the editor insert a new module
4:29
and paste the copied code close the VBA
4:31
editor and save the workbook as an
4:33
excelam file which is the format for
4:36
Excel
4:41
added when you select the xlm extension
4:44
Excel automatically changes the save
4:46
location to the add-in folder this
4:48
ensures your addin is stored where Excel
4:50
can access
4:58
it now go to the developer tab click
5:01
excel addin in the addin group in the
5:03
addin dialogue box will appear listing
5:06
available addins if your remove
5:08
hyperlinks addin isn't in the list click
5:10
browse navigate to the add-ins folder
5:12
select your addin and click open once it
5:15
appears in the list make sure it's
5:16
checked then click okay to activate it
5:19
at this point the addin is active and
5:21
can be accessed from the macros dialogue
5:23
box but we want to integrate it into the
5:25
ribbon just like excel's built-in
5:27
commands such as copy and paste to do
5:29
this let's customize the ribbon before
5:31
starting close all open workbooks or
5:34
restart Excel to ensure the addin loads
5:36
correctly now open a new workbook
5:39
rightclick the ribbon and select
5:41
customize the ribbon from the menu this
5:43
opens the Excel options dialogue box
5:45
with a ribbon customization settings on
5:47
the right side select the tab where you
5:49
want to add the new buttons in this
5:51
example we'll choose the Home tab create
5:53
a new group and name it remove
5:55
hyperlinks
6:05
with a new group selected go to the left
6:07
side of the dialogue box and select
6:09
macros from the choose commands from
6:10
drop-down list since only the addin is
6:13
loaded you'll see the list of macros
6:15
save in your add-in file add each Macro
6:18
one by one rename them appropriately and
6:21
assign suitable icons for easy
6:28
identification e
7:04
click okay to return to excel now you'll
7:07
see the remove hyperlinks group added at
7:09
the end of the Home tab open any
7:11
workbook containing hyperlinks and test
7:13
the buttons you'll see that each button
7:15
works as expected you've now
7:17
successfully created an Excel addin that
7:19
removes hyperlinks from a selected range
7:21
the current worksheet or the entire
7:23
workbook with a single click making your
7:25
workflow more efficient if you want to
7:27
explore more about Excel addin and
7:29
automation check out the tutorials and
7:31
playlists Linked In the description I
7:33
hope you found this video helpful don't
7:35
forget to like share and leave a comment
7:38
your support helps us create more
7:39
valuable content thanks for watching and
7:41
see you in the next tutorial