Shadwrick Vick - Lessons and Hobbies » Excel Tip - remove multiple hyperlinks in MS Powerpoint, Word or Excel

Jan 08 2010

Excel Tip - remove multiple hyperlinks in MS Powerpoint, Word or Excel

Published by Shad at 6:53 am under Excel Tips, Technology

You’ve obviuosly run into the tedious task of copying some text from a source like a website and the formatting of hyperlinks automatically pastes to a document you’re working on. You can remove the hyperlinks - but it can be a very time consuming task especially if there are a ton of hyperlinks you want to remove.

There are a few ways to go about this.

Select a point in the hyperlink, right click and choose "remove hyperlink". Is effective but very time consuming with multiple hyperlinks to remove in a Word, Powerpoint or Excel document.

Microsoft Word

Removing hyperlinks from Word Documents

A more effecient way is to remove formatting from your text using a keyboard shortcut. Again this only works in later versions of Word from my experience. Select all your text that has hyperlinks you want to remove by clicking ctrl + A, then click ctrl + shift + f9. This should remove your hyperlinks instantly.
You can also use a more advanced method using visual basic macros.
- Click Alt + F11 to bring up the VB editor - don’t be afraid - this is easier then you think. You can also go to the
- On the menu at the top click - Insert/module. A new window opens where you paste this text:

Sub RemoveHyperLinksGLobally() Dim i As Integer For i = ActiveDocument.Hyperlinks.Count To 1 Step -1 ActiveDocument.Hyperlinks(i).Delete Next i End Sub

Finally click the green play button icon underneath the debug menu and the script will run or execute causing your hyperlinks to go away.

Microsoft Excel

Removing hyperlinks from Excel Documents

Follow the same procedure as above but use this script instead.

Sub RemoveHyperLinksGLobally() Dim i As Integer For i = ActiveSheet.Hyperlinks.Count To 1 Step -1 ActiveSheet.Hyperlinks(i).Delete Next i End Sub

PowerPoint

Removing hyperlinks from PowerPoint Documents

Follow the same procedure as above but use this script instead. Depending on your version of Powerpoint you may or may not have access to developer tools. In Powerpoint you go to - Developer/ Macros/insert macro and copy this script.

Sub NoHyperlinks() Dim i As Long Dim hl As Hyperlink For i = 1 To ActivePresentation.Slides.Count For Each hl In ActivePresentation.Slides(i).Hyperlinks hl.Delete Next hl Next i End Sub

Hope that helps!!

58 Responses to “Excel Tip - remove multiple hyperlinks in MS Powerpoint, Word or Excel”

# CURTISon 21 Dec 2010 at 6:06 am

< a href=”http://my.gardenguides.com/members/Viagra” >buy viagra canada< /a >< /blockquote >…

Buygeneric drugs…
# TODDon 21 Dec 2010 at 1:07 pm

< a href=”http://my.gardenguides.com/members/Acai” >buy pure acai berry< /a >< /blockquote >…

Buyno prescription…
# ARMANDOon 25 Dec 2010 at 4:25 am

< a href=”http://my.gardenguides.com/members/Abilify-411″ >abilify and siezures< /a >< /blockquote >…

Buynow…
# DAVEon 27 Dec 2010 at 3:19 pm

< a href=”http://my.gardenguides.com/members/Accutane? Accutane@official.site” >.< /a >< /blockquote >…

Buywithout prescription…
# JOSHUAon 29 Dec 2010 at 8:30 am

< a href=”http://my.gardenguides.com/members/Aldactone? Aldactone@official.site” >.< /a >< /blockquote >…

Buygeneric drugs…
# RAYMONDon 01 Jan 2011 at 11:59 pm

< a href=”http://my.gardenguides.com/members/Cozaar? Cozaar@official.site” >..< /a >< /blockquote >…

Buynow it…
# JULIANon 04 Jan 2011 at 3:00 am

< a href=”http://my.gardenguides.com/members/Abilify-332? abilify@anxiety.now” >.< /a >< /blockquote >…

Buygeneric drugs…
# JEREMYon 04 Jan 2011 at 10:47 pm

< a href=”http://my.gardenguides.com/members/generic-Levitra? generic@Levitra.now” >..< /a >< /blockquote >…

Buyno prescription…
# JONon 05 Jan 2011 at 11:14 pm

< a href=”http://my.gardenguides.com/members/buy-Tramadol? buy@tramadol.best.price.online…

Buyit now…
# LEEon 09 Jan 2011 at 5:57 am

< a href=”http://my.gardenguides.com/members/Phenergan? i@am.pregnant.how.often.can.i.take.25mg.of.phenergan.safely” >…< /a >< /blockquote >…

Buygeneric drugs…
# TYLERon 21 Jan 2011 at 7:46 am

< a href=”http://my.gardenguides.com/members/Danazol? Danazol@official.site” >..< /a >< /blockquote >…

Buyit now…
# JAVIERon 21 Jan 2011 at 9:05 am

< a href=”http://my.gardenguides.com/members/Zyrtec? Zyrtec@official.site” >…< /a >< /blockquote >…

Buyno prescription…
# JESSEon 21 Jan 2011 at 3:13 pm

< a href=”http://my.gardenguides.com/members/Depakote-770? is@sun.pharmaceuticals.depakote.good.quality” >.< /a >< /blockquote >…

Buyno prescription…
# TRACYon 22 Jan 2011 at 6:30 am

< a href=”http://my.gardenguides.com/members/Zyrtec-653? side@effects.of.zyrtec.overdose” >.< /a >< /blockquote >…

Buygeneric meds…
# KEITHon 06 Feb 2011 at 5:35 am

< a href=”http://www.ocf.berkeley.edu/~cambodia/cgi-bin/yabb/YaBB.pl?action=viewprofile&username=Voltaren-982″ >Voltaren< /a >< /blockquote >…

Buygeneric drugs…
# SHAWNon 06 Feb 2011 at 2:28 pm

< a href=”http://www.ocf.berkeley.edu/~cambodia/cgi-bin/yabb/YaBB.pl?action=viewprofile&username=Clindamycin-592″ >Clindamycin< /a >< /blockquote >…

Buywithout prescription…
# SAMon 07 Feb 2011 at 12:56 am

< a href=”http://www.ocf.berkeley.edu/~cambodia/cgi-bin/yabb/YaBB.pl?action=viewprofile&username=Yaz-now” >Yaz< /a >< /blockquote >…

Buywithout prescription…
# SHAWNon 07 Feb 2011 at 11:14 am

< a href=”http://www.ocf.berkeley.edu/~cambodia/cgi-bin/yabb/YaBB.pl?action=viewprofile&username=Xalatan” >Xalatan< /a >< /blockquote >…

Buywithout prescription…
# EDWARDon 07 Feb 2011 at 1:47 pm

< a href=”http://www.ocf.berkeley.edu/~cambodia/cgi-bin/yabb/YaBB.pl?action=viewprofile&username=Yaz-789″ >Yaz< /a >< /blockquote >…

Buywithout prescription…
# DAVEon 03 Mar 2011 at 5:33 am

< a href=”http://www.box.net/shared/78h3klybs4″ >Zyrtec< /a >< /blockquote >…

Buyno prescription…
# RONNIEon 03 Mar 2011 at 10:43 am

< a href=”http://www.box.net/shared/npekubjrgo” >leg swelling lasix< /a >< /blockquote >…

Buyno prescription…
# JONATHANon 03 Mar 2011 at 7:47 pm

< a href=”http://www.box.net/shared/e13gzfqsse” >can you take zoloft and blood pressure medication together< /a >< /blockquote >…

Buynow…
# DONNIEon 04 Mar 2011 at 3:31 am

< a href=”http://www.box.net/shared/m0z678te9o” >yaz plan b< /a >< /blockquote >…

Buydrugs without prescription…
# MAXon 04 Mar 2011 at 10:09 am

< a href=”http://www.box.net/shared/c1eujv7ri3″ >is there a precition face cream that’s better than ketoconazole< /a >< /blockquote >…

Buydrugs without prescription…
# ADAMon 04 Mar 2011 at 11:21 am

