You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Tips
How-to
News
Videos
Stories
HOT, of course! Well, actually, it depends.
Have you ever:
I don't know about you, but I answered "Only all the time," "Uh huh," "Oh yeah," "Affirmative," and "Yep" to those questions.
Hyperlinks frequently trip people up, so we asked Excel expert Bill Jelen to create videos to answer some of the more common customer questions. Check 'em out. Do they help?
Question
Answer
See for yourself
How can I select a cell that contains a hyperlink without suddenly jumping to the link destination?
To select a cell with a hyperlink without actually activating that link, click outside the cell, and then use one of the arrow keys to navigate to the cell. You can also press CTRL and then click the cell. Or, click on the hyperlink and hold for about two seconds. When you see the hand icon change to a white plus icon, let go of the mouse.
Video: Selecting hyperlinked cells
How do I remove one or more hyperlinks? How do I turn off the automatic creation of hyperlinks?
Excel 2010 has two new menu items that can help you remove multiple hyperlinks at once: Remove Hyperlinks (note the plural!) and Clear Hyperlinks. These commands allow you to instantly clean up a whole list of links. If you're using an ancient version of Excel, Bill shows you how to use a macro instead. Bonus: Learn how to stop Excel from automatically creating hyperlinks as you type.
Video: Get rid of hyperlinks
What do I do when I paste a column of URLs into Excel but none of the links are hot?
In this scenario, you must convert the text into actual hyperlinks. If you just have a few links to convert, press F2 to edit the cell, and then press ENTER. If you need to fix a huge list of links, you can use the HYPERLINK function.
Video: Hyperlinks aren't hot
I pasted a large number of links from a web page into Excel, but I only see the display name. How can I show URLs instead of friendly names?
You can use a simple macro to automatically extract URLs (e.g., http://www.microsoft.com/en-us/default.aspx) from friendly names (e.g., Microsoft web site).
Video: Show URLs instead of friendly names in pasted text
When should I use the HYPERLINK function instead of the Insert Hyperlink command? What's the diff, anyway?
If you just have a few links to create, you can use the Insert Hyperlink command. If you need to deal with a whole bunch of hyperlinks, again, consider the HYPERLINK function. Bonus: Watch Bill take columns that contain bits of a URL and join them into a single URL for use with the HYPERLINK function.
Video: Insert Hyperlink vs. =HYPERLINK
How can I create email links from the text in several different columns?
Say that you have first names in column A and last names in column B. You can combine the ampersand symbol (&) and the HYPERLINK function to build email addresses. When you click the link, your e-mail program automatically starts and creates an e-mail message with the correct address in the To box.
Video: Create a mailto hyperlink
For more tips, visit Bill's site, MrExcel.com.
--Anneliese Wirth
Comments: (6) Collapse
Great find! It seems as though if I don't have the problem of accidently clicking on a hot link, I am probably struggling to make a long list of links clickable.
Not anymore!
Hiya, CommissionsPRO. So glad you found this useful. Bill just told me about yet another technique to prevent the accidental clicking issue, which I added to the table above. Click on the hyperlink and hold for about two seconds. When you see the hand icon change to a white plus icon, let go of the mouse.
Have fun out there!
How to make a shortcut in Excel to a picture. I have a large file in Excel over 3000 items & want to link pictures with each, how to do this with a shortcut.
Ann, you can link to images. There are a few different ways to approach this. For example, you might choose to show hyperlinked images in cell comments. That technique is outined by Ron Coderre, one of our MVPs:
http://bit.ly/hZIijK.
If that doesn't help, your best bet is to repost your question in the Excel forum on the Microsoft Answers site (http://bit.ly/dNAfLZ). Our MVPs and other community experts are active in those forums, and they can help you figure out the best way to tackle your particular problem. When you post, it's a good idea to provide very specific detail about what you're attempting to do and the things you've already tried. Makes it a lot easier to troubleshoot and offer up solutions and fixes.
Have a great weekend.
- Anneliese
There's also a need to change a hyperlink for multiple cells at once. "Replace All" doesn't do this.
Hi Mantvydas: You're right, that's a tricky scenario, too. You can find and replace parts or all of the URL if you can see it in the cell, but if you can't (i.e., the URL is hidden behind display text), then you may need a macro. Check out this post on the Microsoft Answers site and see if it helps: http://bit.ly/f4isn9
- A