Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
adding multiple hyperlinks in excel?
got a brand master list of 4000 items. i need to assign a picture file to every single item. is there a way to add multiple successive hyperlinks?
2 Answers
- garbo7441Lv 79 years agoFavorite Answer
About the only 'easy' way is to use VBA. However, your image names would have to be identical to the item names, and in the same path.
- Anonymous5 years ago
Not sure if this works for all versions of Excel but it works in 2003. First enter your email into any cell and press enter. Now hover your cursor over the front of the address and you'll eventually see a little box appear below the address. When you mouse over it a small window with the tool tip "AutoCorrect Options" will appear. Press the downward pointing arrow and choose "Stop Automatically Creating Hyperlinks". You can also get to the AutoCorrect Options by going to the Tools menu.