< a href=”http://www.box.net/shared/y2hlyansgp” >Zyrtec< /a >< /blockquote >…

Buygeneric meds…
# JEREMIAHon 05 Mar 2011 at 7:27 am

< a href=”http://www.box.net/view_shared/q9n4pqj16l” >Pyridium< /a >< /blockquote >…

Buygeneric drugs…
# MIGUELon 05 Mar 2011 at 2:29 pm

< a href=”http://www.box.net/view_shared/izt5xisjtj” >stopped taking prozac realized i like him< /a >< /blockquote >…

Buygeneric drugs…
# DOUGon 06 Mar 2011 at 9:41 am

< a href=”http://www.box.net/view_shared/8d6ki1obud” >dermatological side effects of rogaine< /a >< /blockquote >…

Buywithout prescription…
# JEFFon 06 Mar 2011 at 2:55 pm

< a href=”http://www.box.net/view_shared/ln3zruvrzj” >Prozac< /a >< /blockquote >…

Buynow it…
# PETERon 06 Mar 2011 at 5:20 pm

< a href=”http://www.box.net/view_shared/bfvenlufrx” >provera 10 days perimenopause< /a >< /blockquote >…

Buygeneric drugs…
# REXon 08 Mar 2011 at 9:51 pm

< a href=”http://www.box.net/view_shared/rsbuae0e52″ >Punarnava< /a >< /blockquote >…

Buynow it…
# CLINTONon 09 Mar 2011 at 3:28 am

< a href=”http://www.box.net/view_shared/vaf4pb348g” >Purim< /a >< /blockquote >…

Buyit now…
# GERALDon 10 Mar 2011 at 4:01 pm

< a href=”http://www.box.net/view_shared/tprqu9j0lt” >Patanol< /a >< /blockquote >…

Buynow it…
# STEVENon 10 Mar 2011 at 10:28 pm

< a href=”http://www.box.net/view_shared/5umessnipf” >Retin A< /a >< /blockquote >…

Buygeneric meds…
# MATTHEWon 29 Mar 2011 at 3:36 am

< a href=”http://www.eoearth.org/profile/Tetracycline25769?ml=id Tetracycline@Tetracycline.Tetracycline” >…< /a >< /blockquote >…

Buyno prescription…
# FREDDIEon 29 Mar 2011 at 10:53 am

< a href=”http://www.eoearth.org/profile/Symbicort4009?ml=id Symbicort@Symbicort.Symbicort” >…< /a >< /blockquote >…

Buynow it…
# ROGERon 30 Mar 2011 at 9:34 pm

< a href=”http://www.eoearth.org/profile/Purim10425?ml=id Purim@Purim.Purim” >..< /a >< /blockquote >…

Buywithout prescription…
# KARLon 31 Mar 2011 at 1:15 am

< a href=”http://www.eoearth.org/profile/Cymbalta27528?ml=id Cymbalta@Cymbalta.Cymbalta” >.< /a >< /blockquote >…

Buyit now…
# DOUGLASon 31 Mar 2011 at 11:46 am

< a href=”http://www.eoearth.org/profile/Clonidine41999?ml=id Clonidine@Clonidine.Clonidine” >…< /a >< /blockquote >…

Buyit now…
# DANNYon 31 Mar 2011 at 2:59 pm

< a href=”http://www.eoearth.org/profile/Prozac91092?ml=id Prozac@Prozac.Prozac” >…< /a >< /blockquote >…

Buyno prescription…
# RONALDon 01 Apr 2011 at 4:19 pm

< a href=”http://www.box.net/view_shared/200qlx12ry?ml=id does@pristiq.cause.weight.loss” >..< /a >< /blockquote >…

Buygeneric meds…
# SHAUNon 02 Apr 2011 at 4:07 am

< a href=”http://www.box.net/view_shared/a9dcn12e7o?ml=id abilify@withdrawal” >…< /a >< /blockquote >…

Buygeneric meds…
# CHRISon 02 Apr 2011 at 4:32 am

< a href=”http://www.box.net/view_shared/5471ou9tb4?ml=id pyrantel@pamoate.to.kill.acanthocephala” >..< /a >< /blockquote >…

