Document Hyperlinks from Pasted Text with Excel |
Post Reply |
Author | |
Crystal Long
Microsoft MVP Joined: 21 May 2012 Location: Colorado Status: Offline Points: 35 |
Post Options
Thanks(0)
Posted: 16 Aug 2013 at 4:42pm |
Document Hyperlinks from Pasted Text with Excel' Document hyperlinks in the Active Workbook ' to the first sheet in a new workbook (AllHyperlinks) For instance, I copied information from a web page to an Excel worksheet so I could get data with hyperlinks.
When the AllHyperlinks page is created, the top row is frozen so you can always see the column labels even if you have a lot of data. AutoFilter is also turned on so you can find information quickly. Click on the down-arrow in any column label. For instance, here is "TextToDisplay" for my sample data.
Warm Regards, Crystal Microsoft MVP Classroom and Remote Training and Development ... Connect to me, lets build it together! free book, tips, and tools: http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * |
|
Warm Regards,
Crystal Microsoft MVP Remote Training & Programming Let's Connect and Build Together http://www.AccessMVP.com/strive4peace http://YouTube.com/LearnAccessByCrystal ~have an awesome day ~ |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |