How can I click inside of a Cell of a Worksheet that contains a Hyperlink without actually following that Hyperlink? I need to work within these cells... Tod...
Transcript of the video:
"Don't Fear The Spreadsheet" - Selecting -Or Not Selecting- Hyperlinks in Excel: Podcast #1601
Don't Fear the Spreadsheet, episode number 13: Selecting Hyperlinks.
Alright, Bill Jelen from MrExcel.com. Joined by Tyler Nash. Tyler, what's today's question?
Tyler Nash - A co-worker of mine just sent me a worksheet that I need to do some editing in, and there's tons and tons of hyperlinks in the cells; and I need to be able to click inside those cells without actually following the hyperlink. Is there a way that I can do that?
Hey, that's sweet! I like that co-worker of yours, Tyler, because they sent you a list of articles; this is copied and pasted from the MrExcel articles page. And so, all of these are live hyperlinks.
Now, I don't know why you'd want to get rid of the hyperlinks, because they all lead to a great article, right. You click and it opens your Web page, and you are going to be able to see all kinds of stuff. Why do you want to get rid of these, uh, these hyperlinks. But I understand, Excel is notorious, right, you just come here and type anything that seems, you know, remotely like either an email address or anything; and they change the color, they make it a hyperlink, you know.
So, if you see it right after it happens you can say, “Undo Hyperlink”; or you can even say, “Hey, stop doing this”, all right. So, I'll just undo hyperlink. But in this case we just have hundreds of these, that we have to, to -- you know, work with and the frustrating thing is when you go click the cell it takes you to the page again.
So, two solutions to this: the solution I always use, I just come to a cell that doesn't have a hyperlink and then I use the arrow keys to get in. But as one of the viewers of the MrExcel podcast pointed out, there is an official way to do it, which I don't quite like. You actually click on the cell and hold the mouse button down. When the hand changes to a plus sign there, you can click and you selected the cell; so click, hold, there. What's the -- so it's a hand, click, plus. Takes about half a second, not that bad, but once you're in you can use the arrow keys.
Hey, if you happen to be in Excel 2010, by the way, there is this cool new feature. It's out on the Home tab: this little eraser here. In Excel 2010, if you select a bunch of cells, and more than one of those cells have a hyperlink, then they will give you this “remove hyperlinks” which will remove them all. Now, hey, in real life, what you really might want to do with this is extract the address from the hyperlink. That's beyond the scope of this book but if you go out to YouTube and you search for learn Excel #664, you will get this video that shows you a small little macro you can use to get all of those hyperlinks into another color.
Hey, “Don't fear the Spreadsheet” - a great book - a beginner book for Excel - $14.95. Goes through 150 Q&A; the podcast here is just going to do about 20 of these. There's a lot more in the book. It'll get you from level 1 up to level 4. This book makes “Excel for Dummies” look like it was written for rocket scientists.
Keywords for this video: Hyperlink, URL, accounting, Accounting Major, Bill Jelen, Books, business, Business Major, CPA, Don't Fear The Spreadsheet, eLearning, Excel Basics, Excel Be...
This video is current as of September 17, 2012