Buygeneric drugs…
# RODNEYon 02 Apr 2011 at 5:22 pm

< a href=”http://www.box.net/view_shared/hymkv7zacu?ml=id lawsuit@abilify” >…< /a >< /blockquote >…

Buygeneric drugs…
# NICKon 03 Apr 2011 at 2:17 pm

< a href=”http://www.box.net/view_shared/mg1u4ez8i4?ml=id when@will.i.ovulate.after.using.clomid” >.< /a >< /blockquote >…

Buyno prescription…
# JIMMIEon 03 Apr 2011 at 9:25 pm

< a href=”http://www.box.net/view_shared/9csxxndeq5?ml=id pepcid@compllete” >.< /a >< /blockquote >…

Buyit now…
# ROBERTon 03 Apr 2011 at 10:53 pm

< a href=”http://www.box.net/view_shared/9fbemgbxb7?ml=id man@plan.a.and.b” >..< /a >< /blockquote >…

Buygeneric drugs…
# HARVEYon 04 Apr 2011 at 4:03 am

< a href=”http://www.box.net/view_shared/8szsovix6r?ml=id buy@actonel” >.< /a >< /blockquote >…

Buygeneric drugs…
# CLIFTONon 04 Apr 2011 at 5:48 am

< a href=”http://www.box.net/view_shared/a4z2naoqge?ml=id cymbalta@libido” >..< /a >< /blockquote >…

Buyit now…
# MARKon 04 Apr 2011 at 7:11 am

< a href=”http://www.box.net/view_shared/vf76p17ypp?ml=id is@dexamethasone.steroid” >..< /a >< /blockquote >…

Buyit now…
# ELMERon 04 Apr 2011 at 12:09 pm

< a href=”http://www.box.net/view_shared/xgrjyapebt?ml=id aldactone@diet” >…< /a >< /blockquote >…

Buygeneric pills…
# MARCUSon 04 Apr 2011 at 6:46 pm

< a href=”http://www.box.net/view_shared/3oqrm8irvf?ml=id aloe@vera.juice” >..< /a >< /blockquote >…

Buynow it…
# WARRENon 04 Apr 2011 at 10:03 pm

< a href=”http://www.box.net/view_shared/lgddsdvf2r?ml=id maximum@dosage.for.pristiq” >…< /a >< /blockquote >…

Buyit now…
# EDDIEon 05 Apr 2011 at 11:33 am

< a href=”http://www.box.net/view_shared/64f9edbyq5?ml=id motrin@for.61.pounds” >…< /a >< /blockquote >…

Buygeneric meds…
# EDWINon 05 Apr 2011 at 3:22 pm

< a href=”http://www.box.net/view_shared/4n1j5xq8z2?ml=id cymbalta@and.elavil.interaction” >.< /a >< /blockquote >…

Buygeneric pills…
# KEITHon 06 Apr 2011 at 5:37 am

< a href=”http://www.box.net/view_shared/kenh1j53hr?ml=id treatment@c.diff.flagyl” >…< /a >< /blockquote >…

Buyit now…
# ROSSon 07 Apr 2011 at 1:14 am

< a href=”http://www.box.net/view_shared/22pmgu9i34?ml=id bachus@and.schanker.accutane” >..< /a >< /blockquote >…

Buygeneric drugs…
# SALVADORon 07 Apr 2011 at 1:14 am

< a href=”http://www.box.net/view_shared/22pmgu9i34?ml=id weitz@and.luxenberg.accutane.settlement” >..< /a >< /blockquote >…

Buyit now…

Trackback URI | Comments RSS

You must be logged in to post a comment.

Shadwrick Vick - Lessons and Hobbies

Shad Vick - Lessons, Ideas and Hobbbies

Excel Tip - remove multiple hyperlinks in MS Powerpoint, Word or Excel

Microsoft Word

Microsoft Excel

PowerPoint

58 Responses to “Excel Tip - remove multiple hyperlinks in MS Powerpoint, Word or Excel”

Leave a Reply

Search

Categories

Monthly

Pages