LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BenJAMMIN
 
Posts: n/a
Default Remove Hyperlinks...show the Path


If you would like to permanently display the path in the
cell (i.e. replace microsoft with www.microsoft.com), right click on the
cell, and use edit hyperlinks. The top pane shows the display name, the
bottom pane shows the path. Copy the path to the display name. I am not
sure if there is a quick way to do this. NOTE: You will have to use keyboard
commands to copy and paste.

This solution works, but it is one by one. Does anyone k now of a mass
change method? I want to take a hyperlinked word (web address or email
address) and have it display the hyperlink properties instead of the word.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove hyperlinks westy Excel Discussion (Misc queries) 1 March 20th 05 12:05 AM
How to remove all hyperlinks from a worksheet in Excel? Amos Excel Worksheet Functions 4 March 6th 05 11:16 PM
remove hyperlinks Dave Excel Discussion (Misc queries) 2 March 4th 05 12:40 AM
How to change the Excel Title Bar to show the full file path na... lmilkey8855 Excel Discussion (Misc queries) 2 January 6th 05 03:08 PM
remove all Hyperlinks at one time. afglass Excel Discussion (Misc queries) 2 January 2nd 05 05:47 PM


All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"