AuditBible
January 23, 2018, 04:10:43 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   News Alerts Help Search Calendar Members Contributions Staff List Login Register  
NOD32 v3.0 - Save 25% - Download Now 2 Night Free Hotel Stay Banner Big Selection of Computer Memory from MemoryGiant. eBatts.com battery superstore
Del.icio.us Digg FURL FaceBook Stumble Upon Reddit SlashDot Google Bookmarks

Pages: 1   Go Down
  Add bookmark  |  Print  
Author Topic: How to deactivate several hyperlinks at once in Excel  (Read 3851 times)
 
0 Members and 1 Guest are viewing this topic.
beancounter
Administrator
*****
Offline Offline

Gender: Male
Experience: 1985
Posts: 168



Activity
100%


View Profile WWW
« on: August 20, 2008, 04:49:16 PM »

This may sound wierd, but go with me on this one...

  • Type the number 1 in a blank cell, and right-click the cell
  • Click "Copy" on the shortcut menu or click your copy button
  • While pressing CTRL, select each hyperlink you want to deactivate
  • Click "Paste Special" on the Edit menu
  • Under "Operation" click "Multiply" and then click OK

...ta-da! Shocked  The links are gone, but the text remains. Grin
Logged

bc
Click Here - Free Trial of ESET NOD32 Antivirus
Pages: 1   Go Up
  Add bookmark  |  Print  
 
Jump to:  

Related Topics
Subject Started by Replies Views Last post
Excel Tips Excel AuditorLisa 2 3092 Last post July 10, 2008, 11:14:49 AM
by AuditorBob
Topical Index for Excel Help Excel beancounter 0 1786 Last post May 22, 2009, 07:49:53 PM
by beancounter
Excel & Word 2003 to 2007 command reference guide Excel beancounter 0 2470 Last post May 25, 2009, 11:57:42 AM
by beancounter
Excel Viewer Excel beancounter 0 2318 Last post July 29, 2009, 07:11:09 PM
by beancounter
Free Word, Excel and PowerPoint Tech Talk AuditorBob 1 4510 Last post August 02, 2010, 11:20:26 AM
by auditor1

"> 4inkjets! Ink and Toner Cartridges WebEx MeetMeNow Online Meetings MyFax.com - Faxing Simplified Acrobat 8 pro 250x250 Replacement AC Adapters - 1 year warranty
Purchase Trend Micro Internet Security 2008 and ge Compusa (Systemax, Inc.)
Free 3D Koi Fish Screensaver
Free Solar System Screensavers! Compusa (Systemax, Inc.)
SYNCING.NET - Try it now for free SYNCING.NET - Do your Pcs talk to each other



Unique Hits: 1851201
Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines
AuditBible © 2008 | Sitemap
Valid XHTML 1.0! Valid CSS